| |
 |
|
Oracle Tips by Burleson Consulting
|
The Log Writer background
process (LGWR)
The LGWR background process is the first in a series on redo log
processes that writes the contents of the redo log buffer to the
online redo log files. It writes to the online redo log files in
batches and the entries always contain the most up-to-date status of
the database. In UNIX, the LGWR process will perform the writes from
the RAM log_buffer to the online redo log file even if your database
is not in ARCHIVELOG mode.
 |
For more details and scripts, see my new book "
Oracle
Tuning: The Definitive Reference", over 900 pages
of BC's favorite tuning tips & scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot. |
|
