DB_FILE_MULTIBLOCK_READ_COUNT
Per note 841444.1 How To Set DB_FILE_MULTIBLOCK_READ_COUNT in 10g
Oracle Database 10g Release 2 automatically selects the appropriate value for this parameter depending on the operating system optimal I/O size and the size of the buffer cache. After unset it, db_file_multiblock_read_count=128 for our system.
AQ_TM_PROCESSES
Per Note 305662.1 Queue Monitor Process: Architecture and Known Issues
For version 10.1 onwards it is no longer necessary to set AQ_TM_PROCESSES when Oracle Streams AQ or Streams is used.
alter system reset aq_tm_processes scope=spfile sid='*';
_pga_max_size
Per Note 844542.1 PGA_AGGREGATE_TARGET Assigned Memory Is Left Unconsumed When Set High
It was needed to fix a bug in 9i to 10gR1.
LOG_CHECKPOINT_TIMEOUT
LOG_CHECKPOINT_INTERVAL
FAST_START_IO_TARGET
Per Note 472821.1 Which Checkpoint Parameters to Set in Oracle 10g?
Just set FAST_START_MTTR_TARGET instead.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment