Double database load.

  • From: "Patamalla, Chaya" <chaya.patamalla@xxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 29 Jun 2004 16:58:37 -0500

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@xxxxxxxxxxxxx =
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of LeRoy Kemnitz
Sent: Tuesday, June 29, 2004 4:26 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>=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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: