HOME SOFTWARE CONSULTANCY TRAINING REFERENCE PARTNERS SEARCH
spacer
Latest Tips
e-business
ITIL
Linux
Management
Modeling
Oracle
SQL
UNIX
Windows
z/OS
 
 
 
spacer
 

Redo Logs contain Redo Entries; basically this is data which can be used to replay changes made to the database. Both the Oracle background processes and user sessions are constantly writing to the redo logs via lgwr as transactions occur. Writing occurs via the Redo Buffer, and if insufficient space is available in the buffer, process waiting times will increment.

The metric value crucial to monitoring the effectiveness of the Redo Buffer is "Redo log space requests" which may be found in v$sysstat.

This value should be zero, indicating that processes have sufficient redo buffer space. Once this starts to increase, remedial action must be taken before performance degradation becomes significant. As ever, this involves an init.ora parameter.

The log_buffer parameter in init.ora should be increased. Remember that the increased value should be a multiple of the database block size. Also remember to check on the state of your free memory, otherwise you'll be trading process waiting time for paging and/or swapping.

Next Oracle Tip