|
CACHE# |
NUMBER |
Row cache ID number |
|
TYPE |
VARCHAR2 |
Parent or subordinate row cache type |
|
SUBORDINATE# |
NUMBER |
Subordinate set number |
|
PARAMETER |
VARCHAR2 |
Name of the initialization parameter that determines the number of entries in the data dictionary cache |
|
COUNT |
NUMBER |
Total number of entries in the cache |
|
USAGE |
NUMBER |
Number of cache entries that contain valid data |
|
FIXED |
NUMBER |
Number of fixed entries in the cache |
|
GETS |
NUMBER |
Total number of requests for information on the data object |
|
GETMISSES |
NUMBER |
Number of data requests resulting in cache misses |
|
SCANS |
NUMBER |
Number of scan requests |
|
SCANMISSES |
NUMBER |
Number of times a scan failed to find the data in the cache |
|
SCANCOMPLETES |
NUMBER |
For a list of subordinate entries, the number of times the list was scanned completely |
|
MODIFICATIONS |
NUMBER |
Number of inserts, updates, and deletions |
|
FLUSHES |
NUMBER |
Number of times flushed to disk |
|
DLM_REQUESTS |
NUMBER |
The number of DLM requests |
|
DLM_CONFLICTS |
NUMBER |
The number of DLM conflicts |
|
DLM_RELEASES |
NUMBER |
The number of DLM releases |