Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Double database load.

RE: Double database load.

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Tue, 29 Jun 2004 18:44:50 -0500
Message-ID: <0186754BC82DD511B5C600B0D0AAC4D607B008FF@EXCHMN3> 





Chaya


   In addition to the suggestions from Juan and Tanel, I would suggest that
you collect statistics at the server level for CPU, I/O, and Memory. You
don't mention the type of server you have, but many Unix systems have the
iostat utility that does a pretty fair job. Write a script to aggregate
these values. Then graph them over hours and days. This will give you a
picture of when the server is heavily loaded and when it has available
capacity. To give credit where it is due, Don Burleson outlines these ideas
in his book Oracle9i High-Performance Tuning with STATSPACK. I don't think
his methods will solve every tuning problem, but it might help in your
situation. His book includes some scripts for aggregating statistics.


   DW servers often have long periods of relatively little usage. Increasing
capacity is often a matter of rescheduling loads and reports, or figuring
out how to make some processes play better together. Also look for SQL or
programs that can be tuned. And if that doesn't work, you have the facts to
convince management that they need to purchase more hardware. And if you can
warn them ahead of time, they might not be so grumpy. Yeah, sure.



Dennis Williams


DBA



Lifetouch, Inc.


dwilliams_at_lifetouch.com 


I said it "looked" clear - Riddick




-----Original Message-----


From: oracle-l-bounce_at_freelists.org


[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Patamalla, Chaya
Sent: Tuesday, June 29, 2004 4:59 PM


To: oracle-l_at_freelists.org


Subject: Double database load.




One of my application said that the load on the database will double in =
the month of September.  They will be rolling out the app. to lot more =
people.


What are the precautions I need to take besides space?
How do I know if the SGA is enough?  It is a datawarehouse.
Any suggestions are appreciated.



Thanks




Chaya Patamalla=20


I/T Database Administrator=20


=A0=A0=A0=A0=20


--"The opinions expressed herein are solely the author's and are not =
necessarily the opinion of USAA."=A0--=A0=A0=A0=A0=A0=A0=A0=A0=A0=20




-----Original Message-----


From: oracle-l-bounce_at_freelists.org =


[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of LeRoy Kemnitz
Sent: Tuesday, June 29, 2004 4:26 PM


To: oracle-l_at_freelists.org


Subject: Re: Slow performance/response



Do over....I will paste it here.  Is there an editor to read this =
output??





=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
PARSING IN CURSOR #1 len=3D136 dep=3D0 uid=3D151 oct=3D3 lid=3D151=20
tim=3D1063030977846699 hv=3D3920541172 ad=3D'34ca93f8'
SELECT OWNER, TABLE_NAME, TABLE_TYPE FROM SYS.ALL_CATALOG WHERE=20

TABLE_TYPE IN ('TABLE','VIEW')AND OWNER =3D 'UWSA' AND TABLE_NAME =3D =

'DUAL'



END OF STMT



PARSE=20



#1:c=3D10000,e=3D5487,p=3D0,cr=3D5,cu=3D0,mis=3D1,r=3D0,dep=3D0,og=3D4,ti=
m=3D1063030977846695


BINDS #1:



EXEC =



#1:c=3D0,e=3D59,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D0,og=3D4,tim=3D10=
63030977846869


WAIT #1: nam=3D'SQL*Net message to client' ela=3D 3 p1=3D1413697536 =
p2=3D1 p3=3D0


FETCH =



#1:c=3D0,e=3D101,p=3D0,cr=3D5,cu=3D0,mis=3D0,r=3D0,dep=3D0,og=3D4,tim=3D1=
063030977847026


WAIT #1: nam=3D'SQL*Net message from client' ela=3D 1495 p1=3D1413697536 =
p2=3D1 p3=3D0


STAT #1 id=3D1 cnt=3D0 pid=3D0 pos=3D1 obj=3D0 op=3D'FILTER  (cr=3D5 =
r=3D0 w=3D0 time=3D97 us)'


STAT #1 id=3D2 cnt=3D0 pid=3D1 pos=3D1 obj=3D0 op=3D'NESTED LOOPS  =


(cr=3D5 r=3D0 w=3D0=20



time=3D96 us)'


STAT #1 id=3D3 cnt=3D1 pid=3D2 pos=3D1 obj=3D22 op=3D'TABLE ACCESS BY =
INDEX ROWID=20



USER$ (cr=3D2 r=3D0 w=3D0 time=3D32 us)'
STAT #1 id=3D4 cnt=3D1 pid=3D3 pos=3D1 obj=3D41 op=3D'INDEX UNIQUE SCAN =
I_USER1=20



(cr=3D1 r=3D0 w=3D0 time=3D18 us)'



STAT #1 id=3D5 cnt=3D0 pid=3D2 pos=3D2 obj=3D18 op=3D'TABLE ACCESS BY =
INDEX ROWID=20



OBJ$ (cr=3D3 r=3D0 w=3D0 time=3D54 us)'


STAT #1 id=3D6 cnt=3D1 pid=3D5 pos=3D1 obj=3D34 op=3D'INDEX RANGE SCAN =
I_OBJ2 (cr=3D2=20


r=3D0 w=3D0 time=3D34 us)'


STAT #1 id=3D7 cnt=3D0 pid=3D1 pos=3D2 obj=3D4 op=3D'TABLE ACCESS =
CLUSTER TAB$ (cr=3D0=20


r=3D0 w=3D0 time=3D0 us)'


STAT #1 id=3D8 cnt=3D0 pid=3D7 pos=3D1 obj=3D3 op=3D'INDEX UNIQUE SCAN =
I_OBJ# (cr=3D0=20


r=3D0 w=3D0 time=3D0 us)'


STAT #1 id=3D9 cnt=3D0 pid=3D1 pos=3D2 obj=3D0 op=3D'NESTED LOOPS  =


(cr=3D0 r=3D0 w=3D0=20



time=3D0 us)'


STAT #1 id=3D10 cnt=3D0 pid=3D9 pos=3D1 obj=3D309 op=3D'FIXED TABLE FULL =
X$KZSRO=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D11 cnt=3D0 pid=3D9 pos=3D2 obj=3D101 op=3D'INDEX RANGE SCAN =
I_OBJAUTH2=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D12 cnt=3D0 pid=3D1 pos=3D2 obj=3D310 op=3D'FIXED TABLE FULL =
X$KZSPR=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D13 cnt=3D0 pid=3D1 pos=3D2 obj=3D310 op=3D'FIXED TABLE FULL =
X$KZSPR=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
PARSING IN CURSOR #2 len=3D37 dep=3D1 uid=3D0 oct=3D3 lid=3D0 =
tim=3D1063030977849341=20


hv=3D3468666020 ad=3D'31d96568'


select text from view$ where rowid=3D:1


END OF STMT



PARSE =



#2:c=3D0,e=3D35,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D1,og=3D4,tim=3D10=
63030977849338


BINDS #2:



  bind 0: dty=3D11 mxl=3D16(16) mal=3D00 scl=3D00 pre=3D00 oacflg=3D18 =
oacfl2=3D1=20


size=3D16 offset=3D0


    bfp=3D1102c5310 bln=3D16 avl=3D16 flg=3D05
    value=3D000003BC.0008.0001


EXEC =



#2:c=3D0,e=3D74,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D1,og=3D4,tim=3D10=
63030977849501


FETCH =



#2:c=3D0,e=3D33,p=3D0,cr=3D2,cu=3D0,mis=3D0,r=3D1,dep=3D1,og=3D4,tim=3D10=
63030977849555


STAT #2 id=3D1 cnt=3D1 pid=3D0 pos=3D1 obj=3D59 op=3D'TABLE ACCESS BY =
USER ROWID=20



VIEW$ (cr=3D1 r=3D0 w=3D0 time=3D18 us)'
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
PARSING IN CURSOR #1 len=3D95 dep=3D0 uid=3D151 oct=3D3 lid=3D151=20
tim=3D1063030977852094 hv=3D1399578166 ad=3D'34c87648'
SELECT OWNER, SYNONYM_NAME FROM SYS.ALL_SYNONYMS WHERE OWNER =3D 'UWSA'=20

AND SYNONYM_NAME =3D 'DUAL'



END OF STMT



PARSE =



#1:c=3D0,e=3D3110,p=3D0,cr=3D2,cu=3D0,mis=3D1,r=3D0,dep=3D0,og=3D4,tim=3D=
1063030977852090


BINDS #1:



EXEC =



#1:c=3D0,e=3D62,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D0,og=3D4,tim=3D10=
63030977852229


WAIT #1: nam=3D'SQL*Net message to client' ela=3D 2 p1=3D1413697536 =
p2=3D1 p3=3D0


FETCH =



#1:c=3D0,e=3D78,p=3D0,cr=3D5,cu=3D0,mis=3D0,r=3D0,dep=3D0,og=3D4,tim=3D10=
63030977852357


WAIT #1: nam=3D'SQL*Net message from client' ela=3D 2958 p1=3D1413697536 =
p2=3D1 p3=3D0


STAT #1 id=3D1 cnt=3D0 pid=3D0 pos=3D1 obj=3D0 op=3D'FILTER  (cr=3D5 =
r=3D0 w=3D0 time=3D74 us)'


STAT #1 id=3D2 cnt=3D0 pid=3D1 pos=3D1 obj=3D0 op=3D'NESTED LOOPS  =


(cr=3D5 r=3D0 w=3D0=20



time=3D74 us)'


STAT #1 id=3D3 cnt=3D0 pid=3D2 pos=3D1 obj=3D0 op=3D'NESTED LOOPS  =


(cr=3D5 r=3D0 w=3D0=20



time=3D73 us)'


STAT #1 id=3D4 cnt=3D1 pid=3D3 pos=3D1 obj=3D22 op=3D'TABLE ACCESS BY =
INDEX ROWID=20



USER$ (cr=3D2 r=3D0 w=3D0 time=3D29 us)'
STAT #1 id=3D5 cnt=3D1 pid=3D4 pos=3D1 obj=3D41 op=3D'INDEX UNIQUE SCAN =
I_USER1=20



(cr=3D1 r=3D0 w=3D0 time=3D17 us)'



STAT #1 id=3D6 cnt=3D0 pid=3D3 pos=3D2 obj=3D18 op=3D'TABLE ACCESS BY =
INDEX ROWID=20



OBJ$ (cr=3D3 r=3D0 w=3D0 time=3D34 us)'


STAT #1 id=3D7 cnt=3D1 pid=3D6 pos=3D1 obj=3D34 op=3D'INDEX RANGE SCAN =
I_OBJ2 (cr=3D2=20


r=3D0 w=3D0 time=3D22 us)'


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
PARSING IN CURSOR #2 len=3D116 dep=3D1 uid=3D0 oct=3D3 lid=3D0=20
tim=3D1063030977855705 hv=3D431456802 ad=3D'31f5d468'
select=20


o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.dataobj#=
,o.flags=20


from obj$ o where o.obj#=3D:1


END OF STMT



PARSE =



#2:c=3D0,e=3D51,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D1,og=3D4,tim=3D10=
63030977855703


BINDS #2:



  bind 0: dty=3D2 mxl=3D22(22) mal=3D00 scl=3D00 pre=3D00 oacflg=3D08 =
oacfl2=3D1=20


size=3D24 offset=3D0


    bfp=3D1102dd568 bln=3D22 avl=3D02 flg=3D05
    value=3D58


EXEC =



#2:c=3D0,e=3D109,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D1,og=3D4,tim=3D1=
063030977855944


FETCH =



#2:c=3D0,e=3D36,p=3D0,cr=3D3,cu=3D0,mis=3D0,r=3D1,dep=3D1,og=3D4,tim=3D10=
63030977856003


STAT #1 id=3D8 cnt=3D0 pid=3D2 pos=3D2 obj=3D58 op=3D'TABLE ACCESS BY =
INDEX ROWID=20



SYN$ (cr=3D0 r=3D0 w=3D0 time=3D0 us)'


STAT #1 id=3D9 cnt=3D0 pid=3D8 pos=3D1 obj=3D98 op=3D'INDEX UNIQUE SCAN =
I_SYN1 (cr=3D0=20


r=3D0 w=3D0 time=3D0 us)'


STAT #1 id=3D10 cnt=3D0 pid=3D1 pos=3D2 obj=3D0 op=3D'FILTER  (cr=3D0 =
r=3D0 w=3D0 time=3D0 us)'


STAT #1 id=3D11 cnt=3D0 pid=3D10 pos=3D1 obj=3D0 op=3D'NESTED LOOPS  =


(cr=3D0 r=3D0 w=3D0=20



time=3D0 us)'


STAT #1 id=3D12 cnt=3D0 pid=3D11 pos=3D1 obj=3D0 op=3D'NESTED LOOPS  =


(cr=3D0 r=3D0 w=3D0=20



time=3D0 us)'


STAT #1 id=3D13 cnt=3D0 pid=3D12 pos=3D1 obj=3D22 op=3D'TABLE ACCESS BY =
INDEX ROWID=20



USER$ (cr=3D0 r=3D0 w=3D0 time=3D0 us)'


STAT #1 id=3D14 cnt=3D0 pid=3D13 pos=3D1 obj=3D41 op=3D'INDEX UNIQUE =
SCAN I_USER1=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D15 cnt=3D0 pid=3D12 pos=3D2 obj=3D18 op=3D'TABLE ACCESS BY =
INDEX ROWID=20



OBJ$ (cr=3D0 r=3D0 w=3D0 time=3D0 us)'


STAT #1 id=3D16 cnt=3D0 pid=3D15 pos=3D1 obj=3D34 op=3D'INDEX RANGE SCAN =
I_OBJ2=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D17 cnt=3D0 pid=3D11 pos=3D2 obj=3D100 op=3D'INDEX RANGE =
SCAN I_OBJAUTH1=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D18 cnt=3D0 pid=3D10 pos=3D2 obj=3D309 op=3D'FIXED TABLE =
FULL X$KZSRO=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D19 cnt=3D0 pid=3D1 pos=3D2 obj=3D310 op=3D'FIXED TABLE FULL =
X$KZSPR=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
PARSING IN CURSOR #3 len=3D37 dep=3D1 uid=3D0 oct=3D3 lid=3D0 =
tim=3D1063030977856645=20


hv=3D3468666020 ad=3D'31d96568'


select text from view$ where rowid=3D:1


END OF STMT



PARSE =



#3:c=3D0,e=3D30,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D1,og=3D4,tim=3D10=
63030977856643


BINDS #3:



  bind 0: dty=3D11 mxl=3D16(16) mal=3D00 scl=3D00 pre=3D00 oacflg=3D18 =
oacfl2=3D1=20


size=3D16 offset=3D0


    bfp=3D1102c5290 bln=3D16 avl=3D16 flg=3D05
    value=3D000003BC.0008.0001


EXEC =



#3:c=3D0,e=3D65,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D1,og=3D4,tim=3D10=
63030977856788


FETCH =



#3:c=3D0,e=3D28,p=3D0,cr=3D2,cu=3D0,mis=3D0,r=3D1,dep=3D1,og=3D4,tim=3D10=
63030977856837


STAT #3 id=3D1 cnt=3D1 pid=3D0 pos=3D1 obj=3D59 op=3D'TABLE ACCESS BY =
USER ROWID=20



VIEW$ (cr=3D1 r=3D0 w=3D0 time=3D16 us)'
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
PARSING IN CURSOR #1 len=3D97 dep=3D0 uid=3D151 oct=3D3 lid=3D151=20
tim=3D1063030977859357 hv=3D2433821915 ad=3D'34c6cf48'
SELECT OWNER, SYNONYM_NAME FROM SYS.ALL_SYNONYMS WHERE OWNER =3D =

'PUBLIC'=20



AND SYNONYM_NAME =3D 'DUAL'



END OF STMT



PARSE =



#1:c=3D0,e=3D3039,p=3D0,cr=3D2,cu=3D0,mis=3D1,r=3D0,dep=3D0,og=3D4,tim=3D=
1063030977859353


BINDS #1:



EXEC =



#1:c=3D0,e=3D56,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D0,og=3D4,tim=3D10=
63030977859483


WAIT #1: nam=3D'SQL*Net message to client' ela=3D 2 p1=3D1413697536 =
p2=3D1 p3=3D0


FETCH =



#1:c=3D0,e=3D114,p=3D0,cr=3D8,cu=3D0,mis=3D0,r=3D1,dep=3D0,og=3D4,tim=3D1=
063030977859647


WAIT #1: nam=3D'SQL*Net message from client' ela=3D 1163 p1=3D1413697536 =
p2=3D1 p3=3D0


FETCH =



#1:c=3D0,e=3D23,p=3D0,cr=3D1,cu=3D0,mis=3D0,r=3D0,dep=3D0,og=3D4,tim=3D10=
63030977860931


WAIT #1: nam=3D'SQL*Net message to client' ela=3D 0 p1=3D1413697536 =
p2=3D1 p3=3D0


WAIT #1: nam=3D'SQL*Net message from client' ela=3D 1243 p1=3D1413697536 =
p2=3D1 p3=3D0


STAT #1 id=3D1 cnt=3D1 pid=3D0 pos=3D1 obj=3D0 op=3D'FILTER  (cr=3D9 =
r=3D0 w=3D0 time=3D122 us)'


STAT #1 id=3D2 cnt=3D1 pid=3D1 pos=3D1 obj=3D0 op=3D'NESTED LOOPS  =


(cr=3D9 r=3D0 w=3D0=20



time=3D115 us)'


STAT #1 id=3D3 cnt=3D1 pid=3D2 pos=3D1 obj=3D0 op=3D'NESTED LOOPS  =


(cr=3D6 r=3D0 w=3D0=20



time=3D86 us)'


STAT #1 id=3D4 cnt=3D1 pid=3D3 pos=3D1 obj=3D22 op=3D'TABLE ACCESS BY =
INDEX ROWID=20



USER$ (cr=3D2 r=3D0 w=3D0 time=3D32 us)'
STAT #1 id=3D5 cnt=3D1 pid=3D4 pos=3D1 obj=3D41 op=3D'INDEX UNIQUE SCAN =
I_USER1=20



(cr=3D1 r=3D0 w=3D0 time=3D17 us)'



STAT #1 id=3D6 cnt=3D1 pid=3D3 pos=3D2 obj=3D18 op=3D'TABLE ACCESS BY =
INDEX ROWID=20



OBJ$ (cr=3D4 r=3D0 w=3D0 time=3D46 us)'


STAT #1 id=3D7 cnt=3D1 pid=3D6 pos=3D1 obj=3D34 op=3D'INDEX RANGE SCAN =
I_OBJ2 (cr=3D3=20


r=3D0 w=3D0 time=3D32 us)'


STAT #1 id=3D8 cnt=3D1 pid=3D2 pos=3D2 obj=3D58 op=3D'TABLE ACCESS BY =
INDEX ROWID=20



SYN$ (cr=3D3 r=3D0 w=3D0 time=3D24 us)'


STAT #1 id=3D9 cnt=3D1 pid=3D8 pos=3D1 obj=3D98 op=3D'INDEX UNIQUE SCAN =
I_SYN1 (cr=3D2=20


r=3D0 w=3D0 time=3D13 us)'


STAT #1 id=3D10 cnt=3D0 pid=3D1 pos=3D2 obj=3D0 op=3D'FILTER  (cr=3D0 =
r=3D0 w=3D0 time=3D0 us)'


STAT #1 id=3D11 cnt=3D0 pid=3D10 pos=3D1 obj=3D0 op=3D'NESTED LOOPS  =


(cr=3D0 r=3D0 w=3D0=20



time=3D0 us)'


STAT #1 id=3D12 cnt=3D0 pid=3D11 pos=3D1 obj=3D0 op=3D'NESTED LOOPS  =


(cr=3D0 r=3D0 w=3D0=20



time=3D0 us)'


STAT #1 id=3D13 cnt=3D0 pid=3D12 pos=3D1 obj=3D22 op=3D'TABLE ACCESS BY =
INDEX ROWID=20



USER$ (cr=3D0 r=3D0 w=3D0 time=3D0 us)'


STAT #1 id=3D14 cnt=3D0 pid=3D13 pos=3D1 obj=3D41 op=3D'INDEX UNIQUE =
SCAN I_USER1=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D15 cnt=3D0 pid=3D12 pos=3D2 obj=3D18 op=3D'TABLE ACCESS BY =
INDEX ROWID=20



OBJ$ (cr=3D0 r=3D0 w=3D0 time=3D0 us)'


STAT #1 id=3D16 cnt=3D0 pid=3D15 pos=3D1 obj=3D34 op=3D'INDEX RANGE SCAN =
I_OBJ2=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D17 cnt=3D0 pid=3D11 pos=3D2 obj=3D100 op=3D'INDEX RANGE =
SCAN I_OBJAUTH1=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D18 cnt=3D0 pid=3D10 pos=3D2 obj=3D309 op=3D'FIXED TABLE =
FULL X$KZSRO=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D19 cnt=3D0 pid=3D1 pos=3D2 obj=3D310 op=3D'FIXED TABLE FULL =
X$KZSPR=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
PARSING IN CURSOR #1 len=3D276 dep=3D0 uid=3D151 oct=3D3 lid=3D151=20
tim=3D1063030977863756 hv=3D2671731006 ad=3D'34c53228'
SELECT=20



PBD_FHGT,PBD_FWGT,PBD_FITL,PBD_FUNL,PBD_FCHR,PBD_FPTC,PBD_FFCE,PBH_FHGT,P=

BH_FWGT,PBH_FITL,PBH_FUNL,PBH_FCHR,PBH_FPTC,PBH_FFCE,PBL_FHGT,PBL_FWGT,PB=

L_FITL,PBL_FUNL,PBL_FCHR,PBL_FPTC,PBL_FFCE,PBT_CMNT=20

  FROM SYSTEM.PBCATTBL   WHERE PBT_OWNR =3D 'PUBLIC' AND PBT_TNAM =3D =

'DUAL'



END OF STMT



PARSE =



#1:c=3D0,e=3D892,p=3D0,cr=3D0,cu=3D0,mis=3D1,r=3D0,dep=3D0,og=3D4,tim=3D1=
063030977863753


BINDS #1:



EXEC =



#1:c=3D0,e=3D46,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D0,og=3D4,tim=3D10=
63030977863889


WAIT #1: nam=3D'SQL*Net message to client' ela=3D 2 p1=3D1413697536 =
p2=3D1 p3=3D0


FETCH =



#1:c=3D0,e=3D19,p=3D0,cr=3D1,cu=3D0,mis=3D0,r=3D0,dep=3D0,og=3D4,tim=3D10=
63030977864026


WAIT #1: nam=3D'SQL*Net message from client' ela=3D 1959 p1=3D1413697536 =
p2=3D1 p3=3D0


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
PARSING IN CURSOR #2 len=3D116 dep=3D1 uid=3D0 oct=3D3 lid=3D0=20
tim=3D1063030977866197 hv=3D431456802 ad=3D'31f5d468'
select=20


o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.dataobj#=
,o.flags=20


from obj$ o where o.obj#=3D:1


END OF STMT



PARSE =



#2:c=3D0,e=3D50,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D1,og=3D4,tim=3D10=
63030977866194


BINDS #2:



  bind 0: dty=3D2 mxl=3D22(22) mal=3D00 scl=3D00 pre=3D00 oacflg=3D08 =
oacfl2=3D1=20


size=3D24 offset=3D0


    bfp=3D1102c5288 bln=3D22 avl=3D04 flg=3D05
    value=3D36257


EXEC =



#2:c=3D0,e=3D78,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D1,og=3D4,tim=3D10=
63030977866407


FETCH =



#2:c=3D0,e=3D41,p=3D0,cr=3D3,cu=3D0,mis=3D0,r=3D1,dep=3D1,og=3D4,tim=3D10=
63030977866470


STAT #1 id=3D1 cnt=3D0 pid=3D0 pos=3D1 obj=3D36257 op=3D'TABLE ACCESS BY =
INDEX ROWID=20



PBCATTBL (cr=3D1 r=3D0 w=3D0 time=3D14 us)'
STAT #1 id=3D2 cnt=3D0 pid=3D1 pos=3D1 obj=3D36258 op=3D'INDEX UNIQUE =
SCAN=20



PBSYSCATPBT_IDX (cr=3D1 r=3D0 w=3D0 time=3D11 us)'
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
PARSING IN CURSOR #3 len=3D37 dep=3D1 uid=3D0 oct=3D3 lid=3D0 =
tim=3D1063030977866990=20


hv=3D3468666020 ad=3D'31d96568'


select text from view$ where rowid=3D:1


END OF STMT



PARSE =



#3:c=3D0,e=3D32,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D1,og=3D4,tim=3D10=
63030977866987


BINDS #3:



  bind 0: dty=3D11 mxl=3D16(16) mal=3D00 scl=3D00 pre=3D00 oacflg=3D18 =
oacfl2=3D1=20


size=3D16 offset=3D0


    bfp=3D1102dd610 bln=3D16 avl=3D16 flg=3D05
    value=3D000003F8.0003.0001


EXEC =



#3:c=3D0,e=3D63,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D1,og=3D4,tim=3D10=
63030977867130


FETCH =



#3:c=3D0,e=3D30,p=3D0,cr=3D2,cu=3D0,mis=3D0,r=3D1,dep=3D1,og=3D4,tim=3D10=
63030977867181


STAT #3 id=3D1 cnt=3D1 pid=3D0 pos=3D1 obj=3D59 op=3D'TABLE ACCESS BY =
USER ROWID=20



VIEW$ (cr=3D1 r=3D0 w=3D0 time=3D17 us)'
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
PARSING IN CURSOR #3 len=3D37 dep=3D1 uid=3D0 oct=3D3 lid=3D0 =
tim=3D1063030977867568=20


hv=3D3468666020 ad=3D'31d96568'


select text from view$ where rowid=3D:1


END OF STMT



PARSE =



#3:c=3D0,e=3D25,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D1,og=3D4,tim=3D10=
63030977867565


BINDS #3:



  bind 0: dty=3D11 mxl=3D16(16) mal=3D00 scl=3D00 pre=3D00 oacflg=3D18 =
oacfl2=3D1=20


size=3D16 offset=3D0


    bfp=3D1102dd480 bln=3D16 avl=3D16 flg=3D05
    value=3D000035A9.0006.0001


EXEC =



#3:c=3D0,e=3D59,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D1,og=3D4,tim=3D10=
63030977867700


FETCH =



#3:c=3D0,e=3D25,p=3D0,cr=3D2,cu=3D0,mis=3D0,r=3D1,dep=3D1,og=3D4,tim=3D10=
63030977867745


STAT #3 id=3D1 cnt=3D1 pid=3D0 pos=3D1 obj=3D59 op=3D'TABLE ACCESS BY =
USER ROWID=20



VIEW$ (cr=3D1 r=3D0 w=3D0 time=3D11 us)'
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
PARSING IN CURSOR #1 len=3D235 dep=3D0 uid=3D151 oct=3D3 lid=3D151=20
tim=3D1063030977874810 hv=3D3378243952 ad=3D'34c4c178'
SELECT COLUMN_NAME, COLUMN_ID, DATA_TYPE_OWNER, DATA_TYPE, DATA_LENGTH,=20

CHAR_COL_DECL_LENGTH, DATA_PRECISION, DATA_SCALE, NULLABLE, DATA_DEFAULT =


FROM SYS.ALL_TAB_COLUMNS WHERE TABLE_NAME =3D 'DUAL' AND OWNER =3D =

'PUBLIC'=20



ORDER BY COLUMN_ID



END OF STMT



PARSE =



#1:c=3D0,e=3D8234,p=3D0,cr=3D4,cu=3D0,mis=3D1,r=3D0,dep=3D0,og=3D4,tim=3D=
1063030977874806


BINDS #1:



EXEC =



#1:c=3D0,e=3D244,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D0,og=3D4,tim=3D1=
063030977875160


WAIT #1: nam=3D'SQL*Net message to client' ela=3D 3 p1=3D1413697536 =
p2=3D1 p3=3D0


WAIT #1: nam=3D'SQL*Net message from client' ela=3D 1279 p1=3D1413697536 =
p2=3D1 p3=3D0


FETCH =



#1:c=3D0,e=3D125,p=3D0,cr=3D7,cu=3D0,mis=3D0,r=3D0,dep=3D0,og=3D4,tim=3D1=
063030977876763


WAIT #1: nam=3D'SQL*Net message to client' ela=3D 1 p1=3D1413697536 =
p2=3D1 p3=3D0


WAIT #1: nam=3D'SQL*Net message from client' ela=3D 1366 p1=3D1413697536 =
p2=3D1 p3=3D0


STAT #1 id=3D16 cnt=3D0 pid=3D0 pos=3D1 obj=3D0 op=3D'SORT ORDER BY =


(cr=3D7 r=3D0 w=3D0=20



time=3D115 us)'


STAT #1 id=3D17 cnt=3D0 pid=3D16 pos=3D1 obj=3D0 op=3D'FILTER  (cr=3D7 =
r=3D0 w=3D0 time=3D96=20


us)'


STAT #1 id=3D18 cnt=3D0 pid=3D17 pos=3D1 obj=3D0 op=3D'NESTED LOOPS =
OUTER (cr=3D7 r=3D0=20


w=3D0 time=3D95 us)'


STAT #1 id=3D19 cnt=3D0 pid=3D18 pos=3D1 obj=3D0 op=3D'NESTED LOOPS =
OUTER (cr=3D7 r=3D0=20


w=3D0 time=3D93 us)'


STAT #1 id=3D20 cnt=3D0 pid=3D19 pos=3D1 obj=3D0 op=3D'NESTED LOOPS =
OUTER (cr=3D7 r=3D0=20


w=3D0 time=3D92 us)'


STAT #1 id=3D21 cnt=3D0 pid=3D20 pos=3D1 obj=3D0 op=3D'NESTED LOOPS =
OUTER (cr=3D7 r=3D0=20


w=3D0 time=3D92 us)'


STAT #1 id=3D22 cnt=3D0 pid=3D21 pos=3D1 obj=3D0 op=3D'NESTED LOOPS  =


(cr=3D7 r=3D0 w=3D0=20



time=3D90 us)'


STAT #1 id=3D23 cnt=3D1 pid=3D22 pos=3D1 obj=3D0 op=3D'NESTED LOOPS  =


(cr=3D5 r=3D0 w=3D0=20



time=3D69 us)'


STAT #1 id=3D24 cnt=3D1 pid=3D23 pos=3D1 obj=3D22 op=3D'TABLE ACCESS BY =
INDEX ROWID=20



USER$ (cr=3D2 r=3D0 w=3D0 time=3D28 us)'
STAT #1 id=3D25 cnt=3D1 pid=3D24 pos=3D1 obj=3D41 op=3D'INDEX UNIQUE =
SCAN I_USER1=20



(cr=3D1 r=3D0 w=3D0 time=3D13 us)'



STAT #1 id=3D26 cnt=3D1 pid=3D23 pos=3D2 obj=3D18 op=3D'TABLE ACCESS BY =
INDEX ROWID=20



OBJ$ (cr=3D3 r=3D0 w=3D0 time=3D31 us)'


STAT #1 id=3D27 cnt=3D1 pid=3D26 pos=3D1 obj=3D34 op=3D'INDEX RANGE SCAN =
I_OBJ2=20



(cr=3D2 r=3D0 w=3D0 time=3D21 us)'



STAT #1 id=3D28 cnt=3D0 pid=3D22 pos=3D2 obj=3D21 op=3D'TABLE ACCESS =
CLUSTER COL$=20



(cr=3D2 r=3D0 w=3D0 time=3D17 us)'



STAT #1 id=3D29 cnt=3D0 pid=3D28 pos=3D1 obj=3D3 op=3D'INDEX UNIQUE SCAN =
I_OBJ#=20



(cr=3D2 r=3D0 w=3D0 time=3D16 us)'



=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
PARSING IN CURSOR #2 len=3D116 dep=3D1 uid=3D0 oct=3D3 lid=3D0=20
tim=3D1063030977878681 hv=3D431456802 ad=3D'31f5d468'
select=20


o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.dataobj#=
,o.flags=20


from obj$ o where o.obj#=3D:1


END OF STMT



PARSE =



#2:c=3D0,e=3D56,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D1,og=3D4,tim=3D10=
63030977878679


BINDS #2:



  bind 0: dty=3D2 mxl=3D22(22) mal=3D00 scl=3D00 pre=3D00 oacflg=3D08 =
oacfl2=3D1=20


size=3D24 offset=3D0


    bfp=3D1102e47e8 bln=3D22 avl=3D03 flg=3D05
    value=3D241


EXEC =



#2:c=3D0,e=3D82,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D1,og=3D4,tim=3D10=
63030977878895


FETCH =



#2:c=3D0,e=3D37,p=3D0,cr=3D3,cu=3D0,mis=3D0,r=3D1,dep=3D1,og=3D4,tim=3D10=
63030977878953


STAT #1 id=3D30 cnt=3D0 pid=3D21 pos=3D2 obj=3D241 op=3D'TABLE ACCESS =
CLUSTER=20



COLTYPE$ (cr=3D0 r=3D0 w=3D0 time=3D0 us)'
STAT #1 id=3D31 cnt=3D0 pid=3D20 pos=3D2 obj=3D194 op=3D'INDEX RANGE =
SCAN=20



I_HH_OBJ#_INTCOL# (cr=3D0 r=3D0 w=3D0 time=3D0 us)'
STAT #1 id=3D32 cnt=3D0 pid=3D19 pos=3D2 obj=3D18 op=3D'TABLE ACCESS BY =
INDEX ROWID=20



OBJ$ (cr=3D0 r=3D0 w=3D0 time=3D0 us)'


STAT #1 id=3D33 cnt=3D0 pid=3D32 pos=3D1 obj=3D35 op=3D'INDEX RANGE SCAN =
I_OBJ3=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D34 cnt=3D0 pid=3D18 pos=3D2 obj=3D22 op=3D'TABLE ACCESS =
CLUSTER USER$=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D35 cnt=3D0 pid=3D34 pos=3D1 obj=3D11 op=3D'INDEX UNIQUE =
SCAN I_USER#=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D36 cnt=3D0 pid=3D17 pos=3D2 obj=3D4 op=3D'TABLE ACCESS =
CLUSTER TAB$=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D37 cnt=3D0 pid=3D36 pos=3D1 obj=3D3 op=3D'INDEX UNIQUE SCAN =
I_OBJ#=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D38 cnt=3D0 pid=3D17 pos=3D2 obj=3D0 op=3D'NESTED LOOPS  =


(cr=3D0 r=3D0 w=3D0=20



time=3D0 us)'


STAT #1 id=3D39 cnt=3D0 pid=3D38 pos=3D1 obj=3D309 op=3D'FIXED TABLE =
FULL X$KZSRO=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D40 cnt=3D0 pid=3D38 pos=3D2 obj=3D101 op=3D'INDEX RANGE =
SCAN I_OBJAUTH2=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D41 cnt=3D0 pid=3D17 pos=3D2 obj=3D310 op=3D'FIXED TABLE =
FULL X$KZSPR=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
PARSING IN CURSOR #3 len=3D43 dep=3D1 uid=3D0 oct=3D3 lid=3D0 =
tim=3D1063030977879826=20


hv=3D2455283208 ad=3D'31ee40e8'


select user#,type# from user$ where name=3D:1
END OF STMT



PARSE =



#3:c=3D0,e=3D354,p=3D0,cr=3D0,cu=3D0,mis=3D1,r=3D0,dep=3D1,og=3D0,tim=3D1=
063030977879823


BINDS #3:



  bind 0: dty=3D1 mxl=3D32(06) mal=3D00 scl=3D00 pre=3D00 oacflg=3D18 =
oacfl2=3D1=20


size=3D32 offset=3D0


    bfp=3D1102c52f0 bln=3D32 avl=3D06 flg=3D05
    value=3D"PUBLIC"


EXEC =



#3:c=3D0,e=3D317,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D1,og=3D4,tim=3D1=
063030977880240


FETCH =



#3:c=3D0,e=3D30,p=3D0,cr=3D2,cu=3D0,mis=3D0,r=3D1,dep=3D1,og=3D4,tim=3D10=
63030977880296


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
PARSING IN CURSOR #1 len=3D29 dep=3D0 uid=3D151 oct=3D3 lid=3D151=20
tim=3D1063030977880574 hv=3D3203262218 ad=3D'34c08508'
SELECT * FROM "PUBLIC"."DUAL"



END OF STMT



PARSE =



#1:c=3D0,e=3D1288,p=3D0,cr=3D2,cu=3D0,mis=3D1,r=3D0,dep=3D0,og=3D4,tim=3D=
1063030977880571


WAIT #1: nam=3D'SQL*Net message to client' ela=3D 3 p1=3D1413697536 =
p2=3D1 p3=3D0


WAIT #1: nam=3D'SQL*Net message from client' ela=3D 1516 p1=3D1413697536 =
p2=3D1 p3=3D0


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
PARSING IN CURSOR #1 len=3D71 dep=3D0 uid=3D151 oct=3D3 lid=3D151=20
tim=3D1063030977882758 hv=3D4167003566 ad=3D'31c38090'
SELECT PBV_NAME,PBV_VALD,PBV_TYPE,PBV_CNTR,PBV_MSG FROM SYSTEM.PBCATVLD

END OF STMT



PARSE =



#1:c=3D0,e=3D477,p=3D0,cr=3D0,cu=3D0,mis=3D1,r=3D0,dep=3D0,og=3D4,tim=3D1=
063030977882755


BINDS #1:



EXEC =



#1:c=3D0,e=3D35,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D0,og=3D4,tim=3D10=
63030977882860


WAIT #1: nam=3D'SQL*Net message to client' ela=3D 2 p1=3D1413697536 =
p2=3D1 p3=3D0


FETCH =



#1:c=3D0,e=3D59,p=3D0,cr=3D3,cu=3D0,mis=3D0,r=3D0,dep=3D0,og=3D4,tim=3D10=
63030977882974


WAIT #1: nam=3D'SQL*Net message from client' ela=3D 1653 p1=3D1413697536 =
p2=3D1 p3=3D0


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
PARSING IN CURSOR #2 len=3D116 dep=3D1 uid=3D0 oct=3D3 lid=3D0=20
tim=3D1063030977884826 hv=3D431456802 ad=3D'31f5d468'
select=20


o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.dataobj#=
,o.flags=20


from obj$ o where o.obj#=3D:1


END OF STMT



PARSE =



#2:c=3D0,e=3D46,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D1,og=3D4,tim=3D10=
63030977884823


BINDS #2:



  bind 0: dty=3D2 mxl=3D22(22) mal=3D00 scl=3D00 pre=3D00 oacflg=3D08 =
oacfl2=3D1=20


size=3D24 offset=3D0


    bfp=3D1102c5288 bln=3D22 avl=3D04 flg=3D05
    value=3D36263


EXEC =



#2:c=3D0,e=3D79,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D1,og=3D4,tim=3D10=
63030977885031


FETCH =



#2:c=3D0,e=3D38,p=3D0,cr=3D3,cu=3D0,mis=3D0,r=3D1,dep=3D1,og=3D4,tim=3D10=
63030977885090


STAT #1 id=3D1 cnt=3D0 pid=3D0 pos=3D1 obj=3D36263 op=3D'TABLE ACCESS =
FULL PBCATVLD=20



(cr=3D3 r=3D0 w=3D0 time=3D56 us)'



=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
PARSING IN CURSOR #1 len=3D63 dep=3D0 uid=3D151 oct=3D3 lid=3D151=20
tim=3D1063030977885676 hv=3D1175394665 ad=3D'31c351f0'
SELECT PBF_NAME,PBF_FRMT,PBF_TYPE,PBF_CNTR FROM SYSTEM.PBCATFMT

END OF STMT



PARSE =



#1:c=3D0,e=3D505,p=3D0,cr=3D0,cu=3D0,mis=3D1,r=3D0,dep=3D0,og=3D4,tim=3D1=
063030977885672


BINDS #1:



EXEC =



#1:c=3D0,e=3D28,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D0,og=3D4,tim=3D10=
63030977885769


WAIT #1: nam=3D'SQL*Net message to client' ela=3D 2 p1=3D1413697536 =
p2=3D1 p3=3D0


FETCH =



#1:c=3D0,e=3D55,p=3D0,cr=3D3,cu=3D0,mis=3D0,r=3D1,dep=3D0,og=3D4,tim=3D10=
63030977885878


WAIT #1: nam=3D'SQL*Net message from client' ela=3D 1272 p1=3D1413697536 =
p2=3D1 p3=3D0


WAIT #1: nam=3D'SQL*Net message to client' ela=3D 0 p1=3D1413697536 =
p2=3D1 p3=3D0


FETCH =



#1:c=3D0,e=3D77,p=3D0,cr=3D1,cu=3D0,mis=3D0,r=3D19,dep=3D0,og=3D4,tim=3D1=
063030977887302


WAIT #1: nam=3D'SQL*Net message from client' ela=3D 2325 p1=3D1413697536 =
p2=3D1 p3=3D0


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
PARSING IN CURSOR #2 len=3D116 dep=3D1 uid=3D0 oct=3D3 lid=3D0=20
tim=3D1063030977889810 hv=3D431456802 ad=3D'31f5d468'
select=20


o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.dataobj#=
,o.flags=20


from obj$ o where o.obj#=3D:1


END OF STMT



PARSE =



#2:c=3D0,e=3D45,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D1,og=3D4,tim=3D10=
63030977889808


BINDS #2:



  bind 0: dty=3D2 mxl=3D22(22) mal=3D00 scl=3D00 pre=3D00 oacflg=3D08 =
oacfl2=3D1=20


size=3D24 offset=3D0


    bfp=3D1102e4a68 bln=3D22 avl=3D04 flg=3D05
    value=3D36261


EXEC =



#2:c=3D0,e=3D78,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D1,og=3D4,tim=3D10=
63030977890018


FETCH =



#2:c=3D0,e=3D36,p=3D0,cr=3D3,cu=3D0,mis=3D0,r=3D1,dep=3D1,og=3D4,tim=3D10=
63030977890076


STAT #1 id=3D1 cnt=3D20 pid=3D0 pos=3D1 obj=3D36261 op=3D'TABLE ACCESS =
FULL PBCATFMT=20



(cr=3D4 r=3D0 w=3D0 time=3D76 us)'



=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
PARSING IN CURSOR #1 len=3D117 dep=3D0 uid=3D151 oct=3D3 lid=3D151=20
tim=3D1063030977890750 hv=3D3941777003 ad=3D'31c5a970'
SELECT PBE_NAME,PBE_EDIT,PBE_TYPE,PBE_CNTR,PBE_WORK,PBE_SEQN,PBE_FLAG=20

FROM SYSTEM.PBCATEDT ORDER BY PBE_NAME,PBE_SEQN

END OF STMT



PARSE =



#1:c=3D0,e=3D593,p=3D0,cr=3D0,cu=3D0,mis=3D1,r=3D0,dep=3D0,og=3D4,tim=3D1=
063030977890746


BINDS #1:



EXEC =



#1:c=3D0,e=3D49,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D0,og=3D4,tim=3D10=
63030977890868


WAIT #1: nam=3D'SQL*Net message to client' ela=3D 3 p1=3D1413697536 =
p2=3D1 p3=3D0


FETCH =



#1:c=3D0,e=3D150,p=3D0,cr=3D3,cu=3D0,mis=3D0,r=3D1,dep=3D0,og=3D4,tim=3D1=
063030977891082


WAIT #1: nam=3D'SQL*Net message from client' ela=3D 1234 p1=3D1413697536 =
p2=3D1 p3=3D0


WAIT #1: nam=3D'SQL*Net message to client' ela=3D 1 p1=3D1413697536 =
p2=3D1 p3=3D0


FETCH =



#1:c=3D0,e=3D92,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D20,dep=3D0,og=3D4,tim=3D1=
063030977892486


WAIT #1: nam=3D'SQL*Net message from client' ela=3D 1906 p1=3D1413697536 =
p2=3D1 p3=3D0


STAT #1 id=3D1 cnt=3D21 pid=3D0 pos=3D1 obj=3D0 op=3D'SORT ORDER BY =


(cr=3D3 r=3D0 w=3D0=20



time=3D173 us)'


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
PARSING IN CURSOR #2 len=3D116 dep=3D1 uid=3D0 oct=3D3 lid=3D0=20
tim=3D1063030977894604 hv=3D431456802 ad=3D'31f5d468'
select=20


o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.dataobj#=
,o.flags=20


from obj$ o where o.obj#=3D:1


END OF STMT



PARSE =



#2:c=3D0,e=3D46,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D1,og=3D4,tim=3D10=
63030977894601


BINDS #2:



  bind 0: dty=3D2 mxl=3D22(22) mal=3D00 scl=3D00 pre=3D00 oacflg=3D08 =
oacfl2=3D1=20


size=3D24 offset=3D0


    bfp=3D1102e4950 bln=3D22 avl=3D04 flg=3D05
    value=3D36265


EXEC =



#2:c=3D0,e=3D82,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D1,og=3D4,tim=3D10=
63030977894844


FETCH =



#2:c=3D0,e=3D37,p=3D0,cr=3D3,cu=3D0,mis=3D0,r=3D1,dep=3D1,og=3D4,tim=3D10=
63030977894903


STAT #1 id=3D2 cnt=3D21 pid=3D1 pos=3D1 obj=3D36265 op=3D'TABLE ACCESS =
FULL PBCATEDT=20



(cr=3D3 r=3D0 w=3D0 time=3D56 us)'



=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
PARSING IN CURSOR #1 len=3D229 dep=3D0 uid=3D151 oct=3D3 lid=3D151=20
tim=3D1063030977895813 hv=3D2117949404 ad=3D'34bf5208'
SELECT=20



PBC_CNAM,PBC_TNAM,PBC_OWNR,PBC_LABL,PBC_LPOS,PBC_HDR,PBC_HPOS,PBC_JTFY,PB=

C_MASK,PBC_CASE,PBC_HGHT,PBC_WDTH,PBC_PTRN,PBC_BMAP,PBC_INIT,PBC_EDIT,PBC=

_CMNT=20



FROM SYSTEM.PBCATCOL WHERE  (PBC_TNAM  =3D 'DUAL' AND PBC_OWNR =3D =

'UWSA')



END OF STMT



PARSE =



#1:c=3D0,e=3D830,p=3D0,cr=3D0,cu=3D0,mis=3D1,r=3D0,dep=3D0,og=3D4,tim=3D1=
063030977895810


BINDS #1:



EXEC =



#1:c=3D0,e=3D45,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D0,og=3D4,tim=3D10=
63030977895937


WAIT #1: nam=3D'SQL*Net message to client' ela=3D 2 p1=3D1413697536 =
p2=3D1 p3=3D0


FETCH =



#1:c=3D0,e=3D27,p=3D0,cr=3D1,cu=3D0,mis=3D0,r=3D0,dep=3D0,og=3D4,tim=3D10=
63030977896063


WAIT #1: nam=3D'SQL*Net message from client' ela=3D 1806 p1=3D1413697536 =
p2=3D1 p3=3D0


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
PARSING IN CURSOR #2 len=3D116 dep=3D1 uid=3D0 oct=3D3 lid=3D0=20
tim=3D1063030977898067 hv=3D431456802 ad=3D'31f5d468'
select=20


o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.dataobj#=
,o.flags=20


from obj$ o where o.obj#=3D:1


END OF STMT



PARSE =



#2:c=3D0,e=3D46,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D1,og=3D4,tim=3D10=
63030977898065


BINDS #2:



  bind 0: dty=3D2 mxl=3D22(22) mal=3D00 scl=3D00 pre=3D00 oacflg=3D08 =
oacfl2=3D1=20


size=3D24 offset=3D0


    bfp=3D1102c5288 bln=3D22 avl=3D04 flg=3D05
    value=3D36259


EXEC =



#2:c=3D0,e=3D77,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D1,og=3D4,tim=3D10=
63030977898271


FETCH =



#2:c=3D0,e=3D34,p=3D0,cr=3D3,cu=3D0,mis=3D0,r=3D1,dep=3D1,og=3D4,tim=3D10=
63030977898326


STAT #1 id=3D1 cnt=3D0 pid=3D0 pos=3D1 obj=3D36259 op=3D'TABLE ACCESS BY =
INDEX ROWID=20



PBCATCOL (cr=3D1 r=3D0 w=3D0 time=3D22 us)'
STAT #1 id=3D2 cnt=3D0 pid=3D1 pos=3D1 obj=3D36260 op=3D'INDEX RANGE =
SCAN=20



PBSYSCATCOLDICT_IDX (cr=3D1 r=3D0 w=3D0 time=3D21 us)'
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
PARSING IN CURSOR #3 len=3D37 dep=3D1 uid=3D0 oct=3D3 lid=3D0 =
tim=3D1063030977898759=20


hv=3D3468666020 ad=3D'31d96568'


select text from view$ where rowid=3D:1


END OF STMT



PARSE =



#3:c=3D0,e=3D31,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D1,og=3D4,tim=3D10=
63030977898756


BINDS #3:



  bind 0: dty=3D11 mxl=3D16(16) mal=3D00 scl=3D00 pre=3D00 oacflg=3D18 =
oacfl2=3D1=20


size=3D16 offset=3D0


    bfp=3D1102f0168 bln=3D16 avl=3D16 flg=3D05
    value=3D000003B9.0005.0001


EXEC =



#3:c=3D0,e=3D63,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D1,og=3D4,tim=3D10=
63030977898899


FETCH =



#3:c=3D0,e=3D33,p=3D0,cr=3D2,cu=3D0,mis=3D0,r=3D1,dep=3D1,og=3D4,tim=3D10=
63030977898952


STAT #3 id=3D1 cnt=3D1 pid=3D0 pos=3D1 obj=3D59 op=3D'TABLE ACCESS BY =
USER ROWID=20



VIEW$ (cr=3D1 r=3D0 w=3D0 time=3D16 us)'
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
PARSING IN CURSOR #1 len=3D102 dep=3D0 uid=3D151 oct=3D3 lid=3D151=20
tim=3D1063030977904309 hv=3D1902070077 ad=3D'34bee638'
SELECT INDEX_NAME, UNIQUENESS FROM  SYS.ALL_INDEXES WHERE TABLE_OWNER =

=3D=20


'UWSA' AND TABLE_NAME =3D 'DUAL'



END OF STMT



PARSE=20



#1:c=3D10000,e=3D5879,p=3D0,cr=3D2,cu=3D0,mis=3D1,r=3D0,dep=3D0,og=3D4,ti=
m=3D1063030977904305


BINDS #1:



EXEC =



#1:c=3D0,e=3D74,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D0,og=3D4,tim=3D10=
63030977904456


WAIT #1: nam=3D'SQL*Net message to client' ela=3D 3 p1=3D1413697536 =
p2=3D1 p3=3D0


FETCH =



#1:c=3D0,e=3D84,p=3D0,cr=3D5,cu=3D0,mis=3D0,r=3D0,dep=3D0,og=3D4,tim=3D10=
63030977904591


WAIT #1: nam=3D'SQL*Net message from client' ela=3D 1779 p1=3D1413697536 =
p2=3D1 p3=3D0


STAT #1 id=3D1 cnt=3D0 pid=3D0 pos=3D1 obj=3D0 op=3D'FILTER  (cr=3D5 =
r=3D0 w=3D0 time=3D81 us)'


STAT #1 id=3D2 cnt=3D0 pid=3D1 pos=3D1 obj=3D0 op=3D'NESTED LOOPS OUTER =


(cr=3D5 r=3D0=20



w=3D0 time=3D79 us)'


STAT #1 id=3D3 cnt=3D0 pid=3D2 pos=3D1 obj=3D0 op=3D'NESTED LOOPS OUTER =


(cr=3D5 r=3D0=20



w=3D0 time=3D78 us)'


STAT #1 id=3D4 cnt=3D0 pid=3D3 pos=3D1 obj=3D0 op=3D'NESTED LOOPS  =


(cr=3D5 r=3D0 w=3D0=20



time=3D78 us)'


STAT #1 id=3D5 cnt=3D0 pid=3D4 pos=3D1 obj=3D0 op=3D'NESTED LOOPS OUTER =


(cr=3D5 r=3D0=20



w=3D0 time=3D77 us)'


STAT #1 id=3D6 cnt=3D0 pid=3D5 pos=3D1 obj=3D0 op=3D'NESTED LOOPS  =


(cr=3D5 r=3D0 w=3D0=20



time=3D76 us)'


STAT #1 id=3D7 cnt=3D0 pid=3D6 pos=3D1 obj=3D0 op=3D'NESTED LOOPS OUTER =


(cr=3D5 r=3D0=20



w=3D0 time=3D75 us)'


STAT #1 id=3D8 cnt=3D0 pid=3D7 pos=3D1 obj=3D0 op=3D'NESTED LOOPS  =


(cr=3D5 r=3D0 w=3D0=20



time=3D74 us)'


STAT #1 id=3D9 cnt=3D0 pid=3D8 pos=3D1 obj=3D0 op=3D'NESTED LOOPS  =


(cr=3D5 r=3D0 w=3D0=20



time=3D74 us)'


STAT #1 id=3D10 cnt=3D1 pid=3D9 pos=3D1 obj=3D22 op=3D'TABLE ACCESS BY =
INDEX ROWID=20



USER$ (cr=3D2 r=3D0 w=3D0 time=3D30 us)'
STAT #1 id=3D11 cnt=3D1 pid=3D10 pos=3D1 obj=3D41 op=3D'INDEX UNIQUE =
SCAN I_USER1=20



(cr=3D1 r=3D0 w=3D0 time=3D17 us)'



STAT #1 id=3D12 cnt=3D0 pid=3D9 pos=3D2 obj=3D18 op=3D'TABLE ACCESS BY =
INDEX ROWID=20



OBJ$ (cr=3D3 r=3D0 w=3D0 time=3D36 us)'


STAT #1 id=3D13 cnt=3D1 pid=3D12 pos=3D1 obj=3D34 op=3D'INDEX RANGE SCAN =
I_OBJ2=20



(cr=3D2 r=3D0 w=3D0 time=3D22 us)'



STAT #1 id=3D14 cnt=3D0 pid=3D8 pos=3D2 obj=3D19 op=3D'TABLE ACCESS =
CLUSTER IND$=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D15 cnt=3D0 pid=3D14 pos=3D1 obj=3D3 op=3D'INDEX UNIQUE SCAN =
I_OBJ#=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D16 cnt=3D0 pid=3D7 pos=3D2 obj=3D18 op=3D'TABLE ACCESS BY =
INDEX ROWID=20



OBJ$ (cr=3D0 r=3D0 w=3D0 time=3D0 us)'


STAT #1 id=3D17 cnt=3D0 pid=3D16 pos=3D1 obj=3D33 op=3D'INDEX UNIQUE =
SCAN I_OBJ1=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D18 cnt=3D0 pid=3D6 pos=3D2 obj=3D18 op=3D'TABLE ACCESS BY =
INDEX ROWID=20



OBJ$ (cr=3D0 r=3D0 w=3D0 time=3D0 us)'


STAT #1 id=3D19 cnt=3D0 pid=3D18 pos=3D1 obj=3D33 op=3D'INDEX UNIQUE =
SCAN I_OBJ1=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D20 cnt=3D0 pid=3D5 pos=3D2 obj=3D22 op=3D'TABLE ACCESS =
CLUSTER USER$=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D21 cnt=3D0 pid=3D20 pos=3D1 obj=3D11 op=3D'INDEX UNIQUE =
SCAN I_USER#=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D22 cnt=3D0 pid=3D4 pos=3D2 obj=3D22 op=3D'TABLE ACCESS =
CLUSTER USER$=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D23 cnt=3D0 pid=3D22 pos=3D1 obj=3D11 op=3D'INDEX UNIQUE =
SCAN I_USER#=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D24 cnt=3D0 pid=3D3 pos=3D2 obj=3D14 op=3D'TABLE ACCESS =
CLUSTER SEG$=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D25 cnt=3D0 pid=3D24 pos=3D1 obj=3D9 op=3D'INDEX UNIQUE SCAN =



I_FILE#_BLOCK# (cr=3D0 r=3D0 w=3D0 time=3D0 us)'
STAT #1 id=3D26 cnt=3D0 pid=3D2 pos=3D2 obj=3D16 op=3D'TABLE ACCESS =
CLUSTER TS$=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D27 cnt=3D0 pid=3D26 pos=3D1 obj=3D7 op=3D'INDEX UNIQUE SCAN =
I_TS# (cr=3D0=20


r=3D0 w=3D0 time=3D0 us)'


STAT #1 id=3D28 cnt=3D0 pid=3D1 pos=3D2 obj=3D0 op=3D'NESTED LOOPS  =


(cr=3D0 r=3D0 w=3D0=20



time=3D0 us)'


STAT #1 id=3D29 cnt=3D0 pid=3D28 pos=3D1 obj=3D309 op=3D'FIXED TABLE =
FULL X$KZSRO=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D30 cnt=3D0 pid=3D28 pos=3D2 obj=3D101 op=3D'INDEX RANGE =
SCAN I_OBJAUTH2=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D31 cnt=3D0 pid=3D1 pos=3D2 obj=3D310 op=3D'FIXED TABLE FULL =
X$KZSPR=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
PARSING IN CURSOR #2 len=3D37 dep=3D1 uid=3D0 oct=3D3 lid=3D0 =
tim=3D1063030977907704=20


hv=3D3468666020 ad=3D'31d96568'


select text from view$ where rowid=3D:1


END OF STMT



PARSE =



#2:c=3D0,e=3D39,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D1,og=3D4,tim=3D10=
63030977907702


BINDS #2:



  bind 0: dty=3D11 mxl=3D16(16) mal=3D00 scl=3D00 pre=3D00 oacflg=3D18 =
oacfl2=3D1=20


size=3D16 offset=3D0


    bfp=3D1102c5310 bln=3D16 avl=3D16 flg=3D05
    value=3D000003BC.0008.0001


EXEC =



#2:c=3D0,e=3D75,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D1,og=3D4,tim=3D10=
63030977907867


FETCH =



#2:c=3D0,e=3D33,p=3D0,cr=3D2,cu=3D0,mis=3D0,r=3D1,dep=3D1,og=3D4,tim=3D10=
63030977907922


STAT #2 id=3D1 cnt=3D1 pid=3D0 pos=3D1 obj=3D59 op=3D'TABLE ACCESS BY =
USER ROWID=20



VIEW$ (cr=3D1 r=3D0 w=3D0 time=3D18 us)'
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
PARSING IN CURSOR #1 len=3D137 dep=3D0 uid=3D151 oct=3D3 lid=3D151=20
tim=3D1063030977910581 hv=3D584147568 ad=3D'34bc9668'
SELECT TABLE_OWNER, TABLE_NAME FROM SYS.ALL_SYNONYMS WHERE OWNER =3D=20

'UWSA' AND SYNONYM_NAME =3D 'DUAL' AND (DB_LINK IS NULL OR DB_LINK =3D =

'')


END OF STMT



PARSE =



#1:c=3D0,e=3D3272,p=3D0,cr=3D2,cu=3D0,mis=3D1,r=3D0,dep=3D0,og=3D4,tim=3D=
1063030977910578


BINDS #1:



EXEC =



#1:c=3D0,e=3D60,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D0,og=3D4,tim=3D10=
63030977910714


WAIT #1: nam=3D'SQL*Net message to client' ela=3D 3 p1=3D1413697536 =
p2=3D1 p3=3D0


FETCH =



#1:c=3D0,e=3D76,p=3D0,cr=3D5,cu=3D0,mis=3D0,r=3D0,dep=3D0,og=3D4,tim=3D10=
63030977910841


WAIT #1: nam=3D'SQL*Net message from client' ela=3D 2395 p1=3D1413697536 =
p2=3D1 p3=3D0


STAT #1 id=3D1 cnt=3D0 pid=3D0 pos=3D1 obj=3D0 op=3D'FILTER  (cr=3D5 =
r=3D0 w=3D0 time=3D73 us)'


STAT #1 id=3D2 cnt=3D0 pid=3D1 pos=3D1 obj=3D0 op=3D'NESTED LOOPS  =


(cr=3D5 r=3D0 w=3D0=20



time=3D72 us)'


STAT #1 id=3D3 cnt=3D0 pid=3D2 pos=3D1 obj=3D0 op=3D'NESTED LOOPS  =


(cr=3D5 r=3D0 w=3D0=20



time=3D70 us)'


STAT #1 id=3D4 cnt=3D1 pid=3D3 pos=3D1 obj=3D22 op=3D'TABLE ACCESS BY =
INDEX ROWID=20



USER$ (cr=3D2 r=3D0 w=3D0 time=3D29 us)'
STAT #1 id=3D5 cnt=3D1 pid=3D4 pos=3D1 obj=3D41 op=3D'INDEX UNIQUE SCAN =
I_USER1=20



(cr=3D1 r=3D0 w=3D0 time=3D16 us)'



STAT #1 id=3D6 cnt=3D0 pid=3D3 pos=3D2 obj=3D18 op=3D'TABLE ACCESS BY =
INDEX ROWID=20



OBJ$ (cr=3D3 r=3D0 w=3D0 time=3D34 us)'


STAT #1 id=3D7 cnt=3D1 pid=3D6 pos=3D1 obj=3D34 op=3D'INDEX RANGE SCAN =
I_OBJ2 (cr=3D2=20


r=3D0 w=3D0 time=3D22 us)'


STAT #1 id=3D8 cnt=3D0 pid=3D2 pos=3D2 obj=3D58 op=3D'TABLE ACCESS BY =
INDEX ROWID=20



SYN$ (cr=3D0 r=3D0 w=3D0 time=3D0 us)'


STAT #1 id=3D9 cnt=3D0 pid=3D8 pos=3D1 obj=3D98 op=3D'INDEX UNIQUE SCAN =
I_SYN1 (cr=3D0=20


r=3D0 w=3D0 time=3D0 us)'


STAT #1 id=3D10 cnt=3D0 pid=3D1 pos=3D2 obj=3D0 op=3D'FILTER  (cr=3D0 =
r=3D0 w=3D0 time=3D0 us)'


STAT #1 id=3D11 cnt=3D0 pid=3D10 pos=3D1 obj=3D0 op=3D'NESTED LOOPS  =


(cr=3D0 r=3D0 w=3D0=20



time=3D0 us)'


STAT #1 id=3D12 cnt=3D0 pid=3D11 pos=3D1 obj=3D0 op=3D'NESTED LOOPS  =


(cr=3D0 r=3D0 w=3D0=20



time=3D0 us)'


STAT #1 id=3D13 cnt=3D0 pid=3D12 pos=3D1 obj=3D22 op=3D'TABLE ACCESS BY =
INDEX ROWID=20



USER$ (cr=3D0 r=3D0 w=3D0 time=3D0 us)'


STAT #1 id=3D14 cnt=3D0 pid=3D13 pos=3D1 obj=3D41 op=3D'INDEX UNIQUE =
SCAN I_USER1=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D15 cnt=3D0 pid=3D12 pos=3D2 obj=3D18 op=3D'TABLE ACCESS BY =
INDEX ROWID=20



OBJ$ (cr=3D0 r=3D0 w=3D0 time=3D0 us)'


STAT #1 id=3D16 cnt=3D0 pid=3D15 pos=3D1 obj=3D34 op=3D'INDEX RANGE SCAN =
I_OBJ2=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D17 cnt=3D0 pid=3D11 pos=3D2 obj=3D100 op=3D'INDEX RANGE =
SCAN I_OBJAUTH1=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D18 cnt=3D0 pid=3D10 pos=3D2 obj=3D309 op=3D'FIXED TABLE =
FULL X$KZSRO=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D19 cnt=3D0 pid=3D1 pos=3D2 obj=3D310 op=3D'FIXED TABLE FULL =
X$KZSPR=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
PARSING IN CURSOR #2 len=3D37 dep=3D1 uid=3D0 oct=3D3 lid=3D0 =
tim=3D1063030977914225=20


hv=3D3468666020 ad=3D'31d96568'


select text from view$ where rowid=3D:1


END OF STMT



PARSE =



#2:c=3D0,e=3D37,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D1,og=3D4,tim=3D10=
63030977914222


BINDS #2:



  bind 0: dty=3D11 mxl=3D16(16) mal=3D00 scl=3D00 pre=3D00 oacflg=3D18 =
oacfl2=3D1=20


size=3D16 offset=3D0


    bfp=3D1102c5310 bln=3D16 avl=3D16 flg=3D05
    value=3D000003BC.0008.0001


EXEC =



#2:c=3D0,e=3D75,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D1,og=3D4,tim=3D10=
63030977914387


FETCH =



#2:c=3D0,e=3D30,p=3D0,cr=3D2,cu=3D0,mis=3D0,r=3D1,dep=3D1,og=3D4,tim=3D10=
63030977914439


STAT #2 id=3D1 cnt=3D1 pid=3D0 pos=3D1 obj=3D59 op=3D'TABLE ACCESS BY =
USER ROWID=20



VIEW$ (cr=3D1 r=3D0 w=3D0 time=3D17 us)'
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
PARSING IN CURSOR #1 len=3D139 dep=3D0 uid=3D151 oct=3D3 lid=3D151=20
tim=3D1063030977917049 hv=3D3731089617 ad=3D'34bafce0'
SELECT TABLE_OWNER, TABLE_NAME FROM SYS.ALL_SYNONYMS WHERE OWNER =3D=20

'PUBLIC' AND SYNONYM_NAME =3D 'DUAL' AND (DB_LINK IS NULL OR DB_LINK =3D =

'')


END OF STMT



PARSE=20



#1:c=3D10000,e=3D3217,p=3D0,cr=3D2,cu=3D0,mis=3D1,r=3D0,dep=3D0,og=3D4,ti=
m=3D1063030977917045


BINDS #1:



EXEC =



#1:c=3D0,e=3D60,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D0,og=3D4,tim=3D10=
63030977917181


WAIT #1: nam=3D'SQL*Net message to client' ela=3D 3 p1=3D1413697536 =
p2=3D1 p3=3D0


FETCH =



#1:c=3D0,e=3D103,p=3D0,cr=3D8,cu=3D0,mis=3D0,r=3D1,dep=3D0,og=3D4,tim=3D1=
063030977917334


WAIT #1: nam=3D'SQL*Net message from client' ela=3D 1101 p1=3D1413697536 =
p2=3D1 p3=3D0


FETCH =



#1:c=3D0,e=3D20,p=3D0,cr=3D1,cu=3D0,mis=3D0,r=3D0,dep=3D0,og=3D4,tim=3D10=
63030977918551


WAIT #1: nam=3D'SQL*Net message to client' ela=3D 0 p1=3D1413697536 =
p2=3D1 p3=3D0


WAIT #1: nam=3D'SQL*Net message from client' ela=3D 1231 p1=3D1413697536 =
p2=3D1 p3=3D0


STAT #1 id=3D1 cnt=3D1 pid=3D0 pos=3D1 obj=3D0 op=3D'FILTER  (cr=3D9 =
r=3D0 w=3D0 time=3D109 us)'


STAT #1 id=3D2 cnt=3D1 pid=3D1 pos=3D1 obj=3D0 op=3D'NESTED LOOPS  =


(cr=3D9 r=3D0 w=3D0=20



time=3D103 us)'


STAT #1 id=3D3 cnt=3D1 pid=3D2 pos=3D1 obj=3D0 op=3D'NESTED LOOPS  =


(cr=3D6 r=3D0 w=3D0=20



time=3D80 us)'


STAT #1 id=3D4 cnt=3D1 pid=3D3 pos=3D1 obj=3D22 op=3D'TABLE ACCESS BY =
INDEX ROWID=20



USER$ (cr=3D2 r=3D0 w=3D0 time=3D31 us)'
STAT #1 id=3D5 cnt=3D1 pid=3D4 pos=3D1 obj=3D41 op=3D'INDEX UNIQUE SCAN =
I_USER1=20



(cr=3D1 r=3D0 w=3D0 time=3D17 us)'



STAT #1 id=3D6 cnt=3D1 pid=3D3 pos=3D2 obj=3D18 op=3D'TABLE ACCESS BY =
INDEX ROWID=20



OBJ$ (cr=3D4 r=3D0 w=3D0 time=3D41 us)'


STAT #1 id=3D7 cnt=3D1 pid=3D6 pos=3D1 obj=3D34 op=3D'INDEX RANGE SCAN =
I_OBJ2 (cr=3D3=20


r=3D0 w=3D0 time=3D28 us)'


STAT #1 id=3D8 cnt=3D1 pid=3D2 pos=3D2 obj=3D58 op=3D'TABLE ACCESS BY =
INDEX ROWID=20



SYN$ (cr=3D3 r=3D0 w=3D0 time=3D19 us)'


STAT #1 id=3D9 cnt=3D1 pid=3D8 pos=3D1 obj=3D98 op=3D'INDEX UNIQUE SCAN =
I_SYN1 (cr=3D2=20


r=3D0 w=3D0 time=3D10 us)'


STAT #1 id=3D10 cnt=3D0 pid=3D1 pos=3D2 obj=3D0 op=3D'FILTER  (cr=3D0 =
r=3D0 w=3D0 time=3D0 us)'


STAT #1 id=3D11 cnt=3D0 pid=3D10 pos=3D1 obj=3D0 op=3D'NESTED LOOPS  =


(cr=3D0 r=3D0 w=3D0=20



time=3D0 us)'


STAT #1 id=3D12 cnt=3D0 pid=3D11 pos=3D1 obj=3D0 op=3D'NESTED LOOPS  =


(cr=3D0 r=3D0 w=3D0=20



time=3D0 us)'


STAT #1 id=3D13 cnt=3D0 pid=3D12 pos=3D1 obj=3D22 op=3D'TABLE ACCESS BY =
INDEX ROWID=20



USER$ (cr=3D0 r=3D0 w=3D0 time=3D0 us)'


STAT #1 id=3D14 cnt=3D0 pid=3D13 pos=3D1 obj=3D41 op=3D'INDEX UNIQUE =
SCAN I_USER1=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D15 cnt=3D0 pid=3D12 pos=3D2 obj=3D18 op=3D'TABLE ACCESS BY =
INDEX ROWID=20



OBJ$ (cr=3D0 r=3D0 w=3D0 time=3D0 us)'


STAT #1 id=3D16 cnt=3D0 pid=3D15 pos=3D1 obj=3D34 op=3D'INDEX RANGE SCAN =
I_OBJ2=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D17 cnt=3D0 pid=3D11 pos=3D2 obj=3D100 op=3D'INDEX RANGE =
SCAN I_OBJAUTH1=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D18 cnt=3D0 pid=3D10 pos=3D2 obj=3D309 op=3D'FIXED TABLE =
FULL X$KZSRO=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D19 cnt=3D0 pid=3D1 pos=3D2 obj=3D310 op=3D'FIXED TABLE FULL =
X$KZSPR=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
PARSING IN CURSOR #2 len=3D37 dep=3D1 uid=3D0 oct=3D3 lid=3D0 =
tim=3D1063030977920720=20


hv=3D3468666020 ad=3D'31d96568'


select text from view$ where rowid=3D:1


END OF STMT



PARSE =



#2:c=3D0,e=3D37,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D1,og=3D4,tim=3D10=
63030977920718


BINDS #2:



  bind 0: dty=3D11 mxl=3D16(16) mal=3D00 scl=3D00 pre=3D00 oacflg=3D18 =
oacfl2=3D1=20


size=3D16 offset=3D0


    bfp=3D1102c5310 bln=3D16 avl=3D16 flg=3D05
    value=3D000003B9.0005.0001


EXEC =



#2:c=3D0,e=3D75,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D1,og=3D4,tim=3D10=
63030977920881


FETCH =



#2:c=3D0,e=3D30,p=3D0,cr=3D2,cu=3D0,mis=3D0,r=3D1,dep=3D1,og=3D4,tim=3D10=
63030977920933


STAT #2 id=3D1 cnt=3D1 pid=3D0 pos=3D1 obj=3D59 op=3D'TABLE ACCESS BY =
USER ROWID=20



VIEW$ (cr=3D1 r=3D0 w=3D0 time=3D17 us)'
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
PARSING IN CURSOR #1 len=3D101 dep=3D0 uid=3D151 oct=3D3 lid=3D151=20
tim=3D1063030977926355 hv=3D1239511293 ad=3D'34b95968'
SELECT INDEX_NAME, UNIQUENESS FROM  SYS.ALL_INDEXES WHERE TABLE_OWNER =

=3D=20


'SYS' AND TABLE_NAME =3D 'DUAL'



END OF STMT



PARSE=20



#1:c=3D10000,e=3D5993,p=3D0,cr=3D2,cu=3D0,mis=3D1,r=3D0,dep=3D0,og=3D4,ti=
m=3D1063030977926351


BINDS #1:



EXEC =



#1:c=3D0,e=3D78,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D0,og=3D4,tim=3D10=
63030977926506


WAIT #1: nam=3D'SQL*Net message to client' ela=3D 2 p1=3D1413697536 =
p2=3D1 p3=3D0


FETCH =



#1:c=3D0,e=3D119,p=3D0,cr=3D8,cu=3D0,mis=3D0,r=3D0,dep=3D0,og=3D4,tim=3D1=
063030977926677


WAIT #1: nam=3D'SQL*Net message from client' ela=3D 48008 =
p1=3D1413697536 p2=3D1=20


p3=3D0


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
PARSING IN CURSOR #2 len=3D18 dep=3D0 uid=3D151 oct=3D3 lid=3D151=20
tim=3D1063030977974903 hv=3D1333943659 ad=3D'34cad458'
select * from dual


END OF STMT



PARSE =



#2:c=3D0,e=3D71,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D0,og=3D4,tim=3D10=
63030977974899


WAIT #2: nam=3D'SQL*Net message to client' ela=3D 2 p1=3D1413697536 =
p2=3D1 p3=3D0


WAIT #2: nam=3D'SQL*Net message from client' ela=3D 1473 p1=3D1413697536 =
p2=3D1 p3=3D0


STAT #1 id=3D1 cnt=3D0 pid=3D0 pos=3D1 obj=3D0 op=3D'FILTER  (cr=3D8 =
r=3D0 w=3D0 time=3D115 us)'


STAT #1 id=3D2 cnt=3D0 pid=3D1 pos=3D1 obj=3D0 op=3D'NESTED LOOPS OUTER =


(cr=3D8 r=3D0=20



w=3D0 time=3D115 us)'


STAT #1 id=3D3 cnt=3D0 pid=3D2 pos=3D1 obj=3D0 op=3D'NESTED LOOPS OUTER =


(cr=3D8 r=3D0=20



w=3D0 time=3D113 us)'


STAT #1 id=3D4 cnt=3D0 pid=3D3 pos=3D1 obj=3D0 op=3D'NESTED LOOPS  =


(cr=3D8 r=3D0 w=3D0=20



time=3D112 us)'


STAT #1 id=3D5 cnt=3D0 pid=3D4 pos=3D1 obj=3D0 op=3D'NESTED LOOPS OUTER =


(cr=3D8 r=3D0=20



w=3D0 time=3D112 us)'


STAT #1 id=3D6 cnt=3D0 pid=3D5 pos=3D1 obj=3D0 op=3D'NESTED LOOPS  =


(cr=3D8 r=3D0 w=3D0=20



time=3D110 us)'


STAT #1 id=3D7 cnt=3D0 pid=3D6 pos=3D1 obj=3D0 op=3D'NESTED LOOPS OUTER =


(cr=3D8 r=3D0=20



w=3D0 time=3D110 us)'


STAT #1 id=3D8 cnt=3D0 pid=3D7 pos=3D1 obj=3D0 op=3D'NESTED LOOPS  =


(cr=3D8 r=3D0 w=3D0=20



time=3D108 us)'


STAT #1 id=3D9 cnt=3D1 pid=3D8 pos=3D1 obj=3D0 op=3D'NESTED LOOPS  =


(cr=3D5 r=3D0 w=3D0=20



time=3D77 us)'


STAT #1 id=3D10 cnt=3D1 pid=3D9 pos=3D1 obj=3D22 op=3D'TABLE ACCESS BY =
INDEX ROWID=20



USER$ (cr=3D2 r=3D0 w=3D0 time=3D31 us)'
STAT #1 id=3D11 cnt=3D1 pid=3D10 pos=3D1 obj=3D41 op=3D'INDEX UNIQUE =
SCAN I_USER1=20



(cr=3D1 r=3D0 w=3D0 time=3D15 us)'



STAT #1 id=3D12 cnt=3D1 pid=3D9 pos=3D2 obj=3D18 op=3D'TABLE ACCESS BY =
INDEX ROWID=20



OBJ$ (cr=3D3 r=3D0 w=3D0 time=3D37 us)'


STAT #1 id=3D13 cnt=3D1 pid=3D12 pos=3D1 obj=3D34 op=3D'INDEX RANGE SCAN =
I_OBJ2=20



(cr=3D2 r=3D0 w=3D0 time=3D24 us)'



STAT #1 id=3D14 cnt=3D0 pid=3D8 pos=3D2 obj=3D19 op=3D'TABLE ACCESS =
CLUSTER IND$=20



(cr=3D3 r=3D0 w=3D0 time=3D29 us)'



STAT #1 id=3D15 cnt=3D1 pid=3D14 pos=3D1 obj=3D3 op=3D'INDEX UNIQUE SCAN =
I_OBJ#=20



(cr=3D2 r=3D0 w=3D0 time=3D11 us)'



STAT #1 id=3D16 cnt=3D0 pid=3D7 pos=3D2 obj=3D18 op=3D'TABLE ACCESS BY =
INDEX ROWID=20



OBJ$ (cr=3D0 r=3D0 w=3D0 time=3D0 us)'


STAT #1 id=3D17 cnt=3D0 pid=3D16 pos=3D1 obj=3D33 op=3D'INDEX UNIQUE =
SCAN I_OBJ1=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D18 cnt=3D0 pid=3D6 pos=3D2 obj=3D18 op=3D'TABLE ACCESS BY =
INDEX ROWID=20



OBJ$ (cr=3D0 r=3D0 w=3D0 time=3D0 us)'


STAT #1 id=3D19 cnt=3D0 pid=3D18 pos=3D1 obj=3D33 op=3D'INDEX UNIQUE =
SCAN I_OBJ1=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D20 cnt=3D0 pid=3D5 pos=3D2 obj=3D22 op=3D'TABLE ACCESS =
CLUSTER USER$=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D21 cnt=3D0 pid=3D20 pos=3D1 obj=3D11 op=3D'INDEX UNIQUE =
SCAN I_USER#=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D22 cnt=3D0 pid=3D4 pos=3D2 obj=3D22 op=3D'TABLE ACCESS =
CLUSTER USER$=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D23 cnt=3D0 pid=3D22 pos=3D1 obj=3D11 op=3D'INDEX UNIQUE =
SCAN I_USER#=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D24 cnt=3D0 pid=3D3 pos=3D2 obj=3D14 op=3D'TABLE ACCESS =
CLUSTER SEG$=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D25 cnt=3D0 pid=3D24 pos=3D1 obj=3D9 op=3D'INDEX UNIQUE SCAN =



I_FILE#_BLOCK# (cr=3D0 r=3D0 w=3D0 time=3D0 us)'
STAT #1 id=3D26 cnt=3D0 pid=3D2 pos=3D2 obj=3D16 op=3D'TABLE ACCESS =
CLUSTER TS$=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D27 cnt=3D0 pid=3D26 pos=3D1 obj=3D7 op=3D'INDEX UNIQUE SCAN =
I_TS# (cr=3D0=20


r=3D0 w=3D0 time=3D0 us)'


STAT #1 id=3D28 cnt=3D0 pid=3D1 pos=3D2 obj=3D0 op=3D'NESTED LOOPS  =


(cr=3D0 r=3D0 w=3D0=20



time=3D0 us)'


STAT #1 id=3D29 cnt=3D0 pid=3D28 pos=3D1 obj=3D309 op=3D'FIXED TABLE =
FULL X$KZSRO=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D30 cnt=3D0 pid=3D28 pos=3D2 obj=3D101 op=3D'INDEX RANGE =
SCAN I_OBJAUTH2=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



STAT #1 id=3D31 cnt=3D0 pid=3D1 pos=3D2 obj=3D310 op=3D'FIXED TABLE FULL =
X$KZSPR=20



(cr=3D0 r=3D0 w=3D0 time=3D0 us)'



=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
PARSING IN CURSOR #1 len=3D18 dep=3D0 uid=3D151 oct=3D3 lid=3D151=20
tim=3D1063030977977330 hv=3D1333943659 ad=3D'34cad458'
select * from dual


END OF STMT



PARSE =



#1:c=3D0,e=3D31,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D0,og=3D4,tim=3D10=
63030977977327


BINDS #1:



EXEC =



#1:c=3D0,e=3D46,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D0,og=3D4,tim=3D10=
63030977977430


WAIT #1: nam=3D'SQL*Net message to client' ela=3D 1 p1=3D1413697536 =
p2=3D1 p3=3D0


FETCH =



#1:c=3D0,e=3D77,p=3D0,cr=3D3,cu=3D0,mis=3D0,r=3D1,dep=3D0,og=3D4,tim=3D10=
63030977977547


WAIT #1: nam=3D'SQL*Net message from client' ela=3D 553 p1=3D1413697536 =
p2=3D1 p3=3D0


FETCH =



#1:c=3D0,e=3D1,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D0,og=3D0,tim=3D106=
3030977978174


WAIT #1: nam=3D'SQL*Net message to client' ela=3D 1 p1=3D1413697536 =
p2=3D1 p3=3D0


WAIT #1: nam=3D'SQL*Net message from client' ela=3D 7914 p1=3D1413697536 =
p2=3D1 p3=3D0


XCTEND rlbk=3D1, rd_only=3D1


WAIT #0: nam=3D'SQL*Net message to client' ela=3D 1 p1=3D1413697536 =
p2=3D1 p3=3D0


WAIT #0: nam=3D'SQL*Net message from client' ela=3D 7313 p1=3D1413697536 =
p2=3D1 p3=3D0


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
PARSING IN CURSOR #2 len=3D116 dep=3D1 uid=3D0 oct=3D3 lid=3D0=20
tim=3D1063030977993750 hv=3D431456802 ad=3D'31f5d468'
select=20


o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.dataobj#=
,o.flags=20


from obj$ o where o.obj#=3D:1


END OF STMT



PARSE =



#2:c=3D0,e=3D97,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D1,og=3D4,tim=3D10=
63030977993747


BINDS #2:



  bind 0: dty=3D2 mxl=3D22(22) mal=3D00 scl=3D00 pre=3D00 oacflg=3D08 =
oacfl2=3D1=20


size=3D24 offset=3D0


    bfp=3D1102c5240 bln=3D22 avl=3D03 flg=3D05
    value=3D195


EXEC =



#2:c=3D0,e=3D90,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D1,og=3D4,tim=3D10=
63030977993980


FETCH =



#2:c=3D0,e=3D44,p=3D0,cr=3D3,cu=3D0,mis=3D0,r=3D1,dep=3D1,og=3D4,tim=3D10=
63030977994045


STAT #1 id=3D1 cnt=3D1 pid=3D0 pos=3D1 obj=3D195 op=3D'TABLE ACCESS FULL =
DUAL (cr=3D3=20


r=3D0 w=3D0 time=3D68 us)'


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
PARSE ERROR #1:len=3D5 dep=3D0 uid=3D151 oct=3D0 lid=3D151 =
tim=3D1063030977994272=20


err=3D900


exit


WAIT #1: nam=3D'SQL*Net break/reset to client' ela=3D 52 p1=3D1413697536 =
p2=3D1 p3=3D0


WAIT #1: nam=3D'SQL*Net break/reset to client' ela=3D 445 =
p1=3D1413697536 p2=3D0=20


p3=3D0


WAIT #1: nam=3D'SQL*Net message to client' ela=3D 2 p1=3D1413697536 =
p2=3D1 p3=3D0




Daniel Fink wrote:


> Leroy,
>=20
> 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.


>=20


> Don't give up hope, we're happy to help, we just need to have the =
information to assist.

>=20
> Regards,
> Daniel Fink
>=20
> Leroy Kemnitz wrote:
>=20
>>Here is the plan:
>>
>>SELECT STATEMENT   Cost =3D  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
>=20
>=20
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to:  oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>=20





--=20


LeRoy Kemnitz


UW System Administration


Database Administrator


780 Regent Street, #246


Madison, WI 53714


Phone: (608) 265 -5775


Fax: (608) 265 - 2090





Please see the official ORACLE-L FAQ: http://www.orafaq.com




To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


Received on Tue Jun 29 2004 - 18:48:39 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US