Re: Slow performance/response
- From: Leroy Kemnitz <lkemnitz@xxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 29 Jun 2004 16:21:22 -0500
I appreciate your patience with me. Can you see the output of the 10046??
Daniel Fink wrote:
> Leroy,
>
> If you could include row source cardinality information it will help to
> identify areas for improvement using the throw-away
> methodology. From my perspective, it is also hard to read the output and
> understand the order of execution. Using the indentation
> method found in oracle doc (or including all the STAT lines as they are
> output) would be helpful.
>
> Don't give up hope, we're happy to help, we just need to have the information
> to assist.
>
> Regards,
> Daniel Fink
>
> Leroy Kemnitz wrote:
>
>>Here is the plan:
>>
>>SELECT STATEMENT Cost = 3414
>>SORT ORDER BY
>>SORT GROUP BY
>>VIEW
>>WINDOW BUFFER
>>SORT GROUP BY
>>FILTER
>>TABLE ACCESS BY INDEX ROWID STUDENT_ANALYTICAL_BASE
>>NESTED LOOPS
>>VIEW
>>SORT GROUP BY
>>FILTER
>>TABLE ACCESS BY INDEX ROWID STUDENT_ANALYTICAL_BASE
>>NESTED LOOPS
>>TABLE ACCESS BY INDEX ROWID STUDENT_ANALYTICAL_BASE
>>INDEX RANGE SCAN PK_STUDENT_ANALYTICAL
>>INDEX RANGE SCAN PK_STUDENT_ANALYTICAL
>>FILTER
>>TABLE ACCESS FULL DUAL
>>FILTER
>>TABLE ACCESS FULL DUAL
>>FILTER
>>TABLE ACCESS FULL DUAL
>>FILTER
>>TABLE ACCESS FULL DUAL
>>FILTER
>>TABLE ACCESS FULL DUAL
>>FILTER
>>TABLE ACCESS FULL DUAL
>>FILTER
>>TABLE ACCESS FULL DUAL
>>FILTER
>>TABLE ACCESS FULL DUAL
>>INDEX RANGE SCAN PK_STUDENT_ANALYTICAL
>>FILTER
>>TABLE ACCESS FULL DUAL
>
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
--
LeRoy Kemnitz
UW System Administration
Database Administrator
780 Regent Street, #246
Madison, WI 53714
Phone: (608) 265 -5775
Fax: (608) 265 - 2090
-- Attached file included as plaintext by Ecartis --
-- File: cdr3_ora_884936_BIGQUERY.txt
*** 2004-06-29 16:14:21.572
*** SESSION ID:(14.4399) 2004-06-29 16:14:21.572
APPNAME mod='im80.exe' mh=0 act='' ah=0
=====================
PARSING IN CURSOR #1 len=69 dep=0 uid=151 oct=42 lid=151 tim=1063030919504527
hv=2004533713 ad='34cb2ba0'
alter session set events '10046 trace name context forever, level 12'
END OF STMT
EXEC #1:c=0,e=107,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=1063030919504398
WAIT #1: nam='SQL*Net message to client' ela= 2 p1=1413697536 p2=1 p3=0
*** 2004-06-29 16:15:04.619
WAIT #1: nam='SQL*Net message from client' ela= 42037719 p1=1413697536 p2=1 p3=0
=====================
PARSING IN CURSOR #1 len=39 dep=0 uid=151 oct=42 lid=151 tim=1063030961543119
hv=485942061 ad='34cbce58'
alter session set timed_statistics=true
END OF STMT
PARSE #1:c=0,e=504,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=1063030961543115
BINDS #1:
EXEC #1:c=0,e=756,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030961543938
WAIT #1: nam='SQL*Net message to client' ela= 3 p1=1413697536 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 2003 p1=1413697536 p2=1 p3=0
=====================
PARSING IN CURSOR #1 len=48 dep=0 uid=151 oct=42 lid=151 tim=1063030961546362
hv=2085588155 ad='34eb7118'
alter session set max_dump_file_size = unlimited
END OF STMT
PARSE #1:c=0,e=245,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=1063030961546359
BINDS #1:
EXEC #1:c=10000,e=774,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030961547185
WAIT #1: nam='SQL*Net message to client' ela= 1 p1=1413697536 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 474 p1=1413697536 p2=1 p3=0
=====================
PARSING IN CURSOR #1 len=51 dep=0 uid=151 oct=42 lid=151 tim=1063030961547968
hv=1863120917 ad='34cb3cd0'
alter session set tracefile_identifier = 'BIGQUERY'
END OF STMT
PARSE #1:c=0,e=183,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=1063030961547965
BINDS #1:
*** TRACE DUMP CONTINUES IN FILE
/u/app/oracle/admin/cdr3/udump/cdr3_ora_884936_BIGQUERY.trc ***
/u/app/oracle/admin/cdr3/udump/cdr3_ora_884936_BIGQUERY.trc
*** TRACE DUMP CONTINUED FROM FILE
/u/app/oracle/admin/cdr3/udump/cdr3_ora_884936_BIGQUERY.trc ***
EXEC #1:c=0,e=896,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030961548912
WAIT #1: nam='SQL*Net message to client' ela= 1 p1=1413697536 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 1235 p1=1413697536 p2=1 p3=0
=====================
PARSING IN CURSOR #1 len=69 dep=0 uid=151 oct=42 lid=151 tim=1063030961550460
hv=2004533713 ad='34cb2ba0'
alter session set events '10046 trace name context forever, level 12'
END OF STMT
PARSE #1:c=0,e=185,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=1063030961550457
BINDS #1:
EXEC #1:c=0,e=110,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030961550618
WAIT #1: nam='SQL*Net message to client' ela= 1 p1=1413697536 p2=1 p3=0
*** 2004-06-29 16:15:18.936
WAIT #1: nam='SQL*Net message from client' ela= 13973186 p1=1413697536 p2=1 p3=0
=====================
PARSING IN CURSOR #1 len=39 dep=0 uid=151 oct=42 lid=151 tim=1063030975524276
hv=485942061 ad='34cbce58'
alter session set timed_statistics=true
END OF STMT
PARSE #1:c=0,e=108,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030975524272
BINDS #1:
EXEC #1:c=0,e=768,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030975525104
WAIT #1: nam='SQL*Net message to client' ela= 4 p1=1413697536 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 567 p1=1413697536 p2=1 p3=0
=====================
PARSING IN CURSOR #1 len=48 dep=0 uid=151 oct=42 lid=151 tim=1063030975525876
hv=2085588155 ad='34eb7118'
alter session set max_dump_file_size = unlimited
END OF STMT
PARSE #1:c=0,e=39,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030975525873
BINDS #1:
EXEC #1:c=0,e=758,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030975526740
WAIT #1: nam='SQL*Net message to client' ela= 1 p1=1413697536 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 1826 p1=1413697536 p2=1 p3=0
=====================
PARSING IN CURSOR #1 len=51 dep=0 uid=151 oct=42 lid=151 tim=1063030975528714
hv=1863120917 ad='34cb3cd0'
alter session set tracefile_identifier = 'BIGQUERY'
END OF STMT
PARSE #1:c=0,e=38,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030975528712
BINDS #1:
*** TRACE DUMP CONTINUES IN FILE
/u/app/oracle/admin/cdr3/udump/cdr3_ora_884936_BIGQUERY.trc ***
/u/app/oracle/admin/cdr3/udump/cdr3_ora_884936_BIGQUERY.trc
*** TRACE DUMP CONTINUED FROM FILE
/u/app/oracle/admin/cdr3/udump/cdr3_ora_884936_BIGQUERY.trc ***
EXEC #1:c=0,e=897,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030975529657
WAIT #1: nam='SQL*Net message to client' ela= 1 p1=1413697536 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 532 p1=1413697536 p2=1 p3=0
=====================
PARSING IN CURSOR #1 len=69 dep=0 uid=151 oct=42 lid=151 tim=1063030975530340
hv=2004533713 ad='34cb2ba0'
alter session set events '10046 trace name context forever, level 12'
END OF STMT
PARSE #1:c=0,e=35,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030975530338
BINDS #1:
EXEC #1:c=0,e=110,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030975530496
WAIT #1: nam='SQL*Net message to client' ela= 1 p1=1413697536 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 2302695 p1=1413697536 p2=1 p3=0
=====================
PARSING IN CURSOR #2 len=18 dep=0 uid=151 oct=3 lid=151 tim=1063030977834358
hv=1333943659 ad='34cad458'
select * from dual
END OF STMT
PARSE #2:c=0,e=965,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=1063030977834351
WAIT #2: nam='SQL*Net message to client' ela= 3 p1=1413697536 p2=1 p3=0
WAIT #2: nam='SQL*Net message from client' ela= 3951 p1=1413697536 p2=1 p3=0
=====================
PARSING IN CURSOR #2 len=18 dep=0 uid=151 oct=3 lid=151 tim=1063030977838640
hv=1333943659 ad='34cad458'
select * from dual
END OF STMT
PARSE #2:c=0,e=84,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977838637
WAIT #2: nam='SQL*Net message to client' ela= 1 p1=1413697536 p2=1 p3=0
WAIT #2: nam='SQL*Net message from client' ela= 683 p1=1413697536 p2=1 p3=0
=====================
PARSING IN CURSOR #1 len=18 dep=0 uid=151 oct=3 lid=151 tim=1063030977839540
hv=1333943659 ad='34cad458'
select * from dual
END OF STMT
PARSE #1:c=0,e=31,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977839537
WAIT #1: nam='SQL*Net message to client' ela= 1 p1=1413697536 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 1543 p1=1413697536 p2=1 p3=0
=====================
PARSING IN CURSOR #2 len=37 dep=1 uid=0 oct=3 lid=0 tim=1063030977841964
hv=3468666020 ad='31d96568'
select text from view$ where rowid=:1
END OF STMT
PARSE #2:c=0,e=357,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=1063030977841960
BINDS #2:
bind 0: dty=11 mxl=16(16) mal=00 scl=00 pre=00 oacflg=18 oacfl2=1 size=16
offset=0
bfp=1102c5310 bln=16 avl=16 flg=05
value=000003B7.002C.0001
EXEC #2:c=0,e=350,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977842427
FETCH #2:c=0,e=51,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=1063030977842506
=====================
PARSING IN CURSOR #3 len=116 dep=2 uid=0 oct=3 lid=0 tim=1063030977843133
hv=431456802 ad='31f5d468'
select
o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.dataobj#,o.flags
from obj$ o where o.obj#=:1
END OF STMT
PARSE #3:c=0,e=504,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=0,tim=1063030977843130
BINDS #3:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24
offset=0
bfp=1102c4368 bln=22 avl=02 flg=05
value=59
EXEC #3:c=0,e=341,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=1063030977843596
FETCH #3:c=0,e=60,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=4,tim=1063030977843682
STAT #2 id=1 cnt=1 pid=0 pos=1 obj=59 op='TABLE ACCESS BY USER ROWID VIEW$
(cr=1 r=0 w=0 time=27 us)'
=====================
PARSING IN CURSOR #1 len=136 dep=0 uid=151 oct=3 lid=151 tim=1063030977846699
hv=3920541172 ad='34ca93f8'
SELECT OWNER, TABLE_NAME, TABLE_TYPE FROM SYS.ALL_CATALOG WHERE TABLE_TYPE IN
('TABLE','VIEW')AND OWNER = 'UWSA' AND TABLE_NAME = 'DUAL'
END OF STMT
PARSE #1:c=10000,e=5487,p=0,cr=5,cu=0,mis=1,r=0,dep=0,og=4,tim=1063030977846695
BINDS #1:
EXEC #1:c=0,e=59,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977846869
WAIT #1: nam='SQL*Net message to client' ela= 3 p1=1413697536 p2=1 p3=0
FETCH #1:c=0,e=101,p=0,cr=5,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977847026
WAIT #1: nam='SQL*Net message from client' ela= 1495 p1=1413697536 p2=1 p3=0
STAT #1 id=1 cnt=0 pid=0 pos=1 obj=0 op='FILTER (cr=5 r=0 w=0 time=97 us)'
STAT #1 id=2 cnt=0 pid=1 pos=1 obj=0 op='NESTED LOOPS (cr=5 r=0 w=0 time=96
us)'
STAT #1 id=3 cnt=1 pid=2 pos=1 obj=22 op='TABLE ACCESS BY INDEX ROWID USER$
(cr=2 r=0 w=0 time=32 us)'
STAT #1 id=4 cnt=1 pid=3 pos=1 obj=41 op='INDEX UNIQUE SCAN I_USER1 (cr=1 r=0
w=0 time=18 us)'
STAT #1 id=5 cnt=0 pid=2 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID OBJ$
(cr=3 r=0 w=0 time=54 us)'
STAT #1 id=6 cnt=1 pid=5 pos=1 obj=34 op='INDEX RANGE SCAN I_OBJ2 (cr=2 r=0 w=0
time=34 us)'
STAT #1 id=7 cnt=0 pid=1 pos=2 obj=4 op='TABLE ACCESS CLUSTER TAB$ (cr=0 r=0
w=0 time=0 us)'
STAT #1 id=8 cnt=0 pid=7 pos=1 obj=3 op='INDEX UNIQUE SCAN I_OBJ# (cr=0 r=0 w=0
time=0 us)'
STAT #1 id=9 cnt=0 pid=1 pos=2 obj=0 op='NESTED LOOPS (cr=0 r=0 w=0 time=0 us)'
STAT #1 id=10 cnt=0 pid=9 pos=1 obj=309 op='FIXED TABLE FULL X$KZSRO (cr=0 r=0
w=0 time=0 us)'
STAT #1 id=11 cnt=0 pid=9 pos=2 obj=101 op='INDEX RANGE SCAN I_OBJAUTH2 (cr=0
r=0 w=0 time=0 us)'
STAT #1 id=12 cnt=0 pid=1 pos=2 obj=310 op='FIXED TABLE FULL X$KZSPR (cr=0 r=0
w=0 time=0 us)'
STAT #1 id=13 cnt=0 pid=1 pos=2 obj=310 op='FIXED TABLE FULL X$KZSPR (cr=0 r=0
w=0 time=0 us)'
=====================
PARSING IN CURSOR #2 len=37 dep=1 uid=0 oct=3 lid=0 tim=1063030977849341
hv=3468666020 ad='31d96568'
select text from view$ where rowid=:1
END OF STMT
PARSE #2:c=0,e=35,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977849338
BINDS #2:
bind 0: dty=11 mxl=16(16) mal=00 scl=00 pre=00 oacflg=18 oacfl2=1 size=16
offset=0
bfp=1102c5310 bln=16 avl=16 flg=05
value=000003BC.0008.0001
EXEC #2:c=0,e=74,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977849501
FETCH #2:c=0,e=33,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=1063030977849555
STAT #2 id=1 cnt=1 pid=0 pos=1 obj=59 op='TABLE ACCESS BY USER ROWID VIEW$
(cr=1 r=0 w=0 time=18 us)'
=====================
PARSING IN CURSOR #1 len=95 dep=0 uid=151 oct=3 lid=151 tim=1063030977852094
hv=1399578166 ad='34c87648'
SELECT OWNER, SYNONYM_NAME FROM SYS.ALL_SYNONYMS WHERE OWNER = 'UWSA' AND
SYNONYM_NAME = 'DUAL'
END OF STMT
PARSE #1:c=0,e=3110,p=0,cr=2,cu=0,mis=1,r=0,dep=0,og=4,tim=1063030977852090
BINDS #1:
EXEC #1:c=0,e=62,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977852229
WAIT #1: nam='SQL*Net message to client' ela= 2 p1=1413697536 p2=1 p3=0
FETCH #1:c=0,e=78,p=0,cr=5,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977852357
WAIT #1: nam='SQL*Net message from client' ela= 2958 p1=1413697536 p2=1 p3=0
STAT #1 id=1 cnt=0 pid=0 pos=1 obj=0 op='FILTER (cr=5 r=0 w=0 time=74 us)'
STAT #1 id=2 cnt=0 pid=1 pos=1 obj=0 op='NESTED LOOPS (cr=5 r=0 w=0 time=74
us)'
STAT #1 id=3 cnt=0 pid=2 pos=1 obj=0 op='NESTED LOOPS (cr=5 r=0 w=0 time=73
us)'
STAT #1 id=4 cnt=1 pid=3 pos=1 obj=22 op='TABLE ACCESS BY INDEX ROWID USER$
(cr=2 r=0 w=0 time=29 us)'
STAT #1 id=5 cnt=1 pid=4 pos=1 obj=41 op='INDEX UNIQUE SCAN I_USER1 (cr=1 r=0
w=0 time=17 us)'
STAT #1 id=6 cnt=0 pid=3 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID OBJ$
(cr=3 r=0 w=0 time=34 us)'
STAT #1 id=7 cnt=1 pid=6 pos=1 obj=34 op='INDEX RANGE SCAN I_OBJ2 (cr=2 r=0 w=0
time=22 us)'
=====================
PARSING IN CURSOR #2 len=116 dep=1 uid=0 oct=3 lid=0 tim=1063030977855705
hv=431456802 ad='31f5d468'
select
o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.dataobj#,o.flags
from obj$ o where o.obj#=:1
END OF STMT
PARSE #2:c=0,e=51,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977855703
BINDS #2:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24
offset=0
bfp=1102dd568 bln=22 avl=02 flg=05
value=58
EXEC #2:c=0,e=109,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977855944
FETCH #2:c=0,e=36,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=1063030977856003
STAT #1 id=8 cnt=0 pid=2 pos=2 obj=58 op='TABLE ACCESS BY INDEX ROWID SYN$
(cr=0 r=0 w=0 time=0 us)'
STAT #1 id=9 cnt=0 pid=8 pos=1 obj=98 op='INDEX UNIQUE SCAN I_SYN1 (cr=0 r=0
w=0 time=0 us)'
STAT #1 id=10 cnt=0 pid=1 pos=2 obj=0 op='FILTER (cr=0 r=0 w=0 time=0 us)'
STAT #1 id=11 cnt=0 pid=10 pos=1 obj=0 op='NESTED LOOPS (cr=0 r=0 w=0 time=0
us)'
STAT #1 id=12 cnt=0 pid=11 pos=1 obj=0 op='NESTED LOOPS (cr=0 r=0 w=0 time=0
us)'
STAT #1 id=13 cnt=0 pid=12 pos=1 obj=22 op='TABLE ACCESS BY INDEX ROWID USER$
(cr=0 r=0 w=0 time=0 us)'
STAT #1 id=14 cnt=0 pid=13 pos=1 obj=41 op='INDEX UNIQUE SCAN I_USER1 (cr=0 r=0
w=0 time=0 us)'
STAT #1 id=15 cnt=0 pid=12 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID OBJ$
(cr=0 r=0 w=0 time=0 us)'
STAT #1 id=16 cnt=0 pid=15 pos=1 obj=34 op='INDEX RANGE SCAN I_OBJ2 (cr=0 r=0
w=0 time=0 us)'
STAT #1 id=17 cnt=0 pid=11 pos=2 obj=100 op='INDEX RANGE SCAN I_OBJAUTH1 (cr=0
r=0 w=0 time=0 us)'
STAT #1 id=18 cnt=0 pid=10 pos=2 obj=309 op='FIXED TABLE FULL X$KZSRO (cr=0 r=0
w=0 time=0 us)'
STAT #1 id=19 cnt=0 pid=1 pos=2 obj=310 op='FIXED TABLE FULL X$KZSPR (cr=0 r=0
w=0 time=0 us)'
=====================
PARSING IN CURSOR #3 len=37 dep=1 uid=0 oct=3 lid=0 tim=1063030977856645
hv=3468666020 ad='31d96568'
select text from view$ where rowid=:1
END OF STMT
PARSE #3:c=0,e=30,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977856643
BINDS #3:
bind 0: dty=11 mxl=16(16) mal=00 scl=00 pre=00 oacflg=18 oacfl2=1 size=16
offset=0
bfp=1102c5290 bln=16 avl=16 flg=05
value=000003BC.0008.0001
EXEC #3:c=0,e=65,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977856788
FETCH #3:c=0,e=28,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=1063030977856837
STAT #3 id=1 cnt=1 pid=0 pos=1 obj=59 op='TABLE ACCESS BY USER ROWID VIEW$
(cr=1 r=0 w=0 time=16 us)'
=====================
PARSING IN CURSOR #1 len=97 dep=0 uid=151 oct=3 lid=151 tim=1063030977859357
hv=2433821915 ad='34c6cf48'
SELECT OWNER, SYNONYM_NAME FROM SYS.ALL_SYNONYMS WHERE OWNER = 'PUBLIC' AND
SYNONYM_NAME = 'DUAL'
END OF STMT
PARSE #1:c=0,e=3039,p=0,cr=2,cu=0,mis=1,r=0,dep=0,og=4,tim=1063030977859353
BINDS #1:
EXEC #1:c=0,e=56,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977859483
WAIT #1: nam='SQL*Net message to client' ela= 2 p1=1413697536 p2=1 p3=0
FETCH #1:c=0,e=114,p=0,cr=8,cu=0,mis=0,r=1,dep=0,og=4,tim=1063030977859647
WAIT #1: nam='SQL*Net message from client' ela= 1163 p1=1413697536 p2=1 p3=0
FETCH #1:c=0,e=23,p=0,cr=1,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977860931
WAIT #1: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 1243 p1=1413697536 p2=1 p3=0
STAT #1 id=1 cnt=1 pid=0 pos=1 obj=0 op='FILTER (cr=9 r=0 w=0 time=122 us)'
STAT #1 id=2 cnt=1 pid=1 pos=1 obj=0 op='NESTED LOOPS (cr=9 r=0 w=0 time=115
us)'
STAT #1 id=3 cnt=1 pid=2 pos=1 obj=0 op='NESTED LOOPS (cr=6 r=0 w=0 time=86
us)'
STAT #1 id=4 cnt=1 pid=3 pos=1 obj=22 op='TABLE ACCESS BY INDEX ROWID USER$
(cr=2 r=0 w=0 time=32 us)'
STAT #1 id=5 cnt=1 pid=4 pos=1 obj=41 op='INDEX UNIQUE SCAN I_USER1 (cr=1 r=0
w=0 time=17 us)'
STAT #1 id=6 cnt=1 pid=3 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID OBJ$
(cr=4 r=0 w=0 time=46 us)'
STAT #1 id=7 cnt=1 pid=6 pos=1 obj=34 op='INDEX RANGE SCAN I_OBJ2 (cr=3 r=0 w=0
time=32 us)'
STAT #1 id=8 cnt=1 pid=2 pos=2 obj=58 op='TABLE ACCESS BY INDEX ROWID SYN$
(cr=3 r=0 w=0 time=24 us)'
STAT #1 id=9 cnt=1 pid=8 pos=1 obj=98 op='INDEX UNIQUE SCAN I_SYN1 (cr=2 r=0
w=0 time=13 us)'
STAT #1 id=10 cnt=0 pid=1 pos=2 obj=0 op='FILTER (cr=0 r=0 w=0 time=0 us)'
STAT #1 id=11 cnt=0 pid=10 pos=1 obj=0 op='NESTED LOOPS (cr=0 r=0 w=0 time=0
us)'
STAT #1 id=12 cnt=0 pid=11 pos=1 obj=0 op='NESTED LOOPS (cr=0 r=0 w=0 time=0
us)'
STAT #1 id=13 cnt=0 pid=12 pos=1 obj=22 op='TABLE ACCESS BY INDEX ROWID USER$
(cr=0 r=0 w=0 time=0 us)'
STAT #1 id=14 cnt=0 pid=13 pos=1 obj=41 op='INDEX UNIQUE SCAN I_USER1 (cr=0 r=0
w=0 time=0 us)'
STAT #1 id=15 cnt=0 pid=12 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID OBJ$
(cr=0 r=0 w=0 time=0 us)'
STAT #1 id=16 cnt=0 pid=15 pos=1 obj=34 op='INDEX RANGE SCAN I_OBJ2 (cr=0 r=0
w=0 time=0 us)'
STAT #1 id=17 cnt=0 pid=11 pos=2 obj=100 op='INDEX RANGE SCAN I_OBJAUTH1 (cr=0
r=0 w=0 time=0 us)'
STAT #1 id=18 cnt=0 pid=10 pos=2 obj=309 op='FIXED TABLE FULL X$KZSRO (cr=0 r=0
w=0 time=0 us)'
STAT #1 id=19 cnt=0 pid=1 pos=2 obj=310 op='FIXED TABLE FULL X$KZSPR (cr=0 r=0
w=0 time=0 us)'
=====================
PARSING IN CURSOR #1 len=276 dep=0 uid=151 oct=3 lid=151 tim=1063030977863756
hv=2671731006 ad='34c53228'
SELECT
PBD_FHGT,PBD_FWGT,PBD_FITL,PBD_FUNL,PBD_FCHR,PBD_FPTC,PBD_FFCE,PBH_FHGT,PBH_FWGT,PBH_FITL,PBH_FUNL,PBH_FCHR,PBH_FPTC,PBH_FFCE,PBL_FHGT,PBL_FWGT,PBL_FITL,PBL_FUNL,PBL_FCHR,PBL_FPTC,PBL_FFCE,PBT_CMNT
FROM SYSTEM.PBCATTBL WHERE PBT_OWNR = 'PUBLIC' AND PBT_TNAM = 'DUAL'
END OF STMT
PARSE #1:c=0,e=892,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=1063030977863753
BINDS #1:
EXEC #1:c=0,e=46,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977863889
WAIT #1: nam='SQL*Net message to client' ela= 2 p1=1413697536 p2=1 p3=0
FETCH #1:c=0,e=19,p=0,cr=1,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977864026
WAIT #1: nam='SQL*Net message from client' ela= 1959 p1=1413697536 p2=1 p3=0
=====================
PARSING IN CURSOR #2 len=116 dep=1 uid=0 oct=3 lid=0 tim=1063030977866197
hv=431456802 ad='31f5d468'
select
o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.dataobj#,o.flags
from obj$ o where o.obj#=:1
END OF STMT
PARSE #2:c=0,e=50,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977866194
BINDS #2:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24
offset=0
bfp=1102c5288 bln=22 avl=04 flg=05
value=36257
EXEC #2:c=0,e=78,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977866407
FETCH #2:c=0,e=41,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=1063030977866470
STAT #1 id=1 cnt=0 pid=0 pos=1 obj=36257 op='TABLE ACCESS BY INDEX ROWID
PBCATTBL (cr=1 r=0 w=0 time=14 us)'
STAT #1 id=2 cnt=0 pid=1 pos=1 obj=36258 op='INDEX UNIQUE SCAN PBSYSCATPBT_IDX
(cr=1 r=0 w=0 time=11 us)'
=====================
PARSING IN CURSOR #3 len=37 dep=1 uid=0 oct=3 lid=0 tim=1063030977866990
hv=3468666020 ad='31d96568'
select text from view$ where rowid=:1
END OF STMT
PARSE #3:c=0,e=32,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977866987
BINDS #3:
bind 0: dty=11 mxl=16(16) mal=00 scl=00 pre=00 oacflg=18 oacfl2=1 size=16
offset=0
bfp=1102dd610 bln=16 avl=16 flg=05
value=000003F8.0003.0001
EXEC #3:c=0,e=63,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977867130
FETCH #3:c=0,e=30,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=1063030977867181
STAT #3 id=1 cnt=1 pid=0 pos=1 obj=59 op='TABLE ACCESS BY USER ROWID VIEW$
(cr=1 r=0 w=0 time=17 us)'
=====================
PARSING IN CURSOR #3 len=37 dep=1 uid=0 oct=3 lid=0 tim=1063030977867568
hv=3468666020 ad='31d96568'
select text from view$ where rowid=:1
END OF STMT
PARSE #3:c=0,e=25,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977867565
BINDS #3:
bind 0: dty=11 mxl=16(16) mal=00 scl=00 pre=00 oacflg=18 oacfl2=1 size=16
offset=0
bfp=1102dd480 bln=16 avl=16 flg=05
value=000035A9.0006.0001
EXEC #3:c=0,e=59,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977867700
FETCH #3:c=0,e=25,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=1063030977867745
STAT #3 id=1 cnt=1 pid=0 pos=1 obj=59 op='TABLE ACCESS BY USER ROWID VIEW$
(cr=1 r=0 w=0 time=11 us)'
=====================
PARSING IN CURSOR #1 len=235 dep=0 uid=151 oct=3 lid=151 tim=1063030977874810
hv=3378243952 ad='34c4c178'
SELECT COLUMN_NAME, COLUMN_ID, DATA_TYPE_OWNER, DATA_TYPE, DATA_LENGTH,
CHAR_COL_DECL_LENGTH, DATA_PRECISION, DATA_SCALE, NULLABLE, DATA_DEFAULT FROM
SYS.ALL_TAB_COLUMNS WHERE TABLE_NAME = 'DUAL' AND OWNER = 'PUBLIC' ORDER BY
COLUMN_ID
END OF STMT
PARSE #1:c=0,e=8234,p=0,cr=4,cu=0,mis=1,r=0,dep=0,og=4,tim=1063030977874806
BINDS #1:
EXEC #1:c=0,e=244,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977875160
WAIT #1: nam='SQL*Net message to client' ela= 3 p1=1413697536 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 1279 p1=1413697536 p2=1 p3=0
FETCH #1:c=0,e=125,p=0,cr=7,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977876763
WAIT #1: nam='SQL*Net message to client' ela= 1 p1=1413697536 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 1366 p1=1413697536 p2=1 p3=0
STAT #1 id=16 cnt=0 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=7 r=0 w=0 time=115
us)'
STAT #1 id=17 cnt=0 pid=16 pos=1 obj=0 op='FILTER (cr=7 r=0 w=0 time=96 us)'
STAT #1 id=18 cnt=0 pid=17 pos=1 obj=0 op='NESTED LOOPS OUTER (cr=7 r=0 w=0
time=95 us)'
STAT #1 id=19 cnt=0 pid=18 pos=1 obj=0 op='NESTED LOOPS OUTER (cr=7 r=0 w=0
time=93 us)'
STAT #1 id=20 cnt=0 pid=19 pos=1 obj=0 op='NESTED LOOPS OUTER (cr=7 r=0 w=0
time=92 us)'
STAT #1 id=21 cnt=0 pid=20 pos=1 obj=0 op='NESTED LOOPS OUTER (cr=7 r=0 w=0
time=92 us)'
STAT #1 id=22 cnt=0 pid=21 pos=1 obj=0 op='NESTED LOOPS (cr=7 r=0 w=0 time=90
us)'
STAT #1 id=23 cnt=1 pid=22 pos=1 obj=0 op='NESTED LOOPS (cr=5 r=0 w=0 time=69
us)'
STAT #1 id=24 cnt=1 pid=23 pos=1 obj=22 op='TABLE ACCESS BY INDEX ROWID USER$
(cr=2 r=0 w=0 time=28 us)'
STAT #1 id=25 cnt=1 pid=24 pos=1 obj=41 op='INDEX UNIQUE SCAN I_USER1 (cr=1 r=0
w=0 time=13 us)'
STAT #1 id=26 cnt=1 pid=23 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID OBJ$
(cr=3 r=0 w=0 time=31 us)'
STAT #1 id=27 cnt=1 pid=26 pos=1 obj=34 op='INDEX RANGE SCAN I_OBJ2 (cr=2 r=0
w=0 time=21 us)'
STAT #1 id=28 cnt=0 pid=22 pos=2 obj=21 op='TABLE ACCESS CLUSTER COL$ (cr=2 r=0
w=0 time=17 us)'
STAT #1 id=29 cnt=0 pid=28 pos=1 obj=3 op='INDEX UNIQUE SCAN I_OBJ# (cr=2 r=0
w=0 time=16 us)'
=====================
PARSING IN CURSOR #2 len=116 dep=1 uid=0 oct=3 lid=0 tim=1063030977878681
hv=431456802 ad='31f5d468'
select
o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.dataobj#,o.flags
from obj$ o where o.obj#=:1
END OF STMT
PARSE #2:c=0,e=56,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977878679
BINDS #2:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24
offset=0
bfp=1102e47e8 bln=22 avl=03 flg=05
value=241
EXEC #2:c=0,e=82,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977878895
FETCH #2:c=0,e=37,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=1063030977878953
STAT #1 id=30 cnt=0 pid=21 pos=2 obj=241 op='TABLE ACCESS CLUSTER COLTYPE$
(cr=0 r=0 w=0 time=0 us)'
STAT #1 id=31 cnt=0 pid=20 pos=2 obj=194 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL#
(cr=0 r=0 w=0 time=0 us)'
STAT #1 id=32 cnt=0 pid=19 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID OBJ$
(cr=0 r=0 w=0 time=0 us)'
STAT #1 id=33 cnt=0 pid=32 pos=1 obj=35 op='INDEX RANGE SCAN I_OBJ3 (cr=0 r=0
w=0 time=0 us)'
STAT #1 id=34 cnt=0 pid=18 pos=2 obj=22 op='TABLE ACCESS CLUSTER USER$ (cr=0
r=0 w=0 time=0 us)'
STAT #1 id=35 cnt=0 pid=34 pos=1 obj=11 op='INDEX UNIQUE SCAN I_USER# (cr=0 r=0
w=0 time=0 us)'
STAT #1 id=36 cnt=0 pid=17 pos=2 obj=4 op='TABLE ACCESS CLUSTER TAB$ (cr=0 r=0
w=0 time=0 us)'
STAT #1 id=37 cnt=0 pid=36 pos=1 obj=3 op='INDEX UNIQUE SCAN I_OBJ# (cr=0 r=0
w=0 time=0 us)'
STAT #1 id=38 cnt=0 pid=17 pos=2 obj=0 op='NESTED LOOPS (cr=0 r=0 w=0 time=0
us)'
STAT #1 id=39 cnt=0 pid=38 pos=1 obj=309 op='FIXED TABLE FULL X$KZSRO (cr=0 r=0
w=0 time=0 us)'
STAT #1 id=40 cnt=0 pid=38 pos=2 obj=101 op='INDEX RANGE SCAN I_OBJAUTH2 (cr=0
r=0 w=0 time=0 us)'
STAT #1 id=41 cnt=0 pid=17 pos=2 obj=310 op='FIXED TABLE FULL X$KZSPR (cr=0 r=0
w=0 time=0 us)'
=====================
PARSING IN CURSOR #3 len=43 dep=1 uid=0 oct=3 lid=0 tim=1063030977879826
hv=2455283208 ad='31ee40e8'
select user#,type# from user$ where name=:1
END OF STMT
PARSE #3:c=0,e=354,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=1063030977879823
BINDS #3:
bind 0: dty=1 mxl=32(06) mal=00 scl=00 pre=00 oacflg=18 oacfl2=1 size=32
offset=0
bfp=1102c52f0 bln=32 avl=06 flg=05
value="PUBLIC"
EXEC #3:c=0,e=317,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977880240
FETCH #3:c=0,e=30,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=1063030977880296
=====================
PARSING IN CURSOR #1 len=29 dep=0 uid=151 oct=3 lid=151 tim=1063030977880574
hv=3203262218 ad='34c08508'
SELECT * FROM "PUBLIC"."DUAL"
END OF STMT
PARSE #1:c=0,e=1288,p=0,cr=2,cu=0,mis=1,r=0,dep=0,og=4,tim=1063030977880571
WAIT #1: nam='SQL*Net message to client' ela= 3 p1=1413697536 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 1516 p1=1413697536 p2=1 p3=0
=====================
PARSING IN CURSOR #1 len=71 dep=0 uid=151 oct=3 lid=151 tim=1063030977882758
hv=4167003566 ad='31c38090'
SELECT PBV_NAME,PBV_VALD,PBV_TYPE,PBV_CNTR,PBV_MSG FROM SYSTEM.PBCATVLD
END OF STMT
PARSE #1:c=0,e=477,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=1063030977882755
BINDS #1:
EXEC #1:c=0,e=35,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977882860
WAIT #1: nam='SQL*Net message to client' ela= 2 p1=1413697536 p2=1 p3=0
FETCH #1:c=0,e=59,p=0,cr=3,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977882974
WAIT #1: nam='SQL*Net message from client' ela= 1653 p1=1413697536 p2=1 p3=0
=====================
PARSING IN CURSOR #2 len=116 dep=1 uid=0 oct=3 lid=0 tim=1063030977884826
hv=431456802 ad='31f5d468'
select
o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.dataobj#,o.flags
from obj$ o where o.obj#=:1
END OF STMT
PARSE #2:c=0,e=46,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977884823
BINDS #2:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24
offset=0
bfp=1102c5288 bln=22 avl=04 flg=05
value=36263
EXEC #2:c=0,e=79,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977885031
FETCH #2:c=0,e=38,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=1063030977885090
STAT #1 id=1 cnt=0 pid=0 pos=1 obj=36263 op='TABLE ACCESS FULL PBCATVLD (cr=3
r=0 w=0 time=56 us)'
=====================
PARSING IN CURSOR #1 len=63 dep=0 uid=151 oct=3 lid=151 tim=1063030977885676
hv=1175394665 ad='31c351f0'
SELECT PBF_NAME,PBF_FRMT,PBF_TYPE,PBF_CNTR FROM SYSTEM.PBCATFMT
END OF STMT
PARSE #1:c=0,e=505,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=1063030977885672
BINDS #1:
EXEC #1:c=0,e=28,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977885769
WAIT #1: nam='SQL*Net message to client' ela= 2 p1=1413697536 p2=1 p3=0
FETCH #1:c=0,e=55,p=0,cr=3,cu=0,mis=0,r=1,dep=0,og=4,tim=1063030977885878
WAIT #1: nam='SQL*Net message from client' ela= 1272 p1=1413697536 p2=1 p3=0
WAIT #1: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
FETCH #1:c=0,e=77,p=0,cr=1,cu=0,mis=0,r=19,dep=0,og=4,tim=1063030977887302
WAIT #1: nam='SQL*Net message from client' ela= 2325 p1=1413697536 p2=1 p3=0
=====================
PARSING IN CURSOR #2 len=116 dep=1 uid=0 oct=3 lid=0 tim=1063030977889810
hv=431456802 ad='31f5d468'
select
o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.dataobj#,o.flags
from obj$ o where o.obj#=:1
END OF STMT
PARSE #2:c=0,e=45,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977889808
BINDS #2:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24
offset=0
bfp=1102e4a68 bln=22 avl=04 flg=05
value=36261
EXEC #2:c=0,e=78,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977890018
FETCH #2:c=0,e=36,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=1063030977890076
STAT #1 id=1 cnt=20 pid=0 pos=1 obj=36261 op='TABLE ACCESS FULL PBCATFMT (cr=4
r=0 w=0 time=76 us)'
=====================
PARSING IN CURSOR #1 len=117 dep=0 uid=151 oct=3 lid=151 tim=1063030977890750
hv=3941777003 ad='31c5a970'
SELECT PBE_NAME,PBE_EDIT,PBE_TYPE,PBE_CNTR,PBE_WORK,PBE_SEQN,PBE_FLAG FROM
SYSTEM.PBCATEDT ORDER BY PBE_NAME,PBE_SEQN
END OF STMT
PARSE #1:c=0,e=593,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=1063030977890746
BINDS #1:
EXEC #1:c=0,e=49,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977890868
WAIT #1: nam='SQL*Net message to client' ela= 3 p1=1413697536 p2=1 p3=0
FETCH #1:c=0,e=150,p=0,cr=3,cu=0,mis=0,r=1,dep=0,og=4,tim=1063030977891082
WAIT #1: nam='SQL*Net message from client' ela= 1234 p1=1413697536 p2=1 p3=0
WAIT #1: nam='SQL*Net message to client' ela= 1 p1=1413697536 p2=1 p3=0
FETCH #1:c=0,e=92,p=0,cr=0,cu=0,mis=0,r=20,dep=0,og=4,tim=1063030977892486
WAIT #1: nam='SQL*Net message from client' ela= 1906 p1=1413697536 p2=1 p3=0
STAT #1 id=1 cnt=21 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=3 r=0 w=0 time=173
us)'
=====================
PARSING IN CURSOR #2 len=116 dep=1 uid=0 oct=3 lid=0 tim=1063030977894604
hv=431456802 ad='31f5d468'
select
o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.dataobj#,o.flags
from obj$ o where o.obj#=:1
END OF STMT
PARSE #2:c=0,e=46,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977894601
BINDS #2:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24
offset=0
bfp=1102e4950 bln=22 avl=04 flg=05
value=36265
EXEC #2:c=0,e=82,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977894844
FETCH #2:c=0,e=37,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=1063030977894903
STAT #1 id=2 cnt=21 pid=1 pos=1 obj=36265 op='TABLE ACCESS FULL PBCATEDT (cr=3
r=0 w=0 time=56 us)'
=====================
PARSING IN CURSOR #1 len=229 dep=0 uid=151 oct=3 lid=151 tim=1063030977895813
hv=2117949404 ad='34bf5208'
SELECT
PBC_CNAM,PBC_TNAM,PBC_OWNR,PBC_LABL,PBC_LPOS,PBC_HDR,PBC_HPOS,PBC_JTFY,PBC_MASK,PBC_CASE,PBC_HGHT,PBC_WDTH,PBC_PTRN,PBC_BMAP,PBC_INIT,PBC_EDIT,PBC_CMNT
FROM SYSTEM.PBCATCOL WHERE (PBC_TNAM = 'DUAL' AND PBC_OWNR = 'UWSA')
END OF STMT
PARSE #1:c=0,e=830,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=1063030977895810
BINDS #1:
EXEC #1:c=0,e=45,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977895937
WAIT #1: nam='SQL*Net message to client' ela= 2 p1=1413697536 p2=1 p3=0
FETCH #1:c=0,e=27,p=0,cr=1,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977896063
WAIT #1: nam='SQL*Net message from client' ela= 1806 p1=1413697536 p2=1 p3=0
=====================
PARSING IN CURSOR #2 len=116 dep=1 uid=0 oct=3 lid=0 tim=1063030977898067
hv=431456802 ad='31f5d468'
select
o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.dataobj#,o.flags
from obj$ o where o.obj#=:1
END OF STMT
PARSE #2:c=0,e=46,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977898065
BINDS #2:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24
offset=0
bfp=1102c5288 bln=22 avl=04 flg=05
value=36259
EXEC #2:c=0,e=77,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977898271
FETCH #2:c=0,e=34,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=1063030977898326
STAT #1 id=1 cnt=0 pid=0 pos=1 obj=36259 op='TABLE ACCESS BY INDEX ROWID
PBCATCOL (cr=1 r=0 w=0 time=22 us)'
STAT #1 id=2 cnt=0 pid=1 pos=1 obj=36260 op='INDEX RANGE SCAN
PBSYSCATCOLDICT_IDX (cr=1 r=0 w=0 time=21 us)'
=====================
PARSING IN CURSOR #3 len=37 dep=1 uid=0 oct=3 lid=0 tim=1063030977898759
hv=3468666020 ad='31d96568'
select text from view$ where rowid=:1
END OF STMT
PARSE #3:c=0,e=31,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977898756
BINDS #3:
bind 0: dty=11 mxl=16(16) mal=00 scl=00 pre=00 oacflg=18 oacfl2=1 size=16
offset=0
bfp=1102f0168 bln=16 avl=16 flg=05
value=000003B9.0005.0001
EXEC #3:c=0,e=63,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977898899
FETCH #3:c=0,e=33,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=1063030977898952
STAT #3 id=1 cnt=1 pid=0 pos=1 obj=59 op='TABLE ACCESS BY USER ROWID VIEW$
(cr=1 r=0 w=0 time=16 us)'
=====================
PARSING IN CURSOR #1 len=102 dep=0 uid=151 oct=3 lid=151 tim=1063030977904309
hv=1902070077 ad='34bee638'
SELECT INDEX_NAME, UNIQUENESS FROM SYS.ALL_INDEXES WHERE TABLE_OWNER = 'UWSA'
AND TABLE_NAME = 'DUAL'
END OF STMT
PARSE #1:c=10000,e=5879,p=0,cr=2,cu=0,mis=1,r=0,dep=0,og=4,tim=1063030977904305
BINDS #1:
EXEC #1:c=0,e=74,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977904456
WAIT #1: nam='SQL*Net message to client' ela= 3 p1=1413697536 p2=1 p3=0
FETCH #1:c=0,e=84,p=0,cr=5,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977904591
WAIT #1: nam='SQL*Net message from client' ela= 1779 p1=1413697536 p2=1 p3=0
STAT #1 id=1 cnt=0 pid=0 pos=1 obj=0 op='FILTER (cr=5 r=0 w=0 time=81 us)'
STAT #1 id=2 cnt=0 pid=1 pos=1 obj=0 op='NESTED LOOPS OUTER (cr=5 r=0 w=0
time=79 us)'
STAT #1 id=3 cnt=0 pid=2 pos=1 obj=0 op='NESTED LOOPS OUTER (cr=5 r=0 w=0
time=78 us)'
STAT #1 id=4 cnt=0 pid=3 pos=1 obj=0 op='NESTED LOOPS (cr=5 r=0 w=0 time=78
us)'
STAT #1 id=5 cnt=0 pid=4 pos=1 obj=0 op='NESTED LOOPS OUTER (cr=5 r=0 w=0
time=77 us)'
STAT #1 id=6 cnt=0 pid=5 pos=1 obj=0 op='NESTED LOOPS (cr=5 r=0 w=0 time=76
us)'
STAT #1 id=7 cnt=0 pid=6 pos=1 obj=0 op='NESTED LOOPS OUTER (cr=5 r=0 w=0
time=75 us)'
STAT #1 id=8 cnt=0 pid=7 pos=1 obj=0 op='NESTED LOOPS (cr=5 r=0 w=0 time=74
us)'
STAT #1 id=9 cnt=0 pid=8 pos=1 obj=0 op='NESTED LOOPS (cr=5 r=0 w=0 time=74
us)'
STAT #1 id=10 cnt=1 pid=9 pos=1 obj=22 op='TABLE ACCESS BY INDEX ROWID USER$
(cr=2 r=0 w=0 time=30 us)'
STAT #1 id=11 cnt=1 pid=10 pos=1 obj=41 op='INDEX UNIQUE SCAN I_USER1 (cr=1 r=0
w=0 time=17 us)'
STAT #1 id=12 cnt=0 pid=9 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID OBJ$
(cr=3 r=0 w=0 time=36 us)'
STAT #1 id=13 cnt=1 pid=12 pos=1 obj=34 op='INDEX RANGE SCAN I_OBJ2 (cr=2 r=0
w=0 time=22 us)'
STAT #1 id=14 cnt=0 pid=8 pos=2 obj=19 op='TABLE ACCESS CLUSTER IND$ (cr=0 r=0
w=0 time=0 us)'
STAT #1 id=15 cnt=0 pid=14 pos=1 obj=3 op='INDEX UNIQUE SCAN I_OBJ# (cr=0 r=0
w=0 time=0 us)'
STAT #1 id=16 cnt=0 pid=7 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID OBJ$
(cr=0 r=0 w=0 time=0 us)'
STAT #1 id=17 cnt=0 pid=16 pos=1 obj=33 op='INDEX UNIQUE SCAN I_OBJ1 (cr=0 r=0
w=0 time=0 us)'
STAT #1 id=18 cnt=0 pid=6 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID OBJ$
(cr=0 r=0 w=0 time=0 us)'
STAT #1 id=19 cnt=0 pid=18 pos=1 obj=33 op='INDEX UNIQUE SCAN I_OBJ1 (cr=0 r=0
w=0 time=0 us)'
STAT #1 id=20 cnt=0 pid=5 pos=2 obj=22 op='TABLE ACCESS CLUSTER USER$ (cr=0 r=0
w=0 time=0 us)'
STAT #1 id=21 cnt=0 pid=20 pos=1 obj=11 op='INDEX UNIQUE SCAN I_USER# (cr=0 r=0
w=0 time=0 us)'
STAT #1 id=22 cnt=0 pid=4 pos=2 obj=22 op='TABLE ACCESS CLUSTER USER$ (cr=0 r=0
w=0 time=0 us)'
STAT #1 id=23 cnt=0 pid=22 pos=1 obj=11 op='INDEX UNIQUE SCAN I_USER# (cr=0 r=0
w=0 time=0 us)'
STAT #1 id=24 cnt=0 pid=3 pos=2 obj=14 op='TABLE ACCESS CLUSTER SEG$ (cr=0 r=0
w=0 time=0 us)'
STAT #1 id=25 cnt=0 pid=24 pos=1 obj=9 op='INDEX UNIQUE SCAN I_FILE#_BLOCK#
(cr=0 r=0 w=0 time=0 us)'
STAT #1 id=26 cnt=0 pid=2 pos=2 obj=16 op='TABLE ACCESS CLUSTER TS$ (cr=0 r=0
w=0 time=0 us)'
STAT #1 id=27 cnt=0 pid=26 pos=1 obj=7 op='INDEX UNIQUE SCAN I_TS# (cr=0 r=0
w=0 time=0 us)'
STAT #1 id=28 cnt=0 pid=1 pos=2 obj=0 op='NESTED LOOPS (cr=0 r=0 w=0 time=0
us)'
STAT #1 id=29 cnt=0 pid=28 pos=1 obj=309 op='FIXED TABLE FULL X$KZSRO (cr=0 r=0
w=0 time=0 us)'
STAT #1 id=30 cnt=0 pid=28 pos=2 obj=101 op='INDEX RANGE SCAN I_OBJAUTH2 (cr=0
r=0 w=0 time=0 us)'
STAT #1 id=31 cnt=0 pid=1 pos=2 obj=310 op='FIXED TABLE FULL X$KZSPR (cr=0 r=0
w=0 time=0 us)'
=====================
PARSING IN CURSOR #2 len=37 dep=1 uid=0 oct=3 lid=0 tim=1063030977907704
hv=3468666020 ad='31d96568'
select text from view$ where rowid=:1
END OF STMT
PARSE #2:c=0,e=39,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977907702
BINDS #2:
bind 0: dty=11 mxl=16(16) mal=00 scl=00 pre=00 oacflg=18 oacfl2=1 size=16
offset=0
bfp=1102c5310 bln=16 avl=16 flg=05
value=000003BC.0008.0001
EXEC #2:c=0,e=75,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977907867
FETCH #2:c=0,e=33,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=1063030977907922
STAT #2 id=1 cnt=1 pid=0 pos=1 obj=59 op='TABLE ACCESS BY USER ROWID VIEW$
(cr=1 r=0 w=0 time=18 us)'
=====================
PARSING IN CURSOR #1 len=137 dep=0 uid=151 oct=3 lid=151 tim=1063030977910581
hv=584147568 ad='34bc9668'
SELECT TABLE_OWNER, TABLE_NAME FROM SYS.ALL_SYNONYMS WHERE OWNER = 'UWSA' AND
SYNONYM_NAME = 'DUAL' AND (DB_LINK IS NULL OR DB_LINK = '')
END OF STMT
PARSE #1:c=0,e=3272,p=0,cr=2,cu=0,mis=1,r=0,dep=0,og=4,tim=1063030977910578
BINDS #1:
EXEC #1:c=0,e=60,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977910714
WAIT #1: nam='SQL*Net message to client' ela= 3 p1=1413697536 p2=1 p3=0
FETCH #1:c=0,e=76,p=0,cr=5,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977910841
WAIT #1: nam='SQL*Net message from client' ela= 2395 p1=1413697536 p2=1 p3=0
STAT #1 id=1 cnt=0 pid=0 pos=1 obj=0 op='FILTER (cr=5 r=0 w=0 time=73 us)'
STAT #1 id=2 cnt=0 pid=1 pos=1 obj=0 op='NESTED LOOPS (cr=5 r=0 w=0 time=72
us)'
STAT #1 id=3 cnt=0 pid=2 pos=1 obj=0 op='NESTED LOOPS (cr=5 r=0 w=0 time=70
us)'
STAT #1 id=4 cnt=1 pid=3 pos=1 obj=22 op='TABLE ACCESS BY INDEX ROWID USER$
(cr=2 r=0 w=0 time=29 us)'
STAT #1 id=5 cnt=1 pid=4 pos=1 obj=41 op='INDEX UNIQUE SCAN I_USER1 (cr=1 r=0
w=0 time=16 us)'
STAT #1 id=6 cnt=0 pid=3 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID OBJ$
(cr=3 r=0 w=0 time=34 us)'
STAT #1 id=7 cnt=1 pid=6 pos=1 obj=34 op='INDEX RANGE SCAN I_OBJ2 (cr=2 r=0 w=0
time=22 us)'
STAT #1 id=8 cnt=0 pid=2 pos=2 obj=58 op='TABLE ACCESS BY INDEX ROWID SYN$
(cr=0 r=0 w=0 time=0 us)'
STAT #1 id=9 cnt=0 pid=8 pos=1 obj=98 op='INDEX UNIQUE SCAN I_SYN1 (cr=0 r=0
w=0 time=0 us)'
STAT #1 id=10 cnt=0 pid=1 pos=2 obj=0 op='FILTER (cr=0 r=0 w=0 time=0 us)'
STAT #1 id=11 cnt=0 pid=10 pos=1 obj=0 op='NESTED LOOPS (cr=0 r=0 w=0 time=0
us)'
STAT #1 id=12 cnt=0 pid=11 pos=1 obj=0 op='NESTED LOOPS (cr=0 r=0 w=0 time=0
us)'
STAT #1 id=13 cnt=0 pid=12 pos=1 obj=22 op='TABLE ACCESS BY INDEX ROWID USER$
(cr=0 r=0 w=0 time=0 us)'
STAT #1 id=14 cnt=0 pid=13 pos=1 obj=41 op='INDEX UNIQUE SCAN I_USER1 (cr=0 r=0
w=0 time=0 us)'
STAT #1 id=15 cnt=0 pid=12 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID OBJ$
(cr=0 r=0 w=0 time=0 us)'
STAT #1 id=16 cnt=0 pid=15 pos=1 obj=34 op='INDEX RANGE SCAN I_OBJ2 (cr=0 r=0
w=0 time=0 us)'
STAT #1 id=17 cnt=0 pid=11 pos=2 obj=100 op='INDEX RANGE SCAN I_OBJAUTH1 (cr=0
r=0 w=0 time=0 us)'
STAT #1 id=18 cnt=0 pid=10 pos=2 obj=309 op='FIXED TABLE FULL X$KZSRO (cr=0 r=0
w=0 time=0 us)'
STAT #1 id=19 cnt=0 pid=1 pos=2 obj=310 op='FIXED TABLE FULL X$KZSPR (cr=0 r=0
w=0 time=0 us)'
=====================
PARSING IN CURSOR #2 len=37 dep=1 uid=0 oct=3 lid=0 tim=1063030977914225
hv=3468666020 ad='31d96568'
select text from view$ where rowid=:1
END OF STMT
PARSE #2:c=0,e=37,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977914222
BINDS #2:
bind 0: dty=11 mxl=16(16) mal=00 scl=00 pre=00 oacflg=18 oacfl2=1 size=16
offset=0
bfp=1102c5310 bln=16 avl=16 flg=05
value=000003BC.0008.0001
EXEC #2:c=0,e=75,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977914387
FETCH #2:c=0,e=30,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=1063030977914439
STAT #2 id=1 cnt=1 pid=0 pos=1 obj=59 op='TABLE ACCESS BY USER ROWID VIEW$
(cr=1 r=0 w=0 time=17 us)'
=====================
PARSING IN CURSOR #1 len=139 dep=0 uid=151 oct=3 lid=151 tim=1063030977917049
hv=3731089617 ad='34bafce0'
SELECT TABLE_OWNER, TABLE_NAME FROM SYS.ALL_SYNONYMS WHERE OWNER = 'PUBLIC' AND
SYNONYM_NAME = 'DUAL' AND (DB_LINK IS NULL OR DB_LINK = '')
END OF STMT
PARSE #1:c=10000,e=3217,p=0,cr=2,cu=0,mis=1,r=0,dep=0,og=4,tim=1063030977917045
BINDS #1:
EXEC #1:c=0,e=60,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977917181
WAIT #1: nam='SQL*Net message to client' ela= 3 p1=1413697536 p2=1 p3=0
FETCH #1:c=0,e=103,p=0,cr=8,cu=0,mis=0,r=1,dep=0,og=4,tim=1063030977917334
WAIT #1: nam='SQL*Net message from client' ela= 1101 p1=1413697536 p2=1 p3=0
FETCH #1:c=0,e=20,p=0,cr=1,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977918551
WAIT #1: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 1231 p1=1413697536 p2=1 p3=0
STAT #1 id=1 cnt=1 pid=0 pos=1 obj=0 op='FILTER (cr=9 r=0 w=0 time=109 us)'
STAT #1 id=2 cnt=1 pid=1 pos=1 obj=0 op='NESTED LOOPS (cr=9 r=0 w=0 time=103
us)'
STAT #1 id=3 cnt=1 pid=2 pos=1 obj=0 op='NESTED LOOPS (cr=6 r=0 w=0 time=80
us)'
STAT #1 id=4 cnt=1 pid=3 pos=1 obj=22 op='TABLE ACCESS BY INDEX ROWID USER$
(cr=2 r=0 w=0 time=31 us)'
STAT #1 id=5 cnt=1 pid=4 pos=1 obj=41 op='INDEX UNIQUE SCAN I_USER1 (cr=1 r=0
w=0 time=17 us)'
STAT #1 id=6 cnt=1 pid=3 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID OBJ$
(cr=4 r=0 w=0 time=41 us)'
STAT #1 id=7 cnt=1 pid=6 pos=1 obj=34 op='INDEX RANGE SCAN I_OBJ2 (cr=3 r=0 w=0
time=28 us)'
STAT #1 id=8 cnt=1 pid=2 pos=2 obj=58 op='TABLE ACCESS BY INDEX ROWID SYN$
(cr=3 r=0 w=0 time=19 us)'
STAT #1 id=9 cnt=1 pid=8 pos=1 obj=98 op='INDEX UNIQUE SCAN I_SYN1 (cr=2 r=0
w=0 time=10 us)'
STAT #1 id=10 cnt=0 pid=1 pos=2 obj=0 op='FILTER (cr=0 r=0 w=0 time=0 us)'
STAT #1 id=11 cnt=0 pid=10 pos=1 obj=0 op='NESTED LOOPS (cr=0 r=0 w=0 time=0
us)'
STAT #1 id=12 cnt=0 pid=11 pos=1 obj=0 op='NESTED LOOPS (cr=0 r=0 w=0 time=0
us)'
STAT #1 id=13 cnt=0 pid=12 pos=1 obj=22 op='TABLE ACCESS BY INDEX ROWID USER$
(cr=0 r=0 w=0 time=0 us)'
STAT #1 id=14 cnt=0 pid=13 pos=1 obj=41 op='INDEX UNIQUE SCAN I_USER1 (cr=0 r=0
w=0 time=0 us)'
STAT #1 id=15 cnt=0 pid=12 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID OBJ$
(cr=0 r=0 w=0 time=0 us)'
STAT #1 id=16 cnt=0 pid=15 pos=1 obj=34 op='INDEX RANGE SCAN I_OBJ2 (cr=0 r=0
w=0 time=0 us)'
STAT #1 id=17 cnt=0 pid=11 pos=2 obj=100 op='INDEX RANGE SCAN I_OBJAUTH1 (cr=0
r=0 w=0 time=0 us)'
STAT #1 id=18 cnt=0 pid=10 pos=2 obj=309 op='FIXED TABLE FULL X$KZSRO (cr=0 r=0
w=0 time=0 us)'
STAT #1 id=19 cnt=0 pid=1 pos=2 obj=310 op='FIXED TABLE FULL X$KZSPR (cr=0 r=0
w=0 time=0 us)'
=====================
PARSING IN CURSOR #2 len=37 dep=1 uid=0 oct=3 lid=0 tim=1063030977920720
hv=3468666020 ad='31d96568'
select text from view$ where rowid=:1
END OF STMT
PARSE #2:c=0,e=37,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977920718
BINDS #2:
bind 0: dty=11 mxl=16(16) mal=00 scl=00 pre=00 oacflg=18 oacfl2=1 size=16
offset=0
bfp=1102c5310 bln=16 avl=16 flg=05
value=000003B9.0005.0001
EXEC #2:c=0,e=75,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977920881
FETCH #2:c=0,e=30,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=1063030977920933
STAT #2 id=1 cnt=1 pid=0 pos=1 obj=59 op='TABLE ACCESS BY USER ROWID VIEW$
(cr=1 r=0 w=0 time=17 us)'
=====================
PARSING IN CURSOR #1 len=101 dep=0 uid=151 oct=3 lid=151 tim=1063030977926355
hv=1239511293 ad='34b95968'
SELECT INDEX_NAME, UNIQUENESS FROM SYS.ALL_INDEXES WHERE TABLE_OWNER = 'SYS'
AND TABLE_NAME = 'DUAL'
END OF STMT
PARSE #1:c=10000,e=5993,p=0,cr=2,cu=0,mis=1,r=0,dep=0,og=4,tim=1063030977926351
BINDS #1:
EXEC #1:c=0,e=78,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977926506
WAIT #1: nam='SQL*Net message to client' ela= 2 p1=1413697536 p2=1 p3=0
FETCH #1:c=0,e=119,p=0,cr=8,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977926677
WAIT #1: nam='SQL*Net message from client' ela= 48008 p1=1413697536 p2=1 p3=0
=====================
PARSING IN CURSOR #2 len=18 dep=0 uid=151 oct=3 lid=151 tim=1063030977974903
hv=1333943659 ad='34cad458'
select * from dual
END OF STMT
PARSE #2:c=0,e=71,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977974899
WAIT #2: nam='SQL*Net message to client' ela= 2 p1=1413697536 p2=1 p3=0
WAIT #2: nam='SQL*Net message from client' ela= 1473 p1=1413697536 p2=1 p3=0
STAT #1 id=1 cnt=0 pid=0 pos=1 obj=0 op='FILTER (cr=8 r=0 w=0 time=115 us)'
STAT #1 id=2 cnt=0 pid=1 pos=1 obj=0 op='NESTED LOOPS OUTER (cr=8 r=0 w=0
time=115 us)'
STAT #1 id=3 cnt=0 pid=2 pos=1 obj=0 op='NESTED LOOPS OUTER (cr=8 r=0 w=0
time=113 us)'
STAT #1 id=4 cnt=0 pid=3 pos=1 obj=0 op='NESTED LOOPS (cr=8 r=0 w=0 time=112
us)'
STAT #1 id=5 cnt=0 pid=4 pos=1 obj=0 op='NESTED LOOPS OUTER (cr=8 r=0 w=0
time=112 us)'
STAT #1 id=6 cnt=0 pid=5 pos=1 obj=0 op='NESTED LOOPS (cr=8 r=0 w=0 time=110
us)'
STAT #1 id=7 cnt=0 pid=6 pos=1 obj=0 op='NESTED LOOPS OUTER (cr=8 r=0 w=0
time=110 us)'
STAT #1 id=8 cnt=0 pid=7 pos=1 obj=0 op='NESTED LOOPS (cr=8 r=0 w=0 time=108
us)'
STAT #1 id=9 cnt=1 pid=8 pos=1 obj=0 op='NESTED LOOPS (cr=5 r=0 w=0 time=77
us)'
STAT #1 id=10 cnt=1 pid=9 pos=1 obj=22 op='TABLE ACCESS BY INDEX ROWID USER$
(cr=2 r=0 w=0 time=31 us)'
STAT #1 id=11 cnt=1 pid=10 pos=1 obj=41 op='INDEX UNIQUE SCAN I_USER1 (cr=1 r=0
w=0 time=15 us)'
STAT #1 id=12 cnt=1 pid=9 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID OBJ$
(cr=3 r=0 w=0 time=37 us)'
STAT #1 id=13 cnt=1 pid=12 pos=1 obj=34 op='INDEX RANGE SCAN I_OBJ2 (cr=2 r=0
w=0 time=24 us)'
STAT #1 id=14 cnt=0 pid=8 pos=2 obj=19 op='TABLE ACCESS CLUSTER IND$ (cr=3 r=0
w=0 time=29 us)'
STAT #1 id=15 cnt=1 pid=14 pos=1 obj=3 op='INDEX UNIQUE SCAN I_OBJ# (cr=2 r=0
w=0 time=11 us)'
STAT #1 id=16 cnt=0 pid=7 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID OBJ$
(cr=0 r=0 w=0 time=0 us)'
STAT #1 id=17 cnt=0 pid=16 pos=1 obj=33 op='INDEX UNIQUE SCAN I_OBJ1 (cr=0 r=0
w=0 time=0 us)'
STAT #1 id=18 cnt=0 pid=6 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID OBJ$
(cr=0 r=0 w=0 time=0 us)'
STAT #1 id=19 cnt=0 pid=18 pos=1 obj=33 op='INDEX UNIQUE SCAN I_OBJ1 (cr=0 r=0
w=0 time=0 us)'
STAT #1 id=20 cnt=0 pid=5 pos=2 obj=22 op='TABLE ACCESS CLUSTER USER$ (cr=0 r=0
w=0 time=0 us)'
STAT #1 id=21 cnt=0 pid=20 pos=1 obj=11 op='INDEX UNIQUE SCAN I_USER# (cr=0 r=0
w=0 time=0 us)'
STAT #1 id=22 cnt=0 pid=4 pos=2 obj=22 op='TABLE ACCESS CLUSTER USER$ (cr=0 r=0
w=0 time=0 us)'
STAT #1 id=23 cnt=0 pid=22 pos=1 obj=11 op='INDEX UNIQUE SCAN I_USER# (cr=0 r=0
w=0 time=0 us)'
STAT #1 id=24 cnt=0 pid=3 pos=2 obj=14 op='TABLE ACCESS CLUSTER SEG$ (cr=0 r=0
w=0 time=0 us)'
STAT #1 id=25 cnt=0 pid=24 pos=1 obj=9 op='INDEX UNIQUE SCAN I_FILE#_BLOCK#
(cr=0 r=0 w=0 time=0 us)'
STAT #1 id=26 cnt=0 pid=2 pos=2 obj=16 op='TABLE ACCESS CLUSTER TS$ (cr=0 r=0
w=0 time=0 us)'
STAT #1 id=27 cnt=0 pid=26 pos=1 obj=7 op='INDEX UNIQUE SCAN I_TS# (cr=0 r=0
w=0 time=0 us)'
STAT #1 id=28 cnt=0 pid=1 pos=2 obj=0 op='NESTED LOOPS (cr=0 r=0 w=0 time=0
us)'
STAT #1 id=29 cnt=0 pid=28 pos=1 obj=309 op='FIXED TABLE FULL X$KZSRO (cr=0 r=0
w=0 time=0 us)'
STAT #1 id=30 cnt=0 pid=28 pos=2 obj=101 op='INDEX RANGE SCAN I_OBJAUTH2 (cr=0
r=0 w=0 time=0 us)'
STAT #1 id=31 cnt=0 pid=1 pos=2 obj=310 op='FIXED TABLE FULL X$KZSPR (cr=0 r=0
w=0 time=0 us)'
=====================
PARSING IN CURSOR #1 len=18 dep=0 uid=151 oct=3 lid=151 tim=1063030977977330
hv=1333943659 ad='34cad458'
select * from dual
END OF STMT
PARSE #1:c=0,e=31,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977977327
BINDS #1:
EXEC #1:c=0,e=46,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977977430
WAIT #1: nam='SQL*Net message to client' ela= 1 p1=1413697536 p2=1 p3=0
FETCH #1:c=0,e=77,p=0,cr=3,cu=0,mis=0,r=1,dep=0,og=4,tim=1063030977977547
WAIT #1: nam='SQL*Net message from client' ela= 553 p1=1413697536 p2=1 p3=0
FETCH #1:c=0,e=1,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,tim=1063030977978174
WAIT #1: nam='SQL*Net message to client' ela= 1 p1=1413697536 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 7914 p1=1413697536 p2=1 p3=0
XCTEND rlbk=1, rd_only=1
WAIT #0: nam='SQL*Net message to client' ela= 1 p1=1413697536 p2=1 p3=0
WAIT #0: nam='SQL*Net message from client' ela= 7313 p1=1413697536 p2=1 p3=0
=====================
PARSING IN CURSOR #2 len=116 dep=1 uid=0 oct=3 lid=0 tim=1063030977993750
hv=431456802 ad='31f5d468'
select
o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.dataobj#,o.flags
from obj$ o where o.obj#=:1
END OF STMT
PARSE #2:c=0,e=97,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977993747
BINDS #2:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24
offset=0
bfp=1102c5240 bln=22 avl=03 flg=05
value=195
EXEC #2:c=0,e=90,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977993980
FETCH #2:c=0,e=44,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=1063030977994045
STAT #1 id=1 cnt=1 pid=0 pos=1 obj=195 op='TABLE ACCESS FULL DUAL (cr=3 r=0 w=0
time=68 us)'
=====================
PARSE ERROR #1:len=5 dep=0 uid=151 oct=0 lid=151 tim=1063030977994272 err=900
exit
WAIT #1: nam='SQL*Net break/reset to client' ela= 52 p1=1413697536 p2=1 p3=0
WAIT #1: nam='SQL*Net break/reset to client' ela= 445 p1=1413697536 p2=0 p3=0
WAIT #1: nam='SQL*Net message to client' ela= 2 p1=1413697536 p2=1 p3=0
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
