Oracle 11.2.0.1 Result Cache 測試 - 5

三，Result Cache測試  


測試1：普通測試    
SQL> create table  apps.test_result_cache   as   select  * from  dba_objects where  rownum<=200000 ;  
SQL> exec dbms_stats.gather_table_stats(ownname => 'apps',tabname => 'TEST_RESULT_CACHE' ,estimate_percent => null ,method_opt => 'for all indexed columns' ,cascade => true); 
PL/SQL procedure successfully completed.


SQL> set timing on 
SQL> set autotrace traceonly  
SQL> select 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.79

Execution Plan
----------------------------------------------------------
----------------------------------------------------------------------------
| Id  | Operation         | Name              | Rows  | Bytes | Cost (%CPU)|
----------------------------------------------------------------------------
|   0 | SELECT STATEMENT  |                   |  2000 |   185K|   772   (2)|
|*  1 |  TABLE ACCESS FULL| TEST_RESULT_CACHE |  2000 |   185K|   772   (2)|
----------------------------------------------------------------------------


Predicate Information (identified by operation id):
---------------------------------------------------
   1 - filter(MOD("OBJECT_ID",3)=1)

Note
-----
   - 'PLAN_TABLE' is old version
Statistics
----------------------------------------------------------
          0  recursive calls
          0  db block gets
       7148  consistent gets
          0  physical reads
。.... 
SQL>