This article explains the different ways to determine Oracle database size. We are going to learn about the following topics:
Populate the size using catalog views
Populate the size of all pluggable...
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...