V$ROWCACHE displays statistics for data dictionary activity. Each row contains statistics for one data dictionary cache.
| Column | Datatype | Description |
|---|---|---|
CACHE# |
NUMBER |
Row cache ID number |
TYPE |
VARCHAR2(11) |
Parent or subordinate row cache type |
SUBORDINATE# |
NUMBER |
Subordinate set number |
PARAMETER |
VARCHAR2(32) |
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 |
FASTGETS |
NUMBER |
Reserved for internal use |
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 |
Number of DLM requests |
DLM_CONFLICTS |
NUMBER |
Number of DLM conflicts |
DLM_RELEASES |
NUMBER |
Number of DLM releases |