Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select /*+ gather_plan_statistics */ * from dba_segments where owner = 'MYUSERL' and segment_name = 'T'
- Plan hash value: 2527334192
- ----------------------------------------------------------------------------------------------------------------------------------------------------
- | Id | Operation | Name | Starts | E-Rows | A-Rows | A-Time | Buffers | Reads | OMem | 1Mem | O/1/M |
- ----------------------------------------------------------------------------------------------------------------------------------------------------
- | 1 | VIEW | SYS_DBA_SEGS | 2 | 1346 | 2 |00:00:22.12 | 237K| 149K| | | |
- | 2 | UNION-ALL | | 2 | | 2 |00:00:22.12 | 237K| 149K| | | |
- |* 3 | FILTER | | 2 | | 2 |00:00:22.12 | 228K| 148K| | | |
- |* 4 | HASH JOIN RIGHT OUTER | | 2 | 316 | 18 |00:00:22.12 | 228K| 148K| 925K| 925K| 2/0/0|
- | 5 | TABLE ACCESS FULL | USER$ | 2 | 1017 | 2230 |00:00:00.01 | 60 | 0 | | | |
- |* 6 | HASH JOIN | | 2 | 316 | 18 |00:00:22.11 | 228K| 148K| 972K| 972K| 2/0/0|
- | 7 | TABLE ACCESS FULL | FILE$ | 2 | 215 | 510 |00:00:00.01 | 6 | 1 | | | |
- |* 8 | HASH JOIN | | 2 | 316 | 18 |00:00:22.09 | 228K| 148K| 826K| 826K| 2/0/0|
- | 9 | TABLE ACCESS FULL | TS$ | 2 | 52 | 132 |00:00:00.01 | 144 | 0 | | | |
- | 10 | NESTED LOOPS | | 2 | 316 | 18 |00:00:22.05 | 228K| 148K| | | |
- |* 11 | HASH JOIN | | 2 | 1181 | 18 |00:01:16.36 | 228K| 148K| 841K| 841K| 2/0/0|
- | 12 | TABLE ACCESS BY INDEX ROWID| OBJ$ | 2 | 1303 | 34 |00:00:01.66 | 803 | 414 | | | |
- |* 13 | INDEX SKIP SCAN | I_OBJ2 | 2 | 1303 | 34 |00:00:01.63 | 769 | 411 | | | |
- | 14 | VIEW | SYS_OBJECTS | 2 | 664K| 1547K|00:02:56.44 | 227K| 148K| | | |
- | 15 | UNION-ALL | | 2 | | 1547K|00:02:50.25 | 227K| 148K| | | |
- |* 16 | TABLE ACCESS FULL | TAB$ | 2 | 121K| 202K|00:00:51.64 | 42399 | 38268 | | | |
- | 17 | TABLE ACCESS FULL | TABPART$ | 2 | 407K| 995K|00:00:43.36 | 10966 | 9600 | | | |
- | 18 | TABLE ACCESS FULL | CLU$ | 2 | 10 | 20 |00:00:00.05 | 49513 | 38869 | | | |
- |* 19 | TABLE ACCESS FULL | IND$ | 2 | 9522 | 20938 |00:01:45.48 | 56275 | 30987 | | | |
- | 20 | TABLE ACCESS FULL | INDPART$ | 2 | 110K| 304K|00:00:00.66 | 3706 | 3617 | | | |
- |* 21 | TABLE ACCESS FULL | LOB$ | 2 | 725 | 1470 |00:00:31.22 | 64635 | 26767 | | | |
- | 22 | TABLE ACCESS FULL | TABSUBPART$ | 2 | 8256 | 7670 |00:00:00.10 | 244 | 238 | | | |
- | 23 | TABLE ACCESS FULL | INDSUBPART$ | 2 | 6644 | 13888 |00:00:00.16 | 144 | 138 | | | |
- | 24 | TABLE ACCESS FULL | LOBFRAG$ | 2 | 10 | 134 |00:00:00.01 | 6 | 2 | | | |
- |* 25 | TABLE ACCESS CLUSTER | SEG$ | 18 | 1 | 18 |00:00:00.13 | 60 | 8 | | | |
- |* 26 | INDEX UNIQUE SCAN | I_FILE#_BLOCK# | 18 | 1 | 18 |00:00:00.01 | 40 | 0 | | | |
- | 27 | NESTED LOOPS | | 2 | 1 | 0 |00:00:00.03 | 2 | 2 | | | |
- | 28 | NESTED LOOPS | | 2 | 1 | 0 |00:00:00.03 | 2 | 2 | | | |
- |* 29 | FILTER | | 2 | | 0 |00:00:00.03 | 2 | 2 | | | |
- | 30 | NESTED LOOPS OUTER | | 2 | 1 | 0 |00:00:00.03 | 2 | 2 | | | |
- | 31 | NESTED LOOPS | | 2 | 1 | 0 |00:00:00.03 | 2 | 2 | | | |
- |* 32 | TABLE ACCESS BY INDEX ROWID | UNDO$ | 2 | 1 | 0 |00:00:00.03 | 2 | 2 | | | |
- |* 33 | INDEX RANGE SCAN | I_UNDO2 | 2 | 1 | 0 |00:00:00.03 | 2 | 2 | | | |
- |* 34 | TABLE ACCESS CLUSTER | SEG$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
- |* 35 | INDEX UNIQUE SCAN | I_FILE#_BLOCK# | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
- | 36 | TABLE ACCESS CLUSTER | USER$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
- |* 37 | INDEX UNIQUE SCAN | I_USER# | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
- | 38 | TABLE ACCESS BY INDEX ROWID | FILE$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
- |* 39 | INDEX UNIQUE SCAN | I_FILE2 | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
- | 40 | TABLE ACCESS CLUSTER | TS$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
- |* 41 | INDEX UNIQUE SCAN | I_TS# | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
- |* 42 | FILTER | | 2 | | 0 |00:00:05.38 | 8232 | 205 | | | |
- |* 43 | HASH JOIN RIGHT OUTER | | 2 | 1029 | 0 |00:00:05.37 | 8232 | 205 | 925K| 925K| 2/0/0|
- | 44 | TABLE ACCESS FULL | USER$ | 2 | 1017 | 2230 |00:00:00.01 | 60 | 0 | | | |
- |* 45 | HASH JOIN | | 2 | 1029 | 0 |00:00:05.37 | 8172 | 205 | 826K| 826K| 2/0/0|
- | 46 | TABLE ACCESS FULL | TS$ | 2 | 52 | 132 |00:00:00.01 | 144 | 0 | | | |
- | 47 | NESTED LOOPS | | 2 | 1029 | 0 |00:00:05.36 | 8028 | 205 | | | |
- | 48 | TABLE ACCESS FULL | FILE$ | 2 | 215 | 510 |00:00:00.01 | 6 | 0 | | | |
- |* 49 | TABLE ACCESS CLUSTER | SEG$ | 510 | 5 | 0 |00:00:05.35 | 8022 | 205 | | | |
- |* 50 | INDEX RANGE SCAN | I_FILE#_BLOCK# | 510 | 1 | 0 |00:00:05.35 | 8022 | 205 | | | |
- ----------------------------------------------------------------------------------------------------------------------------------------------------
- Predicate Information (identified by operation id):
- ---------------------------------------------------
- 3 - filter(NVL("U"."NAME",'SYS')='MYUSERL')
- 4 - access("O"."OWNER#"="U"."USER#")
- 6 - access("S"."TS#"="F"."TS#" AND "S"."FILE#"="F"."RELFILE#")
- 8 - access("S"."TS#"="TS"."TS#")
- 11 - access("O"."OBJ#"="SO"."OBJECT_ID" AND "O"."TYPE#"="SO"."OBJECT_TYPE_ID")
- 13 - access("O"."NAME"='T')
- filter("O"."NAME"='T')
- 16 - filter(BITAND("T"."PROPERTY",1024)=0)
- 19 - filter(("I"."TYPE#"=1 OR "I"."TYPE#"=2 OR "I"."TYPE#"=3 OR "I"."TYPE#"=4 OR "I"."TYPE#"=6 OR "I"."TYPE#"=7 OR "I"."TYPE#"=8 OR
- "I"."TYPE#"=9))
- 21 - filter((BITAND("L"."PROPERTY",64)=0 OR BITAND("L"."PROPERTY",128)=128))
- 25 - filter("S"."TYPE#"="SO"."SEGMENT_TYPE_ID")
- 26 - access("S"."TS#"="SO"."TS_NUMBER" AND "S"."FILE#"="SO"."HEADER_FILE" AND "S"."BLOCK#"="SO"."HEADER_BLOCK")
- 29 - filter(NVL("U"."NAME",'SYS')='MYUSERL')
- 32 - filter("UN"."STATUS$"<>1)
- 33 - access("UN"."NAME"='T')
- 34 - filter(("S"."TYPE#"=1 OR "S"."TYPE#"=10))
- 35 - access("S"."TS#"="UN"."TS#" AND "S"."FILE#"="UN"."FILE#" AND "S"."BLOCK#"="UN"."BLOCK#")
- 37 - access("S"."USER#"="U"."USER#")
- 39 - access("UN"."TS#"="F"."TS#" AND "UN"."FILE#"="F"."RELFILE#")
- 41 - access("S"."TS#"="TS"."TS#")
- 42 - filter(NVL("U"."NAME",'SYS')='MYUSERL')
- 43 - access("S"."USER#"="U"."USER#")
- 45 - access("S"."TS#"="TS"."TS#")
- 49 - filter(("S"."TYPE#"<>5 AND "S"."TYPE#"<>6 AND "S"."TYPE#"<>10 AND "S"."TYPE#"<>8 AND "S"."TYPE#"<>1))
- 50 - access("S"."TS#"="F"."TS#" AND "S"."FILE#"="F"."RELFILE#")
- filter(TO_CHAR("F"."FILE#")||'.'||TO_CHAR("S"."BLOCK#")='T')
- 92 rows selected.
- Elapsed: 00:00:01.45
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement