8.170 V$RESULT_CACHE_OBJECTS
V$RESULT_CACHE_OBJECTS
displays all the objects (both cached results and dependencies) and their attributes.
Column | Datatype | Description |
---|---|---|
|
|
Identifier for the cache object (also the ID of the first block) |
|
|
Type of the cache object:
|
|
|
Status of the object:
|
|
|
Internal hash bucket for the object |
|
|
Hash value for the object |
|
|
Name (for example, SQL prefix or PL/SQL function name) |
|
|
Namespace:
|
|
|
Time when the object was created |
|
|
UID that created the object |
|
|
Number of dependencies ( |
|
|
Total number of blocks in the cached object |
|
|
Build SCN ( |
|
|
Number of columns in the cached resultFoot 1 |
|
|
Number of active scans on this resultFoot 1 |
|
|
Total number of scans initiated on the cached resultFoot 1 |
|
|
Total number of rows in the cached resultFoot 1 |
|
|
Size of the largest row (in bytes)Foot 1 |
|
|
Size of the smallest row (in bytes)Foot 1 |
|
|
Average size of a row (in bytes)Foot 1 |
|
|
Amount of time (in hundredths of a second) it took to build the cached resultFoot 1 |
|
|
LRU list position (the larger the value, the more recent the usage)Foot 1 |
|
|
Dictionary object number of the dependency objectFoot 2 |
|
|
Number of times the object has invalidated its dependentsFoot 2 |
|
|
Overhead (in bytes) for the resultFoot 1 |
|
|
Unused space (in bytes) for the resultFoot 1 |
|
|
|
|
|
|
|
|
Checksum for the result object. The checksum is computed over all the blocks in the result cache object minus the object header. |
|
|
Shows the edition's object ID that was in use when the result was calculated |
|
|
Possible values:
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
Footnote 1
These columns are only valid for TYPE
= Result
; otherwise, they are NULL.
Footnote 2
These columns are only valid for TYPE
= Dependency
; otherwise, they are NULL.