DBA Data[Home] [Help]

VIEW: SYS.V_$RESULT_CACHE_OBJECTS

Source

View Text - Preformatted

select "ID","TYPE","STATUS","BUCKET_NO","HASH","NAME","NAMESPACE","CREATION_TIMESTAMP","CREATOR_UID","DEPEND_COUNT","BLOCK_COUNT","SCN","COLUMN_COUNT","PIN_COUNT","SCAN_COUNT","ROW_COUNT","ROW_SIZE_MAX","ROW_SIZE_MIN","ROW_SIZE_AVG","BUILD_TIME","LRU_NUMBER","OBJECT_NO","INVALIDATIONS","SPACE_OVERHEAD","SPACE_UNUSED","CACHE_ID","CACHE_KEY","CHECKSUM","EDITION_ID","DB_LINK","CON_ID" from v$result_cache_objects
View Text - HTML Formatted

SELECT "ID"
, "TYPE"
, "STATUS"
, "BUCKET_NO"
, "HASH"
, "NAME"
, "NAMESPACE"
, "CREATION_TIMESTAMP"
, "CREATOR_UID"
, "DEPEND_COUNT"
, "BLOCK_COUNT"
, "SCN"
, "COLUMN_COUNT"
, "PIN_COUNT"
, "SCAN_COUNT"
, "ROW_COUNT"
, "ROW_SIZE_MAX"
, "ROW_SIZE_MIN"
, "ROW_SIZE_AVG"
, "BUILD_TIME"
, "LRU_NUMBER"
, "OBJECT_NO"
, "INVALIDATIONS"
, "SPACE_OVERHEAD"
, "SPACE_UNUSED"
, "CACHE_ID"
, "CACHE_KEY"
, "CHECKSUM"
, "EDITION_ID"
, "DB_LINK"
, "CON_ID"
FROM V$RESULT_CACHE_OBJECTS