Oracle9iNewFeatures

Oracle9iNewFeatures - Oracle 9i New Features for DBAs...

Info iconThis preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
April 20 th , 2004 9:15 AM Oracle 9i – New Features for DBAs Presented by Mike Strong – Senior DBA Tobin International
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
July 15, 2011 2 Oracle 9i Provides many new features, including a number of new tools to ease administration of the Oracle database Architecture changes Performance improvements availability and recoverability improvements
Background image of page 2
July 15, 2011 3 Oracle Managed Datafiles (OMF) Provides the ability to have Oracle manage datafiles, tempfiles, online redo logfiles and control files automatically Will create database datafiles and tempfiles in directory designated by the db_create_file_dest initialization parameter Will create online redo logfiles and control files in the directory designated by the initialization parameter db_create_online_log_dest_n Files get Oracle-generated names like ora_<ts_name>_<unique character string>.dbf, ora_<log group number>_<UCS>.log, etc. Can automatically drop data file associated with tablespace Can create a database using OMF just by issuing the command ‘CREATE DATABASE;’
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
July 15, 2011 4 Managing shared memory areas Will support multiple block sizes Can set new block size for any tablespace except system, temporary and redo tablespaces Can set up subcaches in the SGA for each block size (db_<block size>_cache_size) DB_BLOCK_BUFFERS parameter depreciated Replaced by db_cache_size BUFFER_POOL_KEEP parameter depreciated Replaced by db_keep_cache_size BUFFER_POOL_RECYCLE parameter depreciated Replaced by db_recycle_cache_size In Oracle 9i, the db_keep_cache_size and db_recycle_cache_size are separate memory areas and are not allocated out of the default buffer pool as they were in Oracle 8i
Background image of page 4
July 15, 2011 5 Managing shared memory areas The alter system SQL command can dynamically alter the: Default buffer cache size Memory subcaches Shared pool The redo log buffer, large pool and java pool cannot be dynamically resized The maximum size of the SGA is set by the sga_max_size initialization parameter
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
July 15, 2011 6 Default temporary tablespace Provides for a default temporary tablespace used for sort operations, etc. Can be set at database creation or set or changed after
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 21

Oracle9iNewFeatures - Oracle 9i New Features for DBAs...

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online