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 -----------------------------------------------------------------