Oracle 11.2.0.1 Result Cache 測試 - 7

SQL> select /*+ RESULT_CACHE */ object_id, object_name,object_type,status from apps.test_result_cache  where mod(object_id,3)=1;
66661 rows selected.
Elapsed: 00:00:00.63
Execution Plan
----------------------------------------------------------
| Id  | Operation          | Name                       | Rows  | Bytes | Cost (%CPU)|
--------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT   |                            |  2000 |   185K|   772  (2)|
|   1 |  RESULT CACHE      | gs6bnqjyx46aq8m1yu8htw20cc |       |       |     |
|*  2 |   TABLE ACCESS FULL| TEST_RESULT_CACHE          |  2000 |   185K|   772  (2)|
-------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
   2 - filter(MOD("OBJECT_ID",3)=1)
Result Cache Information (identified by operation id):
------------------------------------------------------

   1 - column-count=4; dependencies=(APPS.TEST_RESULT_CACHE); name="select /*+ R
ESULT_CACHE */ object_id, object_name,object_type,status from apps.test_result_c
ache  where mod(object_id,3)=1"
Note
-----
   - 'PLAN_TABLE' is old version
Statistics
----------------------------------------------------------
          0  recursive calls
          0  db block gets
          0  consistent gets
          0  physical reads
SQL> 


PL/SQL DEV 中查詢 : 
SQL> select * from  v$result_cache_statistics ;