Optimizing archiving
Archived logs are copies of online redo logs. They can be used to recover a database to point of failure or to another point in time after a backup has been restored. Archive l...
This tip gives an overview on the functionality in the Batch Optimizer.
Batch Optimizer Process
The Batch Optimizer combines into one simple process the finding of SQL statements in your applicatio...
Identify Contention
The following query determines the miss ratio and the "immediate" miss ratio for redo log latches.
Col MISS_RATIO format 999.99Col IMM_MISS_RATIO format 999.99
SELECT substr(ln.na...