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: Juan Carlos Reyes Pacheco <jreyes_at_dazasoftware.com>
Date: Tue, 29 Jun 2004 18:32:06 -0400
Message-Id: <40E1EDE6.000001.01144@CACHITOSS> 





I would increase sga and buffer size.


I would get statpacks reports to see how things are working now (level 7 if
possible, b ut include execution paths), then  after the increase, you could
have something to compare with.



Personally I'll wait to that moment, run statpacks as soon as possible, 
I will stay all the night in the office optimizing and fix what is wrong.



And that's all

 


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


From: oracle-l_at_freelists.org


Date: 06/29/04 17:58:38


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 - 17:36:05 CDT












Original text of this message













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