 |
|
Oracle _db_writer_flush_imu tips
Oracle Tips by Burleson Consulting |
Question:
When is it safe to set the _db_writer_flush_imu=false
hidden parameter?
Answer:
No hidden parameter should be set without the direction of
Oracle Technical support, but the _db_writer_flush_imu
hidden parameter (and
_imu_pools)
is set in several
TPC world record benchmarks,
setting _db_writer_flush_imu=false.
An IMU is an In-memory Undo,
essentially, the contents of the log_buffer region within the
SGA.
The IMU parameters likely control
the flushing of the log buffer to the online redo logs.
 |
If you like Oracle tuning, see the book "Oracle
Tuning: The Definitive Reference", with 950 pages of tuning tips and
scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot of Oracle tuning scripts. |
