三,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>
测试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>
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/35489/viewspace-1433528/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/35489/viewspace-1433528/