Re: Slow performance/response

From: LeRoy Kemnitz <lkemnitz_at_uwsa.edu>
Date: Tue, 29 Jun 2004 16:25:44 -0500
Message-ID: <40E1DE58.5070903@uwsa.edu>

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

PARSING IN CURSOR #1 len=136 dep=0 uid=151 oct=3 lid=151 tim=1063030977846699 hv=3920541172 ad='34ca93f8' SELECT OWNER, TABLE_NAME, TABLE_TYPE FROM SYS.ALL_CATALOG WHERE TABLE_TYPE IN ('TABLE','VIEW')AND OWNER = 'UWSA' AND TABLE_NAME = 'DUAL' END OF STMT
PARSE
#1:c=10000,e=5487,p=0,cr=5,cu=0,mis=1,r=0,dep=0,og=4,tim=1063030977846695 BINDS #1:
EXEC #1:c=0,e=59,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977846869 WAIT #1: nam='SQL*Net message to client' ela= 3 p1=1413697536 p2=1 p3=0 FETCH #1:c=0,e=101,p=0,cr=5,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977847026

WAIT #1: nam='SQL*Net message from client' ela= 1495 p1=1413697536 p2=1 p3=0
STAT #1 id=1 cnt=0 pid=0 pos=1 obj=0 op='FILTER  (cr=5 r=0 w=0 time=97 us)'
STAT #1 id=2 cnt=0 pid=1 pos=1 obj=0 op='NESTED LOOPS  (cr=5 r=0 w=0

time=96 us)'
STAT #1 id=3 cnt=1 pid=2 pos=1 obj=22 op='TABLE ACCESS BY INDEX ROWID USER$ (cr=2 r=0 w=0 time=32 us)'
STAT #1 id=4 cnt=1 pid=3 pos=1 obj=41 op='INDEX UNIQUE SCAN I_USER1
(cr=1 r=0 w=0 time=18 us)'

STAT #1 id=5 cnt=0 pid=2 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID 
OBJ$ (cr=3 r=0 w=0 time=54 us)'
STAT #1 id=6 cnt=1 pid=5 pos=1 obj=34 op='INDEX RANGE SCAN I_OBJ2 (cr=2

r=0 w=0 time=34 us)'
STAT #1 id=7 cnt=0 pid=1 pos=2 obj=4 op='TABLE ACCESS CLUSTER TAB$ (cr=0 r=0 w=0 time=0 us)'
STAT #1 id=8 cnt=0 pid=7 pos=1 obj=3 op='INDEX UNIQUE SCAN I_OBJ# (cr=0 r=0 w=0 time=0 us)'
STAT #1 id=9 cnt=0 pid=1 pos=2 obj=0 op='NESTED LOOPS (cr=0 r=0 w=0 time=0 us)'
STAT #1 id=10 cnt=0 pid=9 pos=1 obj=309 op='FIXED TABLE FULL X$KZSRO
(cr=0 r=0 w=0 time=0 us)'

STAT #1 id=11 cnt=0 pid=9 pos=2 obj=101 op='INDEX RANGE SCAN I_OBJAUTH2
(cr=0 r=0 w=0 time=0 us)'

STAT #1 id=12 cnt=0 pid=1 pos=2 obj=310 op='FIXED TABLE FULL X$KZSPR
(cr=0 r=0 w=0 time=0 us)'

STAT #1 id=13 cnt=0 pid=1 pos=2 obj=310 op='FIXED TABLE FULL X$KZSPR
(cr=0 r=0 w=0 time=0 us)'

PARSING IN CURSOR #2 len=37 dep=1 uid=0 oct=3 lid=0 tim=1063030977849341 hv=3468666020 ad='31d96568'
select text from view$ where rowid=:1
END OF STMT

PARSE #2:c=0,e=35,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977849338
BINDS #2:
  bind 0: dty=11 mxl=16(16) mal=00 scl=00 pre=00 oacflg=18 oacfl2=1

size=16 offset=0

bfp=1102c5310 bln=16 avl=16 flg=05
value=000003BC.0008.0001
EXEC #2:c=0,e=74,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977849501 FETCH #2:c=0,e=33,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=1063030977849555 STAT #2 id=1 cnt=1 pid=0 pos=1 obj=59 op='TABLE ACCESS BY USER ROWID VIEW$ (cr=1 r=0 w=0 time=18 us)'

PARSING IN CURSOR #1 len=95 dep=0 uid=151 oct=3 lid=151 tim=1063030977852094 hv=1399578166 ad='34c87648' SELECT OWNER, SYNONYM_NAME FROM SYS.ALL_SYNONYMS WHERE OWNER = 'UWSA' AND SYNONYM_NAME = 'DUAL'
END OF STMT
PARSE #1:c=0,e=3110,p=0,cr=2,cu=0,mis=1,r=0,dep=0,og=4,tim=1063030977852090 BINDS #1:
EXEC #1:c=0,e=62,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977852229 WAIT #1: nam='SQL*Net message to client' ela= 2 p1=1413697536 p2=1 p3=0 FETCH #1:c=0,e=78,p=0,cr=5,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977852357

WAIT #1: nam='SQL*Net message from client' ela= 2958 p1=1413697536 p2=1 p3=0
STAT #1 id=1 cnt=0 pid=0 pos=1 obj=0 op='FILTER  (cr=5 r=0 w=0 time=74 us)'
STAT #1 id=2 cnt=0 pid=1 pos=1 obj=0 op='NESTED LOOPS  (cr=5 r=0 w=0

time=74 us)'
STAT #1 id=3 cnt=0 pid=2 pos=1 obj=0 op='NESTED LOOPS (cr=5 r=0 w=0 time=73 us)'
STAT #1 id=4 cnt=1 pid=3 pos=1 obj=22 op='TABLE ACCESS BY INDEX ROWID USER$ (cr=2 r=0 w=0 time=29 us)'
STAT #1 id=5 cnt=1 pid=4 pos=1 obj=41 op='INDEX UNIQUE SCAN I_USER1
(cr=1 r=0 w=0 time=17 us)'

STAT #1 id=6 cnt=0 pid=3 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID 
OBJ$ (cr=3 r=0 w=0 time=34 us)'
STAT #1 id=7 cnt=1 pid=6 pos=1 obj=34 op='INDEX RANGE SCAN I_OBJ2 (cr=2

r=0 w=0 time=22 us)'

PARSING IN CURSOR #2 len=116 dep=1 uid=0 oct=3 lid=0 tim=1063030977855705 hv=431456802 ad='31f5d468' select
o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.dataobj#,o.flags from obj$ o where o.obj#=:1
END OF STMT

PARSE #2:c=0,e=51,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977855703
BINDS #2:
  bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1

size=24 offset=0

bfp=1102dd568 bln=22 avl=02 flg=05
value=58
EXEC #2:c=0,e=109,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977855944 FETCH #2:c=0,e=36,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=1063030977856003

STAT #1 id=8 cnt=0 pid=2 pos=2 obj=58 op='TABLE ACCESS BY INDEX ROWID 
SYN$ (cr=0 r=0 w=0 time=0 us)'
STAT #1 id=9 cnt=0 pid=8 pos=1 obj=98 op='INDEX UNIQUE SCAN I_SYN1 (cr=0

r=0 w=0 time=0 us)'
STAT #1 id=10 cnt=0 pid=1 pos=2 obj=0 op='FILTER (cr=0 r=0 w=0 time=0 us)' STAT #1 id=11 cnt=0 pid=10 pos=1 obj=0 op='NESTED LOOPS (cr=0 r=0 w=0 time=0 us)'
STAT #1 id=12 cnt=0 pid=11 pos=1 obj=0 op='NESTED LOOPS (cr=0 r=0 w=0 time=0 us)'

STAT #1 id=13 cnt=0 pid=12 pos=1 obj=22 op='TABLE ACCESS BY INDEX ROWID 
USER$ (cr=0 r=0 w=0 time=0 us)'
STAT #1 id=14 cnt=0 pid=13 pos=1 obj=41 op='INDEX UNIQUE SCAN I_USER1

(cr=0 r=0 w=0 time=0 us)'

STAT #1 id=15 cnt=0 pid=12 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID 
OBJ$ (cr=0 r=0 w=0 time=0 us)'
STAT #1 id=16 cnt=0 pid=15 pos=1 obj=34 op='INDEX RANGE SCAN I_OBJ2

(cr=0 r=0 w=0 time=0 us)'

STAT #1 id=17 cnt=0 pid=11 pos=2 obj=100 op='INDEX RANGE SCAN I_OBJAUTH1
(cr=0 r=0 w=0 time=0 us)'

STAT #1 id=18 cnt=0 pid=10 pos=2 obj=309 op='FIXED TABLE FULL X$KZSRO
(cr=0 r=0 w=0 time=0 us)'

STAT #1 id=19 cnt=0 pid=1 pos=2 obj=310 op='FIXED TABLE FULL X$KZSPR
(cr=0 r=0 w=0 time=0 us)'

PARSING IN CURSOR #3 len=37 dep=1 uid=0 oct=3 lid=0 tim=1063030977856645 hv=3468666020 ad='31d96568'
select text from view$ where rowid=:1
END OF STMT

PARSE #3:c=0,e=30,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977856643
BINDS #3:
  bind 0: dty=11 mxl=16(16) mal=00 scl=00 pre=00 oacflg=18 oacfl2=1

size=16 offset=0

bfp=1102c5290 bln=16 avl=16 flg=05
value=000003BC.0008.0001
EXEC #3:c=0,e=65,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977856788 FETCH #3:c=0,e=28,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=1063030977856837 STAT #3 id=1 cnt=1 pid=0 pos=1 obj=59 op='TABLE ACCESS BY USER ROWID VIEW$ (cr=1 r=0 w=0 time=16 us)'

PARSING IN CURSOR #1 len=97 dep=0 uid=151 oct=3 lid=151 tim=1063030977859357 hv=2433821915 ad='34c6cf48' SELECT OWNER, SYNONYM_NAME FROM SYS.ALL_SYNONYMS WHERE OWNER = 'PUBLIC' AND SYNONYM_NAME = 'DUAL'
END OF STMT
PARSE #1:c=0,e=3039,p=0,cr=2,cu=0,mis=1,r=0,dep=0,og=4,tim=1063030977859353 BINDS #1:
EXEC #1:c=0,e=56,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977859483 WAIT #1: nam='SQL*Net message to client' ela= 2 p1=1413697536 p2=1 p3=0 FETCH #1:c=0,e=114,p=0,cr=8,cu=0,mis=0,r=1,dep=0,og=4,tim=1063030977859647 WAIT #1: nam='SQL*Net message from client' ela= 1163 p1=1413697536 p2=1 p3=0 FETCH #1:c=0,e=23,p=0,cr=1,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977860931

WAIT #1: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 1243 p1=1413697536 p2=1 p3=0
STAT #1 id=1 cnt=1 pid=0 pos=1 obj=0 op='FILTER  (cr=9 r=0 w=0 time=122 us)'
STAT #1 id=2 cnt=1 pid=1 pos=1 obj=0 op='NESTED LOOPS  (cr=9 r=0 w=0

time=115 us)'
STAT #1 id=3 cnt=1 pid=2 pos=1 obj=0 op='NESTED LOOPS (cr=6 r=0 w=0 time=86 us)'
STAT #1 id=4 cnt=1 pid=3 pos=1 obj=22 op='TABLE ACCESS BY INDEX ROWID USER$ (cr=2 r=0 w=0 time=32 us)'
STAT #1 id=5 cnt=1 pid=4 pos=1 obj=41 op='INDEX UNIQUE SCAN I_USER1
(cr=1 r=0 w=0 time=17 us)'

STAT #1 id=6 cnt=1 pid=3 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID 
OBJ$ (cr=4 r=0 w=0 time=46 us)'
STAT #1 id=7 cnt=1 pid=6 pos=1 obj=34 op='INDEX RANGE SCAN I_OBJ2 (cr=3

r=0 w=0 time=32 us)'

STAT #1 id=8 cnt=1 pid=2 pos=2 obj=58 op='TABLE ACCESS BY INDEX ROWID 
SYN$ (cr=3 r=0 w=0 time=24 us)'
STAT #1 id=9 cnt=1 pid=8 pos=1 obj=98 op='INDEX UNIQUE SCAN I_SYN1 (cr=2

r=0 w=0 time=13 us)'
STAT #1 id=10 cnt=0 pid=1 pos=2 obj=0 op='FILTER (cr=0 r=0 w=0 time=0 us)' STAT #1 id=11 cnt=0 pid=10 pos=1 obj=0 op='NESTED LOOPS (cr=0 r=0 w=0 time=0 us)'
STAT #1 id=12 cnt=0 pid=11 pos=1 obj=0 op='NESTED LOOPS (cr=0 r=0 w=0 time=0 us)'

STAT #1 id=13 cnt=0 pid=12 pos=1 obj=22 op='TABLE ACCESS BY INDEX ROWID 
USER$ (cr=0 r=0 w=0 time=0 us)'
STAT #1 id=14 cnt=0 pid=13 pos=1 obj=41 op='INDEX UNIQUE SCAN I_USER1

(cr=0 r=0 w=0 time=0 us)'

STAT #1 id=15 cnt=0 pid=12 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID 
OBJ$ (cr=0 r=0 w=0 time=0 us)'
STAT #1 id=16 cnt=0 pid=15 pos=1 obj=34 op='INDEX RANGE SCAN I_OBJ2

PARSING IN CURSOR #1 len=276 dep=0 uid=151 oct=3 lid=151 tim=1063030977863756 hv=2671731006 ad='34c53228' SELECT
PBD_FHGT,PBD_FWGT,PBD_FITL,PBD_FUNL,PBD_FCHR,PBD_FPTC,PBD_FFCE,PBH_FHGT,PBH_FWGT,PBH_FITL,PBH_FUNL,PBH_FCHR,PBH_FPTC,PBH_FFCE,PBL_FHGT,PBL_FWGT,PBL_FITL,PBL_FUNL,PBL_FCHR,PBL_FPTC,PBL_FFCE,PBT_CMNT FROM SYSTEM.PBCATTBL WHERE PBT_OWNR = 'PUBLIC' AND PBT_TNAM = 'DUAL' END OF STMT
PARSE #1:c=0,e=892,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=1063030977863753 BINDS #1:
EXEC #1:c=0,e=46,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977863889 WAIT #1: nam='SQL*Net message to client' ela= 2 p1=1413697536 p2=1 p3=0 FETCH #1:c=0,e=19,p=0,cr=1,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977864026 WAIT #1: nam='SQL*Net message from client' ela= 1959 p1=1413697536 p2=1 p3=0

PARSING IN CURSOR #2 len=116 dep=1 uid=0 oct=3 lid=0 tim=1063030977866197 hv=431456802 ad='31f5d468' select
o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.dataobj#,o.flags from obj$ o where o.obj#=:1
END OF STMT

PARSE #2:c=0,e=50,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977866194
BINDS #2:
  bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1

size=24 offset=0

bfp=1102c5288 bln=22 avl=04 flg=05
value=36257
EXEC #2:c=0,e=78,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977866407 FETCH #2:c=0,e=41,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=1063030977866470

STAT #1 id=1 cnt=0 pid=0 pos=1 obj=36257 op='TABLE ACCESS BY INDEX ROWID 
PBCATTBL (cr=1 r=0 w=0 time=14 us)'
STAT #1 id=2 cnt=0 pid=1 pos=1 obj=36258 op='INDEX UNIQUE SCAN

PBSYSCATPBT_IDX (cr=1 r=0 w=0 time=11 us)'

PARSING IN CURSOR #3 len=37 dep=1 uid=0 oct=3 lid=0 tim=1063030977866990 hv=3468666020 ad='31d96568'
select text from view$ where rowid=:1
END OF STMT

PARSE #3:c=0,e=32,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977866987
BINDS #3:
  bind 0: dty=11 mxl=16(16) mal=00 scl=00 pre=00 oacflg=18 oacfl2=1

size=16 offset=0

bfp=1102dd610 bln=16 avl=16 flg=05
value=000003F8.0003.0001
EXEC #3:c=0,e=63,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977867130 FETCH #3:c=0,e=30,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=1063030977867181 STAT #3 id=1 cnt=1 pid=0 pos=1 obj=59 op='TABLE ACCESS BY USER ROWID VIEW$ (cr=1 r=0 w=0 time=17 us)'

PARSING IN CURSOR #3 len=37 dep=1 uid=0 oct=3 lid=0 tim=1063030977867568 hv=3468666020 ad='31d96568'
select text from view$ where rowid=:1
END OF STMT

PARSE #3:c=0,e=25,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977867565
BINDS #3:
  bind 0: dty=11 mxl=16(16) mal=00 scl=00 pre=00 oacflg=18 oacfl2=1

size=16 offset=0

bfp=1102dd480 bln=16 avl=16 flg=05
value=000035A9.0006.0001
EXEC #3:c=0,e=59,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977867700 FETCH #3:c=0,e=25,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=1063030977867745 STAT #3 id=1 cnt=1 pid=0 pos=1 obj=59 op='TABLE ACCESS BY USER ROWID VIEW$ (cr=1 r=0 w=0 time=11 us)'

PARSING IN CURSOR #1 len=235 dep=0 uid=151 oct=3 lid=151 tim=1063030977874810 hv=3378243952 ad='34c4c178' SELECT COLUMN_NAME, COLUMN_ID, DATA_TYPE_OWNER, DATA_TYPE, DATA_LENGTH, CHAR_COL_DECL_LENGTH, DATA_PRECISION, DATA_SCALE, NULLABLE, DATA_DEFAULT FROM SYS.ALL_TAB_COLUMNS WHERE TABLE_NAME = 'DUAL' AND OWNER = 'PUBLIC' ORDER BY COLUMN_ID
END OF STMT
PARSE #1:c=0,e=8234,p=0,cr=4,cu=0,mis=1,r=0,dep=0,og=4,tim=1063030977874806 BINDS #1:

EXEC #1:c=0,e=244,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977875160
WAIT #1: nam='SQL*Net message to client' ela= 3 p1=1413697536 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 1279 p1=1413697536 p2=1 p3=0

FETCH #1:c=0,e=125,p=0,cr=7,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977876763

WAIT #1: nam='SQL*Net message to client' ela= 1 p1=1413697536 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 1366 p1=1413697536 p2=1 p3=0
STAT #1 id=16 cnt=0 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=7 r=0 w=0

time=115 us)'
STAT #1 id=17 cnt=0 pid=16 pos=1 obj=0 op='FILTER (cr=7 r=0 w=0 time=96 us)'
STAT #1 id=18 cnt=0 pid=17 pos=1 obj=0 op='NESTED LOOPS OUTER (cr=7 r=0 w=0 time=95 us)'
STAT #1 id=19 cnt=0 pid=18 pos=1 obj=0 op='NESTED LOOPS OUTER (cr=7 r=0 w=0 time=93 us)'
STAT #1 id=20 cnt=0 pid=19 pos=1 obj=0 op='NESTED LOOPS OUTER (cr=7 r=0 w=0 time=92 us)'
STAT #1 id=21 cnt=0 pid=20 pos=1 obj=0 op='NESTED LOOPS OUTER (cr=7 r=0 w=0 time=92 us)'
STAT #1 id=22 cnt=0 pid=21 pos=1 obj=0 op='NESTED LOOPS (cr=7 r=0 w=0 time=90 us)'
STAT #1 id=23 cnt=1 pid=22 pos=1 obj=0 op='NESTED LOOPS (cr=5 r=0 w=0 time=69 us)'

STAT #1 id=24 cnt=1 pid=23 pos=1 obj=22 op='TABLE ACCESS BY INDEX ROWID 
USER$ (cr=2 r=0 w=0 time=28 us)'
STAT #1 id=25 cnt=1 pid=24 pos=1 obj=41 op='INDEX UNIQUE SCAN I_USER1

(cr=1 r=0 w=0 time=13 us)'

STAT #1 id=26 cnt=1 pid=23 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID 
OBJ$ (cr=3 r=0 w=0 time=31 us)'
STAT #1 id=27 cnt=1 pid=26 pos=1 obj=34 op='INDEX RANGE SCAN I_OBJ2

(cr=2 r=0 w=0 time=21 us)'

STAT #1 id=28 cnt=0 pid=22 pos=2 obj=21 op='TABLE ACCESS CLUSTER COL$
(cr=2 r=0 w=0 time=17 us)'

STAT #1 id=29 cnt=0 pid=28 pos=1 obj=3 op='INDEX UNIQUE SCAN I_OBJ#
(cr=2 r=0 w=0 time=16 us)'

PARSING IN CURSOR #2 len=116 dep=1 uid=0 oct=3 lid=0 tim=1063030977878681 hv=431456802 ad='31f5d468' select
o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.dataobj#,o.flags from obj$ o where o.obj#=:1
END OF STMT

PARSE #2:c=0,e=56,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977878679
BINDS #2:
  bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1

size=24 offset=0

bfp=1102e47e8 bln=22 avl=03 flg=05
value=241
EXEC #2:c=0,e=82,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977878895 FETCH #2:c=0,e=37,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=1063030977878953 STAT #1 id=30 cnt=0 pid=21 pos=2 obj=241 op='TABLE ACCESS CLUSTER COLTYPE$ (cr=0 r=0 w=0 time=0 us)'

STAT #1 id=31 cnt=0 pid=20 pos=2 obj=194 op='INDEX RANGE SCAN 
I_HH_OBJ#_INTCOL# (cr=0 r=0 w=0 time=0 us)'
STAT #1 id=32 cnt=0 pid=19 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID

OBJ$ (cr=0 r=0 w=0 time=0 us)'
STAT #1 id=33 cnt=0 pid=32 pos=1 obj=35 op='INDEX RANGE SCAN I_OBJ3
(cr=0 r=0 w=0 time=0 us)'

STAT #1 id=34 cnt=0 pid=18 pos=2 obj=22 op='TABLE ACCESS CLUSTER USER$
(cr=0 r=0 w=0 time=0 us)'

STAT #1 id=35 cnt=0 pid=34 pos=1 obj=11 op='INDEX UNIQUE SCAN I_USER#
(cr=0 r=0 w=0 time=0 us)'

STAT #1 id=36 cnt=0 pid=17 pos=2 obj=4 op='TABLE ACCESS CLUSTER TAB$
(cr=0 r=0 w=0 time=0 us)'

STAT #1 id=37 cnt=0 pid=36 pos=1 obj=3 op='INDEX UNIQUE SCAN I_OBJ#
(cr=0 r=0 w=0 time=0 us)'

STAT #1 id=38 cnt=0 pid=17 pos=2 obj=0 op='NESTED LOOPS (cr=0 r=0 w=0 time=0 us)'
STAT #1 id=39 cnt=0 pid=38 pos=1 obj=309 op='FIXED TABLE FULL X$KZSRO
(cr=0 r=0 w=0 time=0 us)'

STAT #1 id=40 cnt=0 pid=38 pos=2 obj=101 op='INDEX RANGE SCAN I_OBJAUTH2
(cr=0 r=0 w=0 time=0 us)'

STAT #1 id=41 cnt=0 pid=17 pos=2 obj=310 op='FIXED TABLE FULL X$KZSPR
(cr=0 r=0 w=0 time=0 us)'

PARSING IN CURSOR #3 len=43 dep=1 uid=0 oct=3 lid=0 tim=1063030977879826 hv=2455283208 ad='31ee40e8'
select user#,type# from user$ where name=:1 END OF STMT

PARSE #3:c=0,e=354,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=1063030977879823
BINDS #3:
  bind 0: dty=1 mxl=32(06) mal=00 scl=00 pre=00 oacflg=18 oacfl2=1

size=32 offset=0

bfp=1102c52f0 bln=32 avl=06 flg=05
value="PUBLIC"

EXEC #3:c=0,e=317,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977880240
FETCH #3:c=0,e=30,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=1063030977880296
=====================

PARSING IN CURSOR #1 len=29 dep=0 uid=151 oct=3 lid=151 tim=1063030977880574 hv=3203262218 ad='34c08508' SELECT * FROM "PUBLIC"."DUAL"
END OF STMT
PARSE #1:c=0,e=1288,p=0,cr=2,cu=0,mis=1,r=0,dep=0,og=4,tim=1063030977880571

WAIT #1: nam='SQL*Net message to client' ela= 3 p1=1413697536 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 1516 p1=1413697536 p2=1 p3=0
=====================

PARSING IN CURSOR #1 len=71 dep=0 uid=151 oct=3 lid=151 tim=1063030977882758 hv=4167003566 ad='31c38090' SELECT PBV_NAME,PBV_VALD,PBV_TYPE,PBV_CNTR,PBV_MSG FROM SYSTEM.PBCATVLD END OF STMT
PARSE #1:c=0,e=477,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=1063030977882755 BINDS #1:
EXEC #1:c=0,e=35,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977882860 WAIT #1: nam='SQL*Net message to client' ela= 2 p1=1413697536 p2=1 p3=0 FETCH #1:c=0,e=59,p=0,cr=3,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977882974 WAIT #1: nam='SQL*Net message from client' ela= 1653 p1=1413697536 p2=1 p3=0

PARSING IN CURSOR #2 len=116 dep=1 uid=0 oct=3 lid=0 tim=1063030977884826 hv=431456802 ad='31f5d468' select
o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.dataobj#,o.flags from obj$ o where o.obj#=:1
END OF STMT

PARSE #2:c=0,e=46,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977884823
BINDS #2:
  bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1

size=24 offset=0

bfp=1102c5288 bln=22 avl=04 flg=05
value=36263
EXEC #2:c=0,e=79,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977885031 FETCH #2:c=0,e=38,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=1063030977885090 STAT #1 id=1 cnt=0 pid=0 pos=1 obj=36263 op='TABLE ACCESS FULL PBCATVLD
(cr=3 r=0 w=0 time=56 us)'

PARSING IN CURSOR #1 len=63 dep=0 uid=151 oct=3 lid=151 tim=1063030977885676 hv=1175394665 ad='31c351f0' SELECT PBF_NAME,PBF_FRMT,PBF_TYPE,PBF_CNTR FROM SYSTEM.PBCATFMT END OF STMT
PARSE #1:c=0,e=505,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=1063030977885672 BINDS #1:
EXEC #1:c=0,e=28,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977885769 WAIT #1: nam='SQL*Net message to client' ela= 2 p1=1413697536 p2=1 p3=0 FETCH #1:c=0,e=55,p=0,cr=3,cu=0,mis=0,r=1,dep=0,og=4,tim=1063030977885878 WAIT #1: nam='SQL*Net message from client' ela= 1272 p1=1413697536 p2=1 p3=0 WAIT #1: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0 FETCH #1:c=0,e=77,p=0,cr=1,cu=0,mis=0,r=19,dep=0,og=4,tim=1063030977887302 WAIT #1: nam='SQL*Net message from client' ela= 2325 p1=1413697536 p2=1 p3=0

PARSING IN CURSOR #2 len=116 dep=1 uid=0 oct=3 lid=0 tim=1063030977889810 hv=431456802 ad='31f5d468' select
o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.dataobj#,o.flags from obj$ o where o.obj#=:1
END OF STMT

PARSE #2:c=0,e=45,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977889808
BINDS #2:
  bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1

size=24 offset=0

bfp=1102e4a68 bln=22 avl=04 flg=05
value=36261
EXEC #2:c=0,e=78,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977890018 FETCH #2:c=0,e=36,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=1063030977890076 STAT #1 id=1 cnt=20 pid=0 pos=1 obj=36261 op='TABLE ACCESS FULL PBCATFMT
(cr=4 r=0 w=0 time=76 us)'

PARSING IN CURSOR #1 len=117 dep=0 uid=151 oct=3 lid=151 tim=1063030977890750 hv=3941777003 ad='31c5a970' SELECT PBE_NAME,PBE_EDIT,PBE_TYPE,PBE_CNTR,PBE_WORK,PBE_SEQN,PBE_FLAG FROM SYSTEM.PBCATEDT ORDER BY PBE_NAME,PBE_SEQN END OF STMT
PARSE #1:c=0,e=593,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=1063030977890746 BINDS #1:
EXEC #1:c=0,e=49,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977890868 WAIT #1: nam='SQL*Net message to client' ela= 3 p1=1413697536 p2=1 p3=0 FETCH #1:c=0,e=150,p=0,cr=3,cu=0,mis=0,r=1,dep=0,og=4,tim=1063030977891082 WAIT #1: nam='SQL*Net message from client' ela= 1234 p1=1413697536 p2=1 p3=0 WAIT #1: nam='SQL*Net message to client' ela= 1 p1=1413697536 p2=1 p3=0 FETCH #1:c=0,e=92,p=0,cr=0,cu=0,mis=0,r=20,dep=0,og=4,tim=1063030977892486 WAIT #1: nam='SQL*Net message from client' ela= 1906 p1=1413697536 p2=1 p3=0 STAT #1 id=1 cnt=21 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=3 r=0 w=0 time=173 us)'

PARSING IN CURSOR #2 len=116 dep=1 uid=0 oct=3 lid=0 tim=1063030977894604 hv=431456802 ad='31f5d468' select
o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.dataobj#,o.flags from obj$ o where o.obj#=:1
END OF STMT

PARSE #2:c=0,e=46,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977894601
BINDS #2:
  bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1

size=24 offset=0

bfp=1102e4950 bln=22 avl=04 flg=05
value=36265
EXEC #2:c=0,e=82,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977894844 FETCH #2:c=0,e=37,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=1063030977894903 STAT #1 id=2 cnt=21 pid=1 pos=1 obj=36265 op='TABLE ACCESS FULL PBCATEDT
(cr=3 r=0 w=0 time=56 us)'

PARSING IN CURSOR #1 len=229 dep=0 uid=151 oct=3 lid=151 tim=1063030977895813 hv=2117949404 ad='34bf5208' SELECT
PBC_CNAM,PBC_TNAM,PBC_OWNR,PBC_LABL,PBC_LPOS,PBC_HDR,PBC_HPOS,PBC_JTFY,PBC_MASK,PBC_CASE,PBC_HGHT,PBC_WDTH,PBC_PTRN,PBC_BMAP,PBC_INIT,PBC_EDIT,PBC_CMNT FROM SYSTEM.PBCATCOL WHERE (PBC_TNAM = 'DUAL' AND PBC_OWNR = 'UWSA') END OF STMT
PARSE #1:c=0,e=830,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=1063030977895810 BINDS #1:
EXEC #1:c=0,e=45,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977895937 WAIT #1: nam='SQL*Net message to client' ela= 2 p1=1413697536 p2=1 p3=0 FETCH #1:c=0,e=27,p=0,cr=1,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977896063 WAIT #1: nam='SQL*Net message from client' ela= 1806 p1=1413697536 p2=1 p3=0

PARSING IN CURSOR #2 len=116 dep=1 uid=0 oct=3 lid=0 tim=1063030977898067 hv=431456802 ad='31f5d468' select
o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.dataobj#,o.flags from obj$ o where o.obj#=:1
END OF STMT

PARSE #2:c=0,e=46,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977898065
BINDS #2:
  bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1

size=24 offset=0

bfp=1102c5288 bln=22 avl=04 flg=05
value=36259
EXEC #2:c=0,e=77,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977898271 FETCH #2:c=0,e=34,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=1063030977898326

STAT #1 id=1 cnt=0 pid=0 pos=1 obj=36259 op='TABLE ACCESS BY INDEX ROWID 
PBCATCOL (cr=1 r=0 w=0 time=22 us)'
STAT #1 id=2 cnt=0 pid=1 pos=1 obj=36260 op='INDEX RANGE SCAN

PBSYSCATCOLDICT_IDX (cr=1 r=0 w=0 time=21 us)'

PARSING IN CURSOR #3 len=37 dep=1 uid=0 oct=3 lid=0 tim=1063030977898759 hv=3468666020 ad='31d96568'
select text from view$ where rowid=:1
END OF STMT

PARSE #3:c=0,e=31,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977898756
BINDS #3:
  bind 0: dty=11 mxl=16(16) mal=00 scl=00 pre=00 oacflg=18 oacfl2=1

size=16 offset=0

bfp=1102f0168 bln=16 avl=16 flg=05
value=000003B9.0005.0001
EXEC #3:c=0,e=63,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977898899 FETCH #3:c=0,e=33,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=1063030977898952 STAT #3 id=1 cnt=1 pid=0 pos=1 obj=59 op='TABLE ACCESS BY USER ROWID VIEW$ (cr=1 r=0 w=0 time=16 us)'

PARSING IN CURSOR #1 len=102 dep=0 uid=151 oct=3 lid=151 tim=1063030977904309 hv=1902070077 ad='34bee638' SELECT INDEX_NAME, UNIQUENESS FROM SYS.ALL_INDEXES WHERE TABLE_OWNER = 'UWSA' AND TABLE_NAME = 'DUAL'
END OF STMT
PARSE
#1:c=10000,e=5879,p=0,cr=2,cu=0,mis=1,r=0,dep=0,og=4,tim=1063030977904305 BINDS #1:
EXEC #1:c=0,e=74,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977904456 WAIT #1: nam='SQL*Net message to client' ela= 3 p1=1413697536 p2=1 p3=0 FETCH #1:c=0,e=84,p=0,cr=5,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977904591

WAIT #1: nam='SQL*Net message from client' ela= 1779 p1=1413697536 p2=1 p3=0
STAT #1 id=1 cnt=0 pid=0 pos=1 obj=0 op='FILTER  (cr=5 r=0 w=0 time=81 us)'
STAT #1 id=2 cnt=0 pid=1 pos=1 obj=0 op='NESTED LOOPS OUTER (cr=5 r=0

w=0 time=79 us)'
STAT #1 id=3 cnt=0 pid=2 pos=1 obj=0 op='NESTED LOOPS OUTER (cr=5 r=0 w=0 time=78 us)'
STAT #1 id=4 cnt=0 pid=3 pos=1 obj=0 op='NESTED LOOPS (cr=5 r=0 w=0 time=78 us)'
STAT #1 id=5 cnt=0 pid=4 pos=1 obj=0 op='NESTED LOOPS OUTER (cr=5 r=0 w=0 time=77 us)'
STAT #1 id=6 cnt=0 pid=5 pos=1 obj=0 op='NESTED LOOPS (cr=5 r=0 w=0 time=76 us)'
STAT #1 id=7 cnt=0 pid=6 pos=1 obj=0 op='NESTED LOOPS OUTER (cr=5 r=0 w=0 time=75 us)'
STAT #1 id=8 cnt=0 pid=7 pos=1 obj=0 op='NESTED LOOPS (cr=5 r=0 w=0 time=74 us)'
STAT #1 id=9 cnt=0 pid=8 pos=1 obj=0 op='NESTED LOOPS (cr=5 r=0 w=0 time=74 us)'

STAT #1 id=10 cnt=1 pid=9 pos=1 obj=22 op='TABLE ACCESS BY INDEX ROWID 
USER$ (cr=2 r=0 w=0 time=30 us)'
STAT #1 id=11 cnt=1 pid=10 pos=1 obj=41 op='INDEX UNIQUE SCAN I_USER1

(cr=1 r=0 w=0 time=17 us)'

STAT #1 id=12 cnt=0 pid=9 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID 
OBJ$ (cr=3 r=0 w=0 time=36 us)'
STAT #1 id=13 cnt=1 pid=12 pos=1 obj=34 op='INDEX RANGE SCAN I_OBJ2

(cr=2 r=0 w=0 time=22 us)'

STAT #1 id=14 cnt=0 pid=8 pos=2 obj=19 op='TABLE ACCESS CLUSTER IND$
(cr=0 r=0 w=0 time=0 us)'

STAT #1 id=15 cnt=0 pid=14 pos=1 obj=3 op='INDEX UNIQUE SCAN I_OBJ#
(cr=0 r=0 w=0 time=0 us)'

STAT #1 id=16 cnt=0 pid=7 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID 
OBJ$ (cr=0 r=0 w=0 time=0 us)'
STAT #1 id=17 cnt=0 pid=16 pos=1 obj=33 op='INDEX UNIQUE SCAN I_OBJ1

(cr=0 r=0 w=0 time=0 us)'

STAT #1 id=18 cnt=0 pid=6 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID 
OBJ$ (cr=0 r=0 w=0 time=0 us)'
STAT #1 id=19 cnt=0 pid=18 pos=1 obj=33 op='INDEX UNIQUE SCAN I_OBJ1

(cr=0 r=0 w=0 time=0 us)'

STAT #1 id=20 cnt=0 pid=5 pos=2 obj=22 op='TABLE ACCESS CLUSTER USER$
(cr=0 r=0 w=0 time=0 us)'

STAT #1 id=21 cnt=0 pid=20 pos=1 obj=11 op='INDEX UNIQUE SCAN I_USER#
(cr=0 r=0 w=0 time=0 us)'

STAT #1 id=22 cnt=0 pid=4 pos=2 obj=22 op='TABLE ACCESS CLUSTER USER$
(cr=0 r=0 w=0 time=0 us)'

STAT #1 id=23 cnt=0 pid=22 pos=1 obj=11 op='INDEX UNIQUE SCAN I_USER#
(cr=0 r=0 w=0 time=0 us)'

STAT #1 id=24 cnt=0 pid=3 pos=2 obj=14 op='TABLE ACCESS CLUSTER SEG$
(cr=0 r=0 w=0 time=0 us)'

STAT #1 id=25 cnt=0 pid=24 pos=1 obj=9 op='INDEX UNIQUE SCAN I_FILE#_BLOCK# (cr=0 r=0 w=0 time=0 us)' STAT #1 id=26 cnt=0 pid=2 pos=2 obj=16 op='TABLE ACCESS CLUSTER TS$
(cr=0 r=0 w=0 time=0 us)'

STAT #1 id=27 cnt=0 pid=26 pos=1 obj=7 op='INDEX UNIQUE SCAN I_TS# (cr=0 r=0 w=0 time=0 us)'
STAT #1 id=28 cnt=0 pid=1 pos=2 obj=0 op='NESTED LOOPS (cr=0 r=0 w=0 time=0 us)'
STAT #1 id=29 cnt=0 pid=28 pos=1 obj=309 op='FIXED TABLE FULL X$KZSRO
(cr=0 r=0 w=0 time=0 us)'

STAT #1 id=30 cnt=0 pid=28 pos=2 obj=101 op='INDEX RANGE SCAN I_OBJAUTH2
(cr=0 r=0 w=0 time=0 us)'

STAT #1 id=31 cnt=0 pid=1 pos=2 obj=310 op='FIXED TABLE FULL X$KZSPR
(cr=0 r=0 w=0 time=0 us)'

PARSING IN CURSOR #2 len=37 dep=1 uid=0 oct=3 lid=0 tim=1063030977907704 hv=3468666020 ad='31d96568'
select text from view$ where rowid=:1
END OF STMT

PARSE #2:c=0,e=39,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977907702
BINDS #2:
  bind 0: dty=11 mxl=16(16) mal=00 scl=00 pre=00 oacflg=18 oacfl2=1

size=16 offset=0

bfp=1102c5310 bln=16 avl=16 flg=05
value=000003BC.0008.0001
EXEC #2:c=0,e=75,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977907867 FETCH #2:c=0,e=33,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=1063030977907922 STAT #2 id=1 cnt=1 pid=0 pos=1 obj=59 op='TABLE ACCESS BY USER ROWID VIEW$ (cr=1 r=0 w=0 time=18 us)'

PARSING IN CURSOR #1 len=137 dep=0 uid=151 oct=3 lid=151 tim=1063030977910581 hv=584147568 ad='34bc9668' SELECT TABLE_OWNER, TABLE_NAME FROM SYS.ALL_SYNONYMS WHERE OWNER = 'UWSA' AND SYNONYM_NAME = 'DUAL' AND (DB_LINK IS NULL OR DB_LINK = '') END OF STMT
PARSE #1:c=0,e=3272,p=0,cr=2,cu=0,mis=1,r=0,dep=0,og=4,tim=1063030977910578 BINDS #1:
EXEC #1:c=0,e=60,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977910714 WAIT #1: nam='SQL*Net message to client' ela= 3 p1=1413697536 p2=1 p3=0 FETCH #1:c=0,e=76,p=0,cr=5,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977910841

WAIT #1: nam='SQL*Net message from client' ela= 2395 p1=1413697536 p2=1 p3=0
STAT #1 id=1 cnt=0 pid=0 pos=1 obj=0 op='FILTER  (cr=5 r=0 w=0 time=73 us)'
STAT #1 id=2 cnt=0 pid=1 pos=1 obj=0 op='NESTED LOOPS  (cr=5 r=0 w=0

time=72 us)'
STAT #1 id=3 cnt=0 pid=2 pos=1 obj=0 op='NESTED LOOPS (cr=5 r=0 w=0 time=70 us)'
STAT #1 id=4 cnt=1 pid=3 pos=1 obj=22 op='TABLE ACCESS BY INDEX ROWID USER$ (cr=2 r=0 w=0 time=29 us)'
STAT #1 id=5 cnt=1 pid=4 pos=1 obj=41 op='INDEX UNIQUE SCAN I_USER1
(cr=1 r=0 w=0 time=16 us)'

STAT #1 id=6 cnt=0 pid=3 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID 
OBJ$ (cr=3 r=0 w=0 time=34 us)'
STAT #1 id=7 cnt=1 pid=6 pos=1 obj=34 op='INDEX RANGE SCAN I_OBJ2 (cr=2

r=0 w=0 time=22 us)'

STAT #1 id=8 cnt=0 pid=2 pos=2 obj=58 op='TABLE ACCESS BY INDEX ROWID 
SYN$ (cr=0 r=0 w=0 time=0 us)'
STAT #1 id=9 cnt=0 pid=8 pos=1 obj=98 op='INDEX UNIQUE SCAN I_SYN1 (cr=0

STAT #1 id=13 cnt=0 pid=12 pos=1 obj=22 op='TABLE ACCESS BY INDEX ROWID 
USER$ (cr=0 r=0 w=0 time=0 us)'
STAT #1 id=14 cnt=0 pid=13 pos=1 obj=41 op='INDEX UNIQUE SCAN I_USER1

(cr=0 r=0 w=0 time=0 us)'

STAT #1 id=15 cnt=0 pid=12 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID 
OBJ$ (cr=0 r=0 w=0 time=0 us)'
STAT #1 id=16 cnt=0 pid=15 pos=1 obj=34 op='INDEX RANGE SCAN I_OBJ2

PARSING IN CURSOR #2 len=37 dep=1 uid=0 oct=3 lid=0 tim=1063030977914225 hv=3468666020 ad='31d96568'
select text from view$ where rowid=:1
END OF STMT

PARSE #2:c=0,e=37,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977914222
BINDS #2:
  bind 0: dty=11 mxl=16(16) mal=00 scl=00 pre=00 oacflg=18 oacfl2=1

size=16 offset=0

bfp=1102c5310 bln=16 avl=16 flg=05
value=000003BC.0008.0001
EXEC #2:c=0,e=75,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977914387 FETCH #2:c=0,e=30,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=1063030977914439 STAT #2 id=1 cnt=1 pid=0 pos=1 obj=59 op='TABLE ACCESS BY USER ROWID VIEW$ (cr=1 r=0 w=0 time=17 us)'

PARSING IN CURSOR #1 len=139 dep=0 uid=151 oct=3 lid=151 tim=1063030977917049 hv=3731089617 ad='34bafce0' SELECT TABLE_OWNER, TABLE_NAME FROM SYS.ALL_SYNONYMS WHERE OWNER = 'PUBLIC' AND SYNONYM_NAME = 'DUAL' AND (DB_LINK IS NULL OR DB_LINK = '') END OF STMT
PARSE
#1:c=10000,e=3217,p=0,cr=2,cu=0,mis=1,r=0,dep=0,og=4,tim=1063030977917045 BINDS #1:
EXEC #1:c=0,e=60,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977917181 WAIT #1: nam='SQL*Net message to client' ela= 3 p1=1413697536 p2=1 p3=0 FETCH #1:c=0,e=103,p=0,cr=8,cu=0,mis=0,r=1,dep=0,og=4,tim=1063030977917334 WAIT #1: nam='SQL*Net message from client' ela= 1101 p1=1413697536 p2=1 p3=0 FETCH #1:c=0,e=20,p=0,cr=1,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977918551

WAIT #1: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 1231 p1=1413697536 p2=1 p3=0
STAT #1 id=1 cnt=1 pid=0 pos=1 obj=0 op='FILTER  (cr=9 r=0 w=0 time=109 us)'
STAT #1 id=2 cnt=1 pid=1 pos=1 obj=0 op='NESTED LOOPS  (cr=9 r=0 w=0

time=103 us)'
STAT #1 id=3 cnt=1 pid=2 pos=1 obj=0 op='NESTED LOOPS (cr=6 r=0 w=0 time=80 us)'
STAT #1 id=4 cnt=1 pid=3 pos=1 obj=22 op='TABLE ACCESS BY INDEX ROWID USER$ (cr=2 r=0 w=0 time=31 us)'
STAT #1 id=5 cnt=1 pid=4 pos=1 obj=41 op='INDEX UNIQUE SCAN I_USER1
(cr=1 r=0 w=0 time=17 us)'

STAT #1 id=6 cnt=1 pid=3 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID 
OBJ$ (cr=4 r=0 w=0 time=41 us)'
STAT #1 id=7 cnt=1 pid=6 pos=1 obj=34 op='INDEX RANGE SCAN I_OBJ2 (cr=3

r=0 w=0 time=28 us)'

STAT #1 id=8 cnt=1 pid=2 pos=2 obj=58 op='TABLE ACCESS BY INDEX ROWID 
SYN$ (cr=3 r=0 w=0 time=19 us)'
STAT #1 id=9 cnt=1 pid=8 pos=1 obj=98 op='INDEX UNIQUE SCAN I_SYN1 (cr=2

r=0 w=0 time=10 us)'
STAT #1 id=10 cnt=0 pid=1 pos=2 obj=0 op='FILTER (cr=0 r=0 w=0 time=0 us)' STAT #1 id=11 cnt=0 pid=10 pos=1 obj=0 op='NESTED LOOPS (cr=0 r=0 w=0 time=0 us)'
STAT #1 id=12 cnt=0 pid=11 pos=1 obj=0 op='NESTED LOOPS (cr=0 r=0 w=0 time=0 us)'

STAT #1 id=13 cnt=0 pid=12 pos=1 obj=22 op='TABLE ACCESS BY INDEX ROWID 
USER$ (cr=0 r=0 w=0 time=0 us)'
STAT #1 id=14 cnt=0 pid=13 pos=1 obj=41 op='INDEX UNIQUE SCAN I_USER1

(cr=0 r=0 w=0 time=0 us)'

STAT #1 id=15 cnt=0 pid=12 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID 
OBJ$ (cr=0 r=0 w=0 time=0 us)'
STAT #1 id=16 cnt=0 pid=15 pos=1 obj=34 op='INDEX RANGE SCAN I_OBJ2

PARSING IN CURSOR #2 len=37 dep=1 uid=0 oct=3 lid=0 tim=1063030977920720 hv=3468666020 ad='31d96568'
select text from view$ where rowid=:1
END OF STMT

PARSE #2:c=0,e=37,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977920718
BINDS #2:
  bind 0: dty=11 mxl=16(16) mal=00 scl=00 pre=00 oacflg=18 oacfl2=1

size=16 offset=0

bfp=1102c5310 bln=16 avl=16 flg=05
value=000003B9.0005.0001
EXEC #2:c=0,e=75,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977920881 FETCH #2:c=0,e=30,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=1063030977920933 STAT #2 id=1 cnt=1 pid=0 pos=1 obj=59 op='TABLE ACCESS BY USER ROWID VIEW$ (cr=1 r=0 w=0 time=17 us)'

PARSING IN CURSOR #1 len=101 dep=0 uid=151 oct=3 lid=151 tim=1063030977926355 hv=1239511293 ad='34b95968' SELECT INDEX_NAME, UNIQUENESS FROM SYS.ALL_INDEXES WHERE TABLE_OWNER = 'SYS' AND TABLE_NAME = 'DUAL'
END OF STMT
PARSE
#1:c=10000,e=5993,p=0,cr=2,cu=0,mis=1,r=0,dep=0,og=4,tim=1063030977926351 BINDS #1:
EXEC #1:c=0,e=78,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977926506 WAIT #1: nam='SQL*Net message to client' ela= 2 p1=1413697536 p2=1 p3=0 FETCH #1:c=0,e=119,p=0,cr=8,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977926677 WAIT #1: nam='SQL*Net message from client' ela= 48008 p1=1413697536 p2=1 p3=0

PARSING IN CURSOR #2 len=18 dep=0 uid=151 oct=3 lid=151 tim=1063030977974903 hv=1333943659 ad='34cad458' select * from dual
END OF STMT
PARSE #2:c=0,e=71,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977974899

WAIT #2: nam='SQL*Net message to client' ela= 2 p1=1413697536 p2=1 p3=0
WAIT #2: nam='SQL*Net message from client' ela= 1473 p1=1413697536 p2=1 p3=0
STAT #1 id=1 cnt=0 pid=0 pos=1 obj=0 op='FILTER  (cr=8 r=0 w=0 time=115 us)'
STAT #1 id=2 cnt=0 pid=1 pos=1 obj=0 op='NESTED LOOPS OUTER (cr=8 r=0

w=0 time=115 us)'
STAT #1 id=3 cnt=0 pid=2 pos=1 obj=0 op='NESTED LOOPS OUTER (cr=8 r=0 w=0 time=113 us)'
STAT #1 id=4 cnt=0 pid=3 pos=1 obj=0 op='NESTED LOOPS (cr=8 r=0 w=0 time=112 us)'
STAT #1 id=5 cnt=0 pid=4 pos=1 obj=0 op='NESTED LOOPS OUTER (cr=8 r=0 w=0 time=112 us)'
STAT #1 id=6 cnt=0 pid=5 pos=1 obj=0 op='NESTED LOOPS (cr=8 r=0 w=0 time=110 us)'
STAT #1 id=7 cnt=0 pid=6 pos=1 obj=0 op='NESTED LOOPS OUTER (cr=8 r=0 w=0 time=110 us)'
STAT #1 id=8 cnt=0 pid=7 pos=1 obj=0 op='NESTED LOOPS (cr=8 r=0 w=0 time=108 us)'
STAT #1 id=9 cnt=1 pid=8 pos=1 obj=0 op='NESTED LOOPS (cr=5 r=0 w=0 time=77 us)'

STAT #1 id=10 cnt=1 pid=9 pos=1 obj=22 op='TABLE ACCESS BY INDEX ROWID 
USER$ (cr=2 r=0 w=0 time=31 us)'
STAT #1 id=11 cnt=1 pid=10 pos=1 obj=41 op='INDEX UNIQUE SCAN I_USER1

(cr=1 r=0 w=0 time=15 us)'

STAT #1 id=12 cnt=1 pid=9 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID 
OBJ$ (cr=3 r=0 w=0 time=37 us)'
STAT #1 id=13 cnt=1 pid=12 pos=1 obj=34 op='INDEX RANGE SCAN I_OBJ2

(cr=2 r=0 w=0 time=24 us)'

STAT #1 id=14 cnt=0 pid=8 pos=2 obj=19 op='TABLE ACCESS CLUSTER IND$
(cr=3 r=0 w=0 time=29 us)'

STAT #1 id=15 cnt=1 pid=14 pos=1 obj=3 op='INDEX UNIQUE SCAN I_OBJ#
(cr=2 r=0 w=0 time=11 us)'

STAT #1 id=16 cnt=0 pid=7 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID 
OBJ$ (cr=0 r=0 w=0 time=0 us)'
STAT #1 id=17 cnt=0 pid=16 pos=1 obj=33 op='INDEX UNIQUE SCAN I_OBJ1

(cr=0 r=0 w=0 time=0 us)'

STAT #1 id=18 cnt=0 pid=6 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID 
OBJ$ (cr=0 r=0 w=0 time=0 us)'
STAT #1 id=19 cnt=0 pid=18 pos=1 obj=33 op='INDEX UNIQUE SCAN I_OBJ1

PARSING IN CURSOR #1 len=18 dep=0 uid=151 oct=3 lid=151 tim=1063030977977330 hv=1333943659 ad='34cad458' select * from dual
END OF STMT
PARSE #1:c=0,e=31,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977977327 BINDS #1:
EXEC #1:c=0,e=46,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1063030977977430 WAIT #1: nam='SQL*Net message to client' ela= 1 p1=1413697536 p2=1 p3=0 FETCH #1:c=0,e=77,p=0,cr=3,cu=0,mis=0,r=1,dep=0,og=4,tim=1063030977977547 WAIT #1: nam='SQL*Net message from client' ela= 553 p1=1413697536 p2=1 p3=0 FETCH #1:c=0,e=1,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,tim=1063030977978174 WAIT #1: nam='SQL*Net message to client' ela= 1 p1=1413697536 p2=1 p3=0 WAIT #1: nam='SQL*Net message from client' ela= 7914 p1=1413697536 p2=1 p3=0 XCTEND rlbk=1, rd_only=1

WAIT #0: nam='SQL*Net message to client' ela= 1 p1=1413697536 p2=1 p3=0
WAIT #0: nam='SQL*Net message from client' ela= 7313 p1=1413697536 p2=1 p3=0
=====================

PARSING IN CURSOR #2 len=116 dep=1 uid=0 oct=3 lid=0 tim=1063030977993750 hv=431456802 ad='31f5d468' select
o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.dataobj#,o.flags from obj$ o where o.obj#=:1
END OF STMT

PARSE #2:c=0,e=97,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977993747
BINDS #2:
  bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1

size=24 offset=0

bfp=1102c5240 bln=22 avl=03 flg=05
value=195
EXEC #2:c=0,e=90,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1063030977993980 FETCH #2:c=0,e=44,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=1063030977994045 STAT #1 id=1 cnt=1 pid=0 pos=1 obj=195 op='TABLE ACCESS FULL DUAL (cr=3 r=0 w=0 time=68 us)'

PARSE ERROR #1:len=5 dep=0 uid=151 oct=0 lid=151 tim=1063030977994272 err=900
exit
WAIT #1: nam='SQL*Net break/reset to client' ela= 52 p1=1413697536 p2=1 p3=0 WAIT #1: nam='SQL*Net break/reset to client' ela= 445 p1=1413697536 p2=0 p3=0
WAIT #1: nam='SQL*Net message to client' ela= 2 p1=1413697536 p2=1 p3=0

Daniel Fink wrote:

> Leroy,
> 
> If you could include row source cardinality information it will help to identify areas for improvement using the throw-away
> methodology. From my perspective, it is also hard to read the output and understand the order of execution. Using the indentation
> method found in oracle doc (or including all the STAT lines as they are output) would be helpful.
> 
> Don't give up hope, we're happy to help, we just need to have the information to assist.
> 
> Regards,
> Daniel Fink
> 
> Leroy Kemnitz wrote:
> 
>>Here is the plan:
>>
>>SELECT STATEMENT   Cost =  3414
>>SORT ORDER BY
>>SORT GROUP BY
>>VIEW
>>WINDOW BUFFER
>>SORT GROUP BY
>>FILTER
>>TABLE ACCESS BY INDEX ROWID STUDENT_ANALYTICAL_BASE
>>NESTED LOOPS
>>VIEW
>>SORT GROUP BY
>>FILTER
>>TABLE ACCESS BY INDEX ROWID STUDENT_ANALYTICAL_BASE
>>NESTED LOOPS
>>TABLE ACCESS BY INDEX ROWID STUDENT_ANALYTICAL_BASE
>>INDEX RANGE SCAN PK_STUDENT_ANALYTICAL
>>INDEX RANGE SCAN PK_STUDENT_ANALYTICAL
>>FILTER
>>TABLE ACCESS FULL DUAL
>>FILTER
>>TABLE ACCESS FULL DUAL
>>FILTER
>>TABLE ACCESS FULL DUAL
>>FILTER
>>TABLE ACCESS FULL DUAL
>>FILTER
>>TABLE ACCESS FULL DUAL
>>FILTER
>>TABLE ACCESS FULL DUAL
>>FILTER
>>TABLE ACCESS FULL DUAL
>>FILTER
>>TABLE ACCESS FULL DUAL
>>INDEX RANGE SCAN PK_STUDENT_ANALYTICAL
>>FILTER
>>TABLE ACCESS FULL DUAL
> 
> 
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to:  oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>

-- 
LeRoy Kemnitz
UW System Administration
Database Administrator
780 Regent Street, #246
Madison, WI 53714
Phone: (608) 265 -5775
Fax: (608) 265 - 2090

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

Received on Tue Jun 29 2004 - 16:25:16 CDT