- /oracle/migration/admin/MIG/udump/mig_ora_15557.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, Data Mining and Real Application Testing options
ORACLE_HOME = /oracle/migration/product/10.2.0
System name: Linux
Node name: oralab1db
Release: 2.6.9-67.ELsmp
Version: #1 SMP Wed Nov 7 13:58:04 EST 2007
Machine: i686
Instance name: MIG
Redo thread mounted by this instance: 1
Oracle process number: 15
Unix process pid: 15557, image: oracle@oralab1db (TNS V1-V3)
+++ 2009-03-27 22:17:20.657
+++ ACTION NAME: () 2009-03-27 22:17:20.657
+++ MODULE NAME: (SQL*Plus) 2009-03-27 22:17:20.657
+++ SERVICE NAME: (SYS$USERS) 2009-03-27 22:17:20.657
+++ SESSION ID: (1063.818) 2009-03-27 22:17:20.657
=====================
PARSING IN CURSOR #2 len=321 dep=0 uid=73 oct=3 lid=73 tim=1209140469391681 hv=307979221 ad='5fa40f08'
select rnum, b.object_name, object_id, owner
from testtrc.testtrc a, testtrc.test_master b
where a.object_name = b.object_name
and b.owner = 'SYS'
union
select sum(rnum), min(b.object_name), avg(object_id), max(owner)
from testtrc.testtrc a, testtrc.test_master b
where a.object_name = b.object_name
order by 4,1,3,2 desc
END OF STMT
PARSE #2:c=0,e=11589,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=1209140469391672
EXEC #2:c=0,e=9623,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=1209140469401669
FETCH #2:c=6998,e=33446,p=0,cr=47,cu=0,mis=0,r=1,dep=0,og=1,tim=1209140469435174
FETCH #2:c=0,e=21,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=1,tim=1209140469435641
FETCH #2:c=0,e=41,p=0,cr=0,cu=0,mis=0,r=14,dep=0,og=1,tim=1209140469437224
STAT #2 id=1 cnt=30 pid=0 pos=1 obj=0 op='SORT UNIQUE (cr=47 pr=0 pw=0 time=33529 us)'
STAT #2 id=2 cnt=30 pid=1 pos=1 obj=0 op='UNION-ALL (cr=47 pr=0 pw=0 time=2237 us)'
STAT #2 id=3 cnt=29 pid=2 pos=1 obj=0 op='HASH JOIN (cr=23 pr=0 pw=0 time=1910 us)'
STAT #2 id=4 cnt=12 pid=3 pos=1 obj=35436 op='TABLE ACCESS BY INDEX ROWID TEST_MASTER (cr=2 pr=0 pw=0 time=218 us)'
STAT #2 id=5 cnt=12 pid=4 pos=1 obj=35438 op='INDEX RANGE SCAN IDX_MASTER (cr=1 pr=0 pw=0 time=45 us)'
STAT #2 id=6 cnt=4785 pid=3 pos=2 obj=35435 op='TABLE ACCESS FULL TESTTRC (cr=21 pr=0 pw=0 time=9632 us)'
STAT #2 id=7 cnt=1 pid=2 pos=2 obj=0 op='SORT AGGREGATE (cr=24 pr=0 pw=0 time=3172 us)'
STAT #2 id=8 cnt=80 pid=7 pos=1 obj=0 op='HASH JOIN (cr=24 pr=0 pw=0 time=1084 us)'
STAT #2 id=9 cnt=46 pid=8 pos=1 obj=35436 op='TABLE ACCESS FULL TEST_MASTER (cr=3 pr=0 pw=0 time=164 us)'
STAT #2 id=10 cnt=4785 pid=8 pos=2 obj=35435 op='TABLE ACCESS FULL TESTTRC (cr=21 pr=0 pw=0 time=9590 us)'
XCTEND rlbk=0, rd_only=1