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>
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>
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/35489/viewspace-1433532/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
