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)>
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License