8.183 V$ROWCACHE
V$ROWCACHE
displays statistics for data dictionary activity. Each row contains statistics for one data dictionary cache.
Column | Datatype | Description |
---|---|---|
|
|
Row cache ID number |
|
|
Parent or subordinate row cache type |
|
|
Subordinate set number |
|
|
Name of the initialization parameter that determines the number of entries in the data dictionary cache |
|
|
Total number of entries in the cache |
|
|
Number of cache entries that contain valid data |
|
|
Number of fixed entries in the cache |
|
|
Total number of requests for information on the data object |
|
|
Reserved for internal use |
|
|
Number of data requests resulting in cache misses |
|
|
Number of scan requests |
|
|
Number of times a scan failed to find the data in the cache |
|
|
For a list of subordinate entries, the number of times the list was scanned completely |
|
|
Number of inserts, updates, and deletions |
|
|
Number of times flushed to disk |
|
|
Number of DLM requests |
|
|
Number of DLM conflicts |
|
|
Number of DLM releases |
|
|
The ID of the container to which the data pertains. Possible values include:
|