Mega Code Archive
Autotrace an self join
<![CDATA[
SQL>
SQL> create table t as select * from all_objects where rownum < 50;
Table created.
SQL>
SQL> alter session set sort_area_size = 1024000;
Session altered.
SQL>
SQL> set autotrace on
SQL>
SQL> select *
2 from t myTable1, t myTable2
3 where myTable1.object_id = myTable2.object_id
4 /
OWNER OBJECT_NAME SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID
------------------------------ ------------------------------ ------------------------------ ---------- --------------
OBJECT_TYPE CREATED LAST_DDL_ TIMESTAMP STATUS T G S OWNER
------------------- --------- --------- ------------------- ------- - - - ------------------------------
OBJECT_NAME SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE CREATED LAST_DDL_
------------------------------ ------------------------------ ---------- -------------- ------------------- --------- ---------
TIMESTAMP STATUS T G S
------------------- ------- - - -
SYS ICOL$ 20 2
TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
ICOL$ 20 2 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_USER1 44 44
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_USER1 44 44 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS CON$ 28 28
TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
CON$ 28 28 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS UNDO$ 15 15
TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
UNDO$ 15 15 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS C_COBJ# 29 29
CLUSTER 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
C_COBJ# 29 29 CLUSTER 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_OBJ# 3 3
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_OBJ# 3 3 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS PROXY_ROLE_DATA$ 25 25
TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
PROXY_ROLE_DATA$ 25 25 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_IND1 39 39
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_IND1 39 39 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_CDEF2 51 51
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_CDEF2 51 51 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_PROXY_ROLE_DATA$_1 26 26
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_PROXY_ROLE_DATA$_1 26 26 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS FILE$ 17 17
TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
FILE$ 17 17 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS UET$ 13 8
TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
UET$ 13 8 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_FILE#_BLOCK# 9 9
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_FILE#_BLOCK# 9 9 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_FILE1 41 41
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_FILE1 41 41 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_CON1 48 48
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_CON1 48 48 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_OBJ3 38 38
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_OBJ3 38 38 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_TS# 7 7
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_TS# 7 7 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_CDEF4 53 53
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_CDEF4 53 53 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS IND$ 19 2
TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
IND$ 19 2 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS SEG$ 14 8
TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
SEG$ 14 8 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS C_TS# 6 6
CLUSTER 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
C_TS# 6 6 CLUSTER 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_FILE2 42 42
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_FILE2 42 42 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS COL$ 21 2
TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
COL$ 21 2 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_TS1 43 43
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_TS1 43 43 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_UNDO2 35 35
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_UNDO2 35 35 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS CLU$ 5 2
TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
CLU$ 5 2 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS PROXY_DATA$ 23 23
TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
PROXY_DATA$ 23 23 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_PROXY_DATA$ 24 24
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_PROXY_DATA$ 24 24 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_OBJ1 36 36
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_OBJ1 36 36 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_COL2 46 46
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_COL2 46 46 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_OBJ2 37 37
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_OBJ2 37 37 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_CCOL1 54 54
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_CCOL1 54 54 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS TS$ 16 6
TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
TS$ 16 6 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS C_FILE#_BLOCK# 8 8
CLUSTER 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
C_FILE#_BLOCK# 8 8 CLUSTER 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS C_USER# 10 10
CLUSTER 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
C_USER# 10 10 CLUSTER 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_UNDO1 34 34
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_UNDO1 34 34 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS BOOTSTRAP$ 56 56
TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
BOOTSTRAP$ 56 56 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS FET$ 12 6
TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
FET$ 12 6 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_TAB1 33 33
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_TAB1 33 33 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS CCOL$ 32 29
TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
CCOL$ 32 29 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS USER$ 22 10
TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
USER$ 22 10 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_CON2 49 49
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_CON2 49 49 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_COBJ# 30 30
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_COBJ# 30 30 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS OBJ$ 18 18
TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
OBJ$ 18 18 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_COL3 47 47
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_COL3 47 47 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS C_OBJ# 2 2
CLUSTER 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
C_OBJ# 2 2 CLUSTER 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS TAB$ 4 2
TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
TAB$ 4 2 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS CDEF$ 31 29
TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
CDEF$ 31 29 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_CDEF1 50 50
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_CDEF1 50 50 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
49 rows selected.
Execution Plan
----------------------------------------------------------
Plan hash value: 2135975663
---------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
---------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 49 | 12544 | 5 (20)| 00:00:01 |
|* 1 | HASH JOIN | | 49 | 12544 | 5 (20)| 00:00:01 |
| 2 | TABLE ACCESS FULL| T | 49 | 6272 | 2 (0)| 00:00:01 |
| 3 | TABLE ACCESS FULL| T | 49 | 6272 | 2 (0)| 00:00:01 |
---------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
1 - access("MYTABLE1"."OBJECT_ID"="MYTABLE2"."OBJECT_ID")
Note
-----
- dynamic sampling used for this statement
Statistics
----------------------------------------------------------
272 recursive calls
0 db block gets
41 consistent gets
1 physical reads
0 redo size
4375 bytes sent via SQL*Net to client
380 bytes received via SQL*Net from client
2 SQL*Net roundtrips to/from client
2 sorts (memory)
0 sorts (disk)
49 rows processed
SQL> alter session set sort_area_size = 10240000;
Session altered.
SQL>
SQL> select *
2 from t myTable1, t myTable2
3 where myTable1.object_id = myTable2.object_id
4 and rownum < 50
5 /
OWNER OBJECT_NAME SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID
------------------------------ ------------------------------ ------------------------------ ---------- --------------
OBJECT_TYPE CREATED LAST_DDL_ TIMESTAMP STATUS T G S OWNER
------------------- --------- --------- ------------------- ------- - - - ------------------------------
OBJECT_NAME SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE CREATED LAST_DDL_
------------------------------ ------------------------------ ---------- -------------- ------------------- --------- ---------
TIMESTAMP STATUS T G S
------------------- ------- - - -
SYS ICOL$ 20 2
TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
ICOL$ 20 2 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_USER1 44 44
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_USER1 44 44 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS CON$ 28 28
TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
CON$ 28 28 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS UNDO$ 15 15
TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
UNDO$ 15 15 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS C_COBJ# 29 29
CLUSTER 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
C_COBJ# 29 29 CLUSTER 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_OBJ# 3 3
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_OBJ# 3 3 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS PROXY_ROLE_DATA$ 25 25
TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
PROXY_ROLE_DATA$ 25 25 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_IND1 39 39
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_IND1 39 39 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_CDEF2 51 51
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_CDEF2 51 51 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_PROXY_ROLE_DATA$_1 26 26
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_PROXY_ROLE_DATA$_1 26 26 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS FILE$ 17 17
TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
FILE$ 17 17 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS UET$ 13 8
TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
UET$ 13 8 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_FILE#_BLOCK# 9 9
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_FILE#_BLOCK# 9 9 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_FILE1 41 41
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_FILE1 41 41 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_CON1 48 48
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_CON1 48 48 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_OBJ3 38 38
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_OBJ3 38 38 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_TS# 7 7
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_TS# 7 7 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_CDEF4 53 53
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_CDEF4 53 53 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS IND$ 19 2
TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
IND$ 19 2 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS SEG$ 14 8
TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
SEG$ 14 8 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS C_TS# 6 6
CLUSTER 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
C_TS# 6 6 CLUSTER 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_FILE2 42 42
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_FILE2 42 42 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS COL$ 21 2
TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
COL$ 21 2 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_TS1 43 43
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_TS1 43 43 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_UNDO2 35 35
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_UNDO2 35 35 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS CLU$ 5 2
TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
CLU$ 5 2 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS PROXY_DATA$ 23 23
TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
PROXY_DATA$ 23 23 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_PROXY_DATA$ 24 24
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_PROXY_DATA$ 24 24 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_OBJ1 36 36
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_OBJ1 36 36 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_COL2 46 46
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_COL2 46 46 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_OBJ2 37 37
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_OBJ2 37 37 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_CCOL1 54 54
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_CCOL1 54 54 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS TS$ 16 6
TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
TS$ 16 6 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS C_FILE#_BLOCK# 8 8
CLUSTER 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
C_FILE#_BLOCK# 8 8 CLUSTER 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS C_USER# 10 10
CLUSTER 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
C_USER# 10 10 CLUSTER 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_UNDO1 34 34
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_UNDO1 34 34 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS BOOTSTRAP$ 56 56
TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
BOOTSTRAP$ 56 56 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS FET$ 12 6
TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
FET$ 12 6 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_TAB1 33 33
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_TAB1 33 33 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS CCOL$ 32 29
TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
CCOL$ 32 29 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS USER$ 22 10
TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
USER$ 22 10 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_CON2 49 49
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_CON2 49 49 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_COBJ# 30 30
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_COBJ# 30 30 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS OBJ$ 18 18
TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
OBJ$ 18 18 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_COL3 47 47
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_COL3 47 47 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS C_OBJ# 2 2
CLUSTER 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
C_OBJ# 2 2 CLUSTER 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS TAB$ 4 2
TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
TAB$ 4 2 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS CDEF$ 31 29
TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
CDEF$ 31 29 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
SYS I_CDEF1 50 50
INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N SYS
I_CDEF1 50 50 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:10:08 VALID N N N
49 rows selected.
Execution Plan
----------------------------------------------------------
Plan hash value: 1415706426
----------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
----------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 49 | 12544 | 5 (20)| 00:00:01 |
|* 1 | COUNT STOPKEY | | | | | |
|* 2 | HASH JOIN | | 49 | 12544 | 5 (20)| 00:00:01 |
| 3 | TABLE ACCESS FULL| T | 49 | 6272 | 2 (0)| 00:00:01 |
| 4 | TABLE ACCESS FULL| T | 49 | 6272 | 2 (0)| 00:00:01 |
----------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
1 - filter(ROWNUM<50)
2 - access("MYTABLE1"."OBJECT_ID"="MYTABLE2"."OBJECT_ID")
Note
-----
- dynamic sampling used for this statement
Statistics
----------------------------------------------------------
15 recursive calls
0 db block gets
23 consistent gets
0 physical reads
0 redo size
4375 bytes sent via SQL*Net to client
380 bytes received via SQL*Net from client
2 SQL*Net roundtrips to/from client
4 sorts (memory)
0 sorts (disk)
49 rows processed
SQL> set autotrace off
SQL>
SQL> drop table t;
Table dropped.
SQL>
]]>