Oracle 11.2.0.1 Result Cache 測試 - 6

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.86
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)

-----
   - 'PLAN_TABLE' is old version

Statistics
----------------------------------------------------------
          1  recursive calls
          0  db block gets
       7148  consistent gets
          0  physical reads
SQL>