V$RESULT_CACHE_OBJECTS
バージョン&仕様
PROD(JASON)> select * from v$version;
BANNER
------------------------------------------------------------------------------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
PL/SQL Release 11.1.0.7.0 - Production
CORE 11.1.0.7.0 Production
TNS for Linux: Version 11.1.0.7.0 - Production
NLSRTL Version 11.1.0.7.0 - Production
PROD(JASON)> desc V$RESULT_CACHE_OBJECTS;
名前 NULL? 型
----------------------------------------------------------------------------------- -------- --------------------------------------------------------
ID NUMBER
TYPE VARCHAR2(10)
STATUS VARCHAR2(9)
BUCKET_NO NUMBER
HASH NUMBER
NAME VARCHAR2(128)
NAMESPACE VARCHAR2(5)
CREATION_TIMESTAMP DATE
CREATOR_UID NUMBER
DEPEND_COUNT NUMBER
BLOCK_COUNT NUMBER
SCN NUMBER
COLUMN_COUNT NUMBER
PIN_COUNT NUMBER
SCAN_COUNT NUMBER
ROW_COUNT NUMBER
ROW_SIZE_MAX NUMBER
ROW_SIZE_MIN NUMBER
ROW_SIZE_AVG NUMBER
BUILD_TIME NUMBER
LRU_NUMBER NUMBER
OBJECT_NO NUMBER
INVALIDATIONS NUMBER
SPACE_OVERHEAD NUMBER
SPACE_UNUSED NUMBER
CACHE_ID VARCHAR2(93)
CACHE_KEY VARCHAR2(93)
PROD(JASON)>
使用例
PROD(JASON)> select name, status, row_count,creation_timestamp from v$result_cache_objects;
NAME STATUS ROW_COUNT CREATION
-------------------------------------------------------------------------------- --------------------------- ---------- --------
JASON.T_OBJ Published 0 10-02-18
PROD(JASON)>
page revision: 0, last edited: 17 Feb 2010 15:35