这是我的执行计划
390 rows selected.
Elapsed: 00:00:00.08
Execution Plan
----------------------------------------------------------
----------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)|
----------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1974 | 314K| 289 (2)|
|* 1 | HASH JOIN RIGHT OUTER | | 1974 | 314K| 289 (2)|
| 2 | TABLE ACCESS FULL | SEG$ | 5005 | 55055 | 19 (0)|
|* 3 | HASH JOIN | | 1930 | 286K| 269 (2)|
| 4 | TABLE ACCESS FULL | TS$ | 7 | 21 | 5 (0)|
| 5 | NESTED LOOPS OUTER | | 1930 | 280K| 264 (2)|
| 6 | NESTED LOOPS OUTER | | 1930 | 275K| 262 (2)|
|* 7 | HASH JOIN OUTER | | 1930 | 265K| 262 (2)|
| 8 | NESTED LOOPS | | 1930 | 250K| 184 (2)|
| 9 | MERGE JOIN CARTESIAN| | 2760 | 277K| 79 (3)|
|* 10 | HASH JOIN | | 1 | 68 | 1 (100)|
|* 11 | FIXED TABLE FULL | X$KSPPI | 1 | 55 | 0 (0)|
| 12 | FIXED TABLE FULL | X$KSPPCV | 100 | 1300 | 0 (0)|
| 13 | BUFFER SORT | | 2760 | 96600 | 79 (3)|
|* 14 | TABLE ACCESS FULL | OBJ$ | 2760 | 96600 | 78 (2)|
|* 15 | TABLE ACCESS CLUSTER| TAB$ | 1 | 30 | 1 (0)|
|* 16 | INDEX UNIQUE SCAN | I_OBJ# | 1 | | 0 (0)|
| 17 | TABLE ACCESS FULL | OBJ$ | 52448 | 409K| 77 (0)|
|* 18 | INDEX UNIQUE SCAN | I_OBJ1 | 1 | 5 | 0 (0)|
| 19 | TABLE ACCESS CLUSTER | USER$ | 1 | 3 | 1 (0)|
|* 20 | INDEX UNIQUE SCAN | I_USER# | 1 | | 0 (0)|
----------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
1 - access("T"."FILE#"="S"."FILE#"(+) AND
"T"."BLOCK#"="S"."BLOCK#"(+) AND "T"."TS#"="S"."TS#"(+))
3 - access("T"."TS#"="TS"."TS#")
7 - access("T"."DATAOBJ#"="CX"."OBJ#"(+))
10 - access("KSPPI"."INDX"="KSPPCV"."INDX")
11 - filter("KSPPI"."KSPPINM"='_dml_monitoring_enabled')
14 - filter("O"."OWNER#"=USERENV('SCHEMAID') AND
BITAND("O"."FLAGS",128)=0)
15 - filter(BITAND("T"."PROPERTY",1)=0)
16 - access("O"."OBJ#"="T"."OBJ#")
18 - access("T"."BOBJ#"="CO"."OBJ#"(+))
20 - access("CX"."OWNER#"="CU"."USER#"(+))
Note
-----
- 'PLAN_TABLE' is old version
Statistics
----------------------------------------------------------
0 recursive calls
0 db block gets
2419 consistent gets
0 physical reads
0 redo size
9929 bytes sent via SQL*Net to client
744 bytes received via SQL*Net from client
27 SQL*Net roundtrips to/from client
1 sorts (memory)
0 sorts (disk)
390 rows processed