SQL statements in the Oracle SGA
User | Exec | % Disk | % Buff. | Cost | # FTS | Disk R./E | Buf Get/E | Sorts/E | Rows/E | SQL Text | First Load Time | Command | # Parses | Disk Rds | Buf Get | Sorts | Rows | Sharable Mem | Persist. Mem | Runtime Mem | Optimizer | Address | Status |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SYS | 1 | 6.57 | 10.76 | 3 | 0 | 109 | 3205 | 1 | 495 | select distinct d.p_obj#,d.p_timestamp from sys.dependency$ d, obj$ o where d.p_obj#>=:1 and d.d_obj#=o.obj# and o.status!=5 | 2002-01-27/21:37:54 | SELECT | 1 | 109 | 3205 | 1 | 495 | 11498 | 652 | 4124 | CHOOSE | 7B3E5B04 | analyzed |
SYS | 1 | 0.72 | 6.16 | 3 | 1 | 12 | 1836 | 1 | 0 | select distinct i.obj# from sys.idl_ub1$ i where i.obj#>=:1 and i.obj# not in (select d.p_obj# from sys.dependency$ d) | 2002-01-27/21:37:56 | SELECT | 1 | 12 | 1836 | 1 | 0 | 9168 | 596 | 2592 | CHOOSE | 7A7F1600 | analyzed |
SYS | 2 | 41.19 | 4.72 | 3 | 1 | 341 | 703 | 0 | 0 | select i.obj#, i.flags, u.name, o.name from sys.obj$ o, sys.user$ u, sys.ind$ i where (bitand(i.flags, 256) = 256 or bitand(i.flags, 512) = 512) and (not((i.type# = 9) and bitand(i.flags,8) = 8)) and o.obj#=i.obj# and o.owner# = u.user# | 2002-01-27/21:37:57 | SELECT | 2 | 683 | 1406 | 0 | 0 | 14854 | 748 | 4440 | CHOOSE | 7A7AB4D0 | analyzed |
SYS | 2 | 0.00 | 4.72 | 3 | 1 | 0 | 703 | 0 | 0 | select u.name, o.name, t.spare1, t.bobj# from sys.obj$ o, sys.user$ u, sys.tab$ t where (bitand(t.trigflag, 1048576) = 1048576) and o.obj#=t.obj# and o.owner# = u.user# | 2002-01-27/21:37:58 | SELECT | 2 | 0 | 1406 | 0 | 0 | 13807 | 748 | 4328 | CHOOSE | 7A719C6C | analyzed |
SYS | 1 | 10.49 | 1.44 | 0 | 0 | 174 | 428 | 0 | 1 | DECLARE opstring_in VARCHAR2(31) := :1; session_num_in NUMBER := :2; logmnr_uid_inout BINARY_INTEGER := :3; BEGIN sys.logmnr_krvrdluid3(opstring_in, session_num_in, logmnr_uid_inout); :3 := logmnr_uid_inout; END; | 2002-01-27/21:37:57 | PL/SQL | 1 | 174 | 428 | 0 | 1 | 10985 | 568 | 264 | CHOOSE | 7A7A6AF0 | not analyzed |
SYS | 1 | 6.82 | 0.62 | 3 | 1 | 113 | 184 | 0 | 1 | select o.owner#,o.obj#,decode(o.linkname,null, decode(u.name,null,'SYS',u.name),o.remoteowner), o.name,o.linkname,o.namespace,o.subname from user$ u, obj$ o where u.user#(+)=o.owner# and o.type#=:1 and not exists (select p_obj# from dependency$ where p_obj# = o.obj#) | 2002-01-27/21:37:54 | SELECT | 1 | 113 | 184 | 0 | 1 | 15865 | 936 | 5300 | CHOOSE | 7B3C83A8 | analyzed |
SYS | 2 | 0.42 | 0.87 | 3 | 1 | 3 | 130 | 0 | 0 | select i.obj#, i.flags, u.name, o.name from sys.obj$ o, sys.user$ u, sys.ind$ idx, sys.indpart$ i where bitand(i.flags, 512) = 512 and o.obj#=idx.obj# and o.owner# = u.user# and idx.obj#=i.bo# | 2002-01-27/21:37:57 | SELECT | 2 | 7 | 260 | 0 | 0 | 16585 | 752 | 5124 | CHOOSE | 7A746490 | analyzed |
SYS | 1 | 0.36 | 0.27 | 3 | 2 | 6 | 81 | 0 | 0 | select 1 from dual where exists (select 1 from system.repcat$_repprop prop where prop.type in (-1,2,9,-4) and prop.how in (1,3)) | 2002-01-27/21:38:00 | SELECT | 1 | 6 | 81 | 0 | 0 | 11287 | 576 | 2612 | CHOOSE | 7A6D65FC | analyzed |
SYS | 15 | 0.12 | 3.63 | 0 | 0 | 0 | 72 | 0 | 54 | insert into source$(obj#,line,source) values (:1,:2,:3) | 2002-01-27/21:44:15 | INSERT | 15 | 2 | 1083 | 0 | 810 | 11837 | 1176 | 3352 | MULTIPLE CHILDREN PRESENT | 7A67D04C | analyzed |
SYS | 1 | 0.18 | 0.21 | 0 | 0 | 3 | 64 | 0 | 1 | delete from obj$ where owner#=:1 and name=:2 and namespace=:3 and(remoteowner=:4 or remoteowner is null and :4 is null)and(linkname=:5 or linkname is null and :5 is null)and(subname=:6 or subname is null and :6 is null) | 2002-01-27/21:37:57 | DELETE | 1 | 3 | 64 | 0 | 1 | 12901 | 696 | 5760 | CHOOSE | 7A7BF5F8 | analyzed |
SYS | 15 | 0.36 | 3.23 | 0 | 0 | 0 | 64 | 0 | 50 | delete from source$ where obj#=:1 | 2002-01-27/21:37:56 | DELETE | 15 | 6 | 962 | 0 | 756 | 6647 | 536 | 2668 | CHOOSE | 7B393814 | analyzed |
SYS | 1 | 0.18 | 0.18 | 3 | 1 | 3 | 54 | 1 | 3 | select u.name, o.name, trigger$.sys_evts, trigger$.type# from obj$ o, user$ u, trigger$ where bitand(trigger$.property,8) = 8 and trigger$.property < 16 and trigger$.obj# = o.obj# and o.owner# = u.user# order by o.obj# | 2002-01-27/21:38:00 | SELECT | 1 | 3 | 54 | 1 | 3 | 14083 | 748 | 4620 | CHOOSE | 7A6D9A6C | analyzed |
SYS | 1 | 0.00 | 0.15 | 3 | 0 | 0 | 45 | 1 | 0 | select col#,intcol#,ntab# from ntab$ where obj#=:1 order by intcol# asc | 2002-01-27/21:37:58 | SELECT | 1 | 0 | 45 | 1 | 0 | 8785 | 704 | 2112 | CHOOSE | 7A73A80C | analyzed |
SYS | 1 | 0.06 | 0.13 | 3 | 0 | 1 | 38 | 1 | 0 | select col#,intcol#,toid,version#,packed,intcols,intcol#s,flags, nvl(typidcol#, 0) from coltype$ where obj#=:1 order by intcol# desc | 2002-01-27/21:37:58 | SELECT | 1 | 1 | 38 | 1 | 0 | 10642 | 1040 | 6580 | CHOOSE | 7A73EAEC | analyzed |
SYS | 1 | 0.00 | 0.12 | 3 | 0 | 0 | 37 | 1 | 0 | select col#,intcol#,reftyp,stabid,expctoid from refcon$ where obj#=:1 order by intcol# asc | 2002-01-27/21:37:58 | SELECT | 1 | 0 | 37 | 1 | 0 | 9080 | 816 | 2216 | CHOOSE | 7A73307C | analyzed |
SYS | 15 | 0.12 | 1.63 | 0 | 0 | 0 | 32 | 0 | 3 | delete from argument$ where obj#=:1 | 2002-01-27/21:37:56 | DELETE | 15 | 2 | 485 | 0 | 56 | 8421 | 536 | 4716 | CHOOSE | 7A7F3FA4 | analyzed |
SYS | 1 | 0.12 | 0.10 | 3 | 0 | 2 | 29 | 1 | 1 | select l.col#, l.intcol#, l.lobj#, l.ind#, l.ts#, l.file#, l.block#, l.chunk, l.pctversion$, l.flags, l.property from lob$ l where l.obj# = :1 order by l.intcol# asc | 2002-01-27/21:37:58 | SELECT | 1 | 2 | 29 | 1 | 1 | 10567 | 1152 | 2692 | CHOOSE | 7A73798C | analyzed |
SYS | 1 | 0.42 | 0.09 | 0 | 0 | 7 | 28 | 0 | 1 | SELECT COUNT(UID) FROM SYSTEM.LOGMNR_UID$ LU WHERE LU.SESSION# <= 2147483647 | 2002-01-27/21:37:59 | SELECT | 1 | 7 | 28 | 0 | 1 | 6085 | 572 | 1400 | CHOOSE | 7A7AA3E8 | analyzed |
SYS | 1 | 0.06 | 0.09 | 3 | 0 | 1 | 28 | 1 | 0 | select intcol#, toid, version#, intcols, intcol#s, flags from subcoltype$ where obj#=:1 order by intcol# asc | 2002-01-27/21:37:58 | SELECT | 1 | 1 | 28 | 1 | 0 | 8918 | 872 | 6260 | CHOOSE | 7A73DEBC | analyzed |
SYS | 1 | 0.00 | 0.09 | 3 | 0 | 0 | 28 | 1 | 0 | select intcol#,type,flags,lobcol,objcol,extracol,schemaoid, elemnum from opqtype$ where obj# = :1 order by intcol# asc | 2002-01-27/21:37:58 | SELECT | 1 | 0 | 28 | 1 | 0 | 9413 | 984 | 2448 | CHOOSE | 7A72B5B0 | analyzed |
SYS | 17 | 0.54 | 1.43 | 3 | 1 | 0 | 25 | 0 | 1 | select f.file#, f.block#, f.ts#, f.length from fet$ f, ts$ t where t.ts#=f.ts# and t.dflextpct!=0 and t.bitmapped=0 | 2002-01-27/21:43:05 | SELECT | 17 | 9 | 425 | 0 | 17 | 9709 | 744 | 2376 | CHOOSE | 7A6BFA3C | analyzed |
SYS | 1 | 0.12 | 0.08 | 3 | 0 | 2 | 25 | 0 | 0 | select pval2 from sys.aux_stats$ where sname = 'SYSSTATS_INFO' and pname = 'STATUS' | 2002-01-27/21:37:59 | SELECT | 1 | 2 | 25 | 0 | 0 | 6533 | 572 | 2120 | CHOOSE | 7A6DF34C | analyzed |
SYS | 1 | 0.12 | 0.08 | 3 | 0 | 2 | 24 | 0 | 1 | select increment$,minvalue,maxvalue,cycle#,order$,cache,highwater,audit$,flags from seq$ where obj#=:1 | 2002-01-27/21:37:57 | SELECT | 1 | 2 | 24 | 0 | 1 | 9180 | 1040 | 2080 | CHOOSE | 7A7C5A50 | analyzed |
SYS | 1 | 0.18 | 0.07 | 3 | 1 | 3 | 21 | 1 | 28 | select obj#, intcol# from sys.LOGMNR_INTERESTING_COLS order by obj#, intcol# | 2002-01-27/21:37:59 | SELECT | 1 | 3 | 21 | 1 | 28 | 7284 | 628 | 1652 | CHOOSE | 7A6E2148 | analyzed |
SYS | 3 | 0.12 | 0.20 | 3 | 0 | 0 | 20 | 1 | 0 | select tc.type#,tc.intcol#,tc.position#,c.type#, c.length,c.scale,c.precision#,c.charsetid,c.charsetform from triggercol$ tc,col$ c ,trigger$ tr where tc.obj#=:1 and c.obj#=:2 and tc.intcol#=c.intcol# and tr.obj# = tc.obj# and (bitand(tr.property,32) != 32 or bitand(tc.type#,20) = 20) union select type#,intcol#,position#,69,0,0,0,0,0 from triggercol$ where obj#=:3 and intcol#=1001 union select tc.type#,tc.intcol#,tc.position#,121,0,0,0,0,0 from triggercol$ tc,trigger$ tr where tr.obj# = tc.obj# and bitand(tr.property,32) = 32 and tc.obj# = :4 and bitand(tc.type#,20) != 20 | 2002-01-27/21:38:00 | SELECT | 3 | 2 | 60 | 3 | 0 | 31680 | 1120 | 8836 | CHOOSE | 7A6C6C88 | analyzed |
SYS | 14 | 9.23 | 0.74 | 3 | 0 | 10 | 15 | 1 | 3 | select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#,length,piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece# | 2002-01-27/21:37:57 | SELECT | 14 | 153 | 221 | 14 | 45 | 8998 | 744 | 3316 | CHOOSE | 7A747CF0 | analyzed |
SYS | 1 | 0.18 | 0.05 | 3 | 1 | 3 | 15 | 0 | 1 | select TOTAL from SYS.ID_GENS$ | 2002-01-27/21:37:57 | SELECT | 1 | 3 | 15 | 0 | 1 | 5152 | 572 | 1304 | CHOOSE | 7A7D1E04 | analyzed |
SYS | 1 | 0.06 | 0.05 | 3 | 1 | 1 | 15 | 0 | 0 | select location_name from loc$ | 2002-01-27/21:37:59 | SELECT | 1 | 1 | 15 | 0 | 0 | 5284 | 572 | 1768 | CHOOSE | 7A6DAD90 | analyzed |
SYS | 1 | 0.24 | 0.05 | 3 | 1 | 4 | 15 | 0 | 1 | select migrated from MIGRATE$ | 2002-01-27/21:37:57 | SELECT | 1 | 4 | 15 | 0 | 1 | 5403 | 572 | 1304 | CHOOSE | 7A7B42FC | analyzed |
SYS | 29 | 0.18 | 1.33 | 0 | 0 | 0 | 13 | 0 | 1 | delete from dependency$ where d_obj#=:1 | 2002-01-27/21:37:56 | DELETE | 29 | 3 | 397 | 0 | 56 | 9189 | 536 | 4376 | CHOOSE | 7A7D3894 | analyzed |
SYS | 2 | 0.18 | 0.09 | 3 | 0 | 1 | 13 | 0 | 1 | select metadata from kopm$ where name='DB_FDO' | 2002-01-27/21:37:57 | SELECT | 2 | 3 | 26 | 0 | 2 | 6781 | 572 | 1944 | CHOOSE | 7A7B0EF8 | analyzed |
SYS | 17 | 0.54 | 0.71 | 3 | 0 | 0 | 12 | 1 | 3 | select owner#,name,namespace,remoteowner,linkname,p_timestamp,p_obj#, d_owner#, nvl(property,0),subname from dependency$,obj$ where d_obj#=:1 and p_obj#=obj#(+) order by order# | 2002-01-27/21:37:57 | SELECT | 17 | 9 | 211 | 17 | 55 | 13422 | 1100 | 5052 | CHOOSE | 7A7A2370 | analyzed |
SYS | 15 | 0.12 | 0.52 | 0 | 0 | 0 | 10 | 0 | 1 | delete from settings$ where obj# = :1 | 2002-01-27/21:37:56 | DELETE | 15 | 2 | 154 | 0 | 28 | 6423 | 536 | 2588 | CHOOSE | 7A7DA0CC | analyzed |
SYS | 4 | 0.06 | 0.13 | 3 | 1 | 0 | 9 | 0 | 0 | select local_tran_id, global_tran_fmt, global_oracle_id, global_foreign_id, state, status, heuristic_dflt, session_vector, reco_vector, 3600*24*(sysdate-reco_time), 3600*24*(sysdate-nvl(heuristic_time,fail_time)), global_commit#, type# from pending_trans$ where session_vector != '00000000' | 2002-01-27/21:38:41 | SELECT | 4 | 1 | 38 | 0 | 0 | 11616 | 1244 | 2484 | CHOOSE | 7A6C5CA0 | analyzed |
SYS | 15 | 0.60 | 0.44 | 0 | 0 | 0 | 8 | 0 | 1 | SELECT COUNT(1) FROM user_objects WHERE object_type = :t AND object_name = :n AND status = 'VALID' | 2002-01-27/21:44:15 | SELECT | 15 | 10 | 130 | 0 | 15 | 38316 | 624 | 8744 | CHOOSE | 7A66650C | analyzed |
SYS | 29 | 0.24 | 0.79 | 0 | 0 | 0 | 8 | 0 | 1 | delete from access$ where d_obj#=:1 | 2002-01-27/21:37:57 | DELETE | 29 | 4 | 235 | 0 | 42 | 7085 | 536 | 2696 | CHOOSE | 7A7CB50C | analyzed |
SYS | 15 | 0.12 | 0.43 | 0 | 0 | 0 | 8 | 0 | 0 | delete from procedureinfo$ where obj#=:1 | 2002-01-27/21:37:56 | DELETE | 15 | 2 | 127 | 0 | 14 | 7038 | 536 | 2876 | CHOOSE | 7A7FBAF4 | analyzed |
SYS | 42 | 0.24 | 0.99 | 0 | 0 | 0 | 7 | 0 | 0 | delete from idl_ub1$ where obj#=:1 and part=:2 | 2002-01-27/21:37:56 | DELETE | 42 | 4 | 296 | 0 | 39 | 7536 | 556 | 2976 | CHOOSE | 7B396EFC | analyzed |
SYS | 15 | 0.06 | 0.36 | 0 | 0 | 0 | 7 | 0 | 0 | delete from procedurejava$ where obj#=:1 | 2002-01-27/21:37:56 | DELETE | 15 | 1 | 107 | 0 | 0 | 6594 | 536 | 2824 | CHOOSE | 7A7E404C | analyzed |
SYS | 6 | 0.48 | 0.15 | 3 | 0 | 1 | 7 | 0 | 1 | select cols,audit$,textlength,intcols,property,flags,rowid from view$ where obj#=:1 | 2002-01-27/21:44:15 | SELECT | 5 | 8 | 44 | 0 | 6 | 8109 | 928 | 1872 | CHOOSE | 7A65FF00 | analyzed |
SYS | 42 | 0.12 | 0.89 | 0 | 0 | 0 | 6 | 0 | 0 | delete from idl_sb4$ where obj#=:1 and part=:2 | 2002-01-27/21:37:56 | DELETE | 42 | 2 | 266 | 0 | 39 | 7388 | 556 | 2976 | CHOOSE | 7B37E720 | analyzed |
SYS | 15 | 0.24 | 0.32 | 0 | 1 | 0 | 6 | 0 | 0 | delete from vtable$ where obj#=:1 | 2002-01-27/21:37:56 | DELETE | 15 | 4 | 95 | 0 | 0 | 5855 | 536 | 2856 | CHOOSE | 7A7E381C | analyzed |
SYS | 60 | 0.30 | 1.33 | 0 | 0 | 0 | 6 | 0 | 1 | insert into argument$( obj#,procedure$,procedure#,overload#,position#,sequence#,level#,argument,type#,default#,in_out,length,precision#,scale,radix,charsetid,charsetform,properties,type_owner,type_name,type_subname,type_linkname,pls_type) values (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23) | 2002-01-27/21:44:15 | INSERT | 15 | 5 | 397 | 0 | 60 | 16888 | 988 | 18868 | CHOOSE | 7A671A6C | analyzed |
SYS | 1 | 0.00 | 0.02 | 0 | 0 | 0 | 6 | 0 | 1 | insert into obj$(owner#,name,namespace,obj#,type#,ctime,mtime,stime,status,remoteowner,linkname,subname,dataobj#,flags,oid$,spare1,spare2)values(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16, :17) | 2002-01-27/21:44:15 | INSERT | 1 | 0 | 6 | 0 | 1 | 15179 | 868 | 2308 | CHOOSE | 7A6676B0 | analyzed |
SYS | 14 | 2.83 | 0.33 | 3 | 0 | 3 | 6 | 1 | 1 | select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#,length,piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece# | 2002-01-27/21:37:57 | SELECT | 14 | 47 | 97 | 14 | 27 | 8854 | 744 | 3316 | CHOOSE | 7A74DE84 | analyzed |
SYS | 29 | 0.36 | 0.67 | 3 | 0 | 0 | 6 | 0 | 3 | select con#,type#,condlength,intcols,robj#,rcon#,match#,refact,nvl(enabled,0),rowid,cols,nvl(defer,0),mtime,nvl(spare1,0) from cdef$ where obj#=:1 | 2002-01-27/21:37:53 | SELECT | 20 | 6 | 199 | 0 | 114 | 12540 | 1320 | 2736 | CHOOSE | 7B3E4B04 | analyzed |
SYS | 59 | 0.24 | 1.23 | 3 | 0 | 0 | 6 | 0 | 2 | select pos#,intcol#,col#,spare1,bo#,spare2 from icol$ where obj#=:1 | 2002-01-27/21:37:54 | SELECT | 28 | 4 | 368 | 0 | 125 | 8513 | 872 | 2972 | CHOOSE | 7B3CBC54 | analyzed |
SYS | 18 | 0.24 | 0.30 | 0 | 0 | 0 | 5 | 0 | 1 | SELECT MIN(TIME_MP), COUNT(*) FROM SMON_SCN_TIME WHERE THREAD = :1 | 2002-01-27/21:37:57 | SELECT | 18 | 4 | 90 | 0 | 18 | 7076 | 648 | 2100 | CHOOSE | 7A7B5EF8 | analyzed |
SYS | 15 | 0.18 | 0.26 | 0 | 0 | 0 | 5 | 0 | 0 | delete from error$ where obj#=:1 | 2002-01-27/21:37:56 | DELETE | 15 | 3 | 78 | 0 | 0 | 6678 | 536 | 2720 | CHOOSE | 7B383C8C | analyzed |
SYS | 42 | 0.18 | 0.76 | 0 | 0 | 0 | 5 | 0 | 0 | delete from idl_char$ where obj#=:1 and part=:2 | 2002-01-27/21:37:56 | DELETE | 42 | 3 | 226 | 0 | 13 | 7365 | 556 | 2976 | CHOOSE | 7B38E0FC | analyzed |
SYS | 42 | 0.12 | 0.78 | 0 | 0 | 0 | 5 | 0 | 0 | delete from idl_ub2$ where obj#=:1 and part=:2 | 2002-01-27/21:37:56 | DELETE | 42 | 2 | 231 | 0 | 26 | 7808 | 556 | 2976 | CHOOSE | 7B38491C | analyzed |
SYS | 28 | 0.24 | 0.50 | 0 | 0 | 0 | 5 | 0 | 0 | delete from procedure$ where obj#=:1 | 2002-01-27/21:37:56 | DELETE | 14 | 4 | 150 | 0 | 13 | 6458 | 536 | 2584 | CHOOSE | 7B3B048C | analyzed |
SYS | 60 | 0.18 | 1.09 | 0 | 0 | 0 | 5 | 0 | 1 | insert into dependency$(d_obj#,d_timestamp,order#,p_obj#,p_timestamp,d_owner#, property)values (:1,:2,:3,:4,:5,:6, :7) | 2002-01-27/21:44:15 | INSERT | 15 | 3 | 325 | 0 | 60 | 9300 | 668 | 1832 | CHOOSE | 7A66E2C4 | analyzed |
SYS | 14 | 0.06 | 0.23 | 0 | 0 | 0 | 5 | 0 | 1 | insert into procedure$(obj#,audit$,options) values (:1,:2,:3) | 2002-01-27/21:44:15 | INSERT | 14 | 1 | 70 | 0 | 14 | 7027 | 588 | 1708 | CHOOSE | 7A67D7B8 | analyzed |
SYS | 53 | 0.97 | 0.97 | 3 | 0 | 0 | 5 | 2 | 1 | select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags, i.property,i.pctfree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey, i.lblkkey,i.dblkkey,i.clufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#, nvl(i.degree,1),nvl(i.instances,1),i.rowcnt,mod(i.pctthres$,256),i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl(c.deferrable#+c.valid#,0), nvl(i.spare1,i.intcols),i.spare4,spare2,decode(i.pctthres$,null,null, mod(trunc(i.pctthres$/256),256)) from ind$ i, (select enabled, min(cols) unicols, min(to_number(bitand(defer,1))) deferrable#, min(to_number(bitand(defer,4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.bo#=:1 | 2002-01-27/21:37:54 | SELECT | 29 | 16 | 289 | 137 | 59 | 29547 | 2412 | 9364 | CHOOSE | 7B3D2E1C | analyzed |
SYS | 1 | 0.00 | 0.02 | 3 | 0 | 0 | 5 | 0 | 1 | select null from obj$ where obj#=:1 and type#=:2 and obj# not in (select p_obj# from dependency$ where p_obj# = obj$.obj#) | 2002-01-27/21:37:55 | SELECT | 1 | 0 | 5 | 0 | 1 | 11208 | 616 | 2452 | CHOOSE | 7B3CB834 | analyzed |
SYS | 17 | 0.90 | 0.33 | 3 | 0 | 0 | 5 | 0 | 1 | select order#,columns,types from access$ where d_obj#=:1 | 2002-01-27/21:37:57 | SELECT | 17 | 15 | 98 | 0 | 32 | 7358 | 704 | 2968 | CHOOSE | 7A79E374 | analyzed |
SYS | 1 | 0.00 | 0.02 | 3 | 0 | 0 | 5 | 0 | 2 | select param, value from settings$ where obj# = :1 | 2002-01-27/22:42:39 | SELECT | 1 | 0 | 5 | 0 | 2 | 6952 | 648 | 10632 | CHOOSE | 7A03889C | analyzed |
SYS | 14 | 0.42 | 0.21 | 0 | 0 | 0 | 4 | 0 | 0 | delete from context$ where obj#=:1 | 2002-01-27/21:37:55 | DELETE | 14 | 7 | 64 | 0 | 0 | 6492 | 536 | 2584 | CHOOSE | 7B3F46D8 | analyzed |
SYS | 14 | 0.18 | 0.19 | 0 | 0 | 0 | 4 | 0 | 0 | delete from library$ where obj#=:1 | 2002-01-27/21:37:56 | DELETE | 14 | 3 | 58 | 0 | 0 | 6636 | 536 | 3076 | CHOOSE | 7B3ADC0C | analyzed |
SYS | 14 | 0.06 | 0.20 | 0 | 0 | 0 | 4 | 0 | 0 | delete from objauth$ where obj#=:1 | 2002-01-27/21:37:57 | DELETE | 14 | 1 | 61 | 0 | 0 | 8052 | 536 | 3044 | CHOOSE | 7A7C6344 | analyzed |
SYS | 14 | 0.06 | 0.22 | 0 | 0 | 0 | 4 | 0 | 0 | delete from opancillary$ where obj#=:1 | 2002-01-27/21:37:56 | DELETE | 14 | 1 | 66 | 0 | 0 | 6636 | 536 | 2696 | CHOOSE | 7B3A1584 | analyzed |
SYS | 14 | 0.06 | 0.20 | 0 | 0 | 0 | 4 | 0 | 0 | delete from oparg$ where obj# = :1 | 2002-01-27/21:37:56 | DELETE | 14 | 1 | 59 | 0 | 0 | 6212 | 536 | 2596 | CHOOSE | 7B397AEC | analyzed |
SYS | 14 | 0.06 | 0.20 | 0 | 0 | 0 | 4 | 0 | 0 | delete from opbinding$ where obj#=:1 | 2002-01-27/21:37:56 | DELETE | 14 | 1 | 61 | 0 | 0 | 6682 | 536 | 2772 | CHOOSE | 7B3A3FFC | analyzed |
SYS | 14 | 0.12 | 0.20 | 0 | 0 | 0 | 4 | 0 | 0 | delete from operator$ where obj#=:1 | 2002-01-27/21:37:56 | DELETE | 14 | 2 | 59 | 0 | 0 | 6209 | 536 | 2576 | CHOOSE | 7B3A9508 | analyzed |
SYS | 15 | 0.18 | 0.21 | 0 | 0 | 0 | 4 | 0 | 0 | delete from procedurec$ where obj#=:1 | 2002-01-27/21:37:56 | DELETE | 15 | 3 | 62 | 0 | 0 | 6895 | 536 | 2668 | CHOOSE | 7A7EE204 | analyzed |
SYS | 14 | 0.24 | 0.21 | 0 | 0 | 0 | 4 | 0 | 0 | delete from type_misc$ where obj#=:1 | 2002-01-27/21:37:56 | DELETE | 14 | 4 | 63 | 0 | 0 | 7010 | 536 | 3072 | CHOOSE | 7B3B308C | analyzed |
SYS | 14 | 0.06 | 0.19 | 0 | 0 | 0 | 4 | 0 | 1 | insert into idl_char$(obj#,part,version,piece#,length,piece) values(:1,:2,:3,:4,:5,:6) | 2002-01-27/21:44:15 | INSERT | 14 | 1 | 58 | 0 | 14 | 7996 | 648 | 18204 | CHOOSE | 7A677808 | analyzed |
SYS | 42 | 0.12 | 0.58 | 0 | 0 | 0 | 4 | 0 | 1 | insert into idl_ub1$(obj#,part,version,piece#,length,piece) values(:1,:2,:3,:4,:5,:6) | 2002-01-27/21:44:15 | INSERT | 28 | 2 | 172 | 0 | 42 | 8747 | 648 | 18204 | CHOOSE | 7A67AAC8 | analyzed |
SYS | 15 | 0.12 | 0.21 | 0 | 0 | 0 | 4 | 0 | 1 | insert into procedureinfo$(obj#,procedure#,overload#,procedurename,properties,itypeobj#) values (:1,:2,:3,:4,:5,:6) | 2002-01-27/21:44:15 | INSERT | 15 | 2 | 62 | 0 | 15 | 9773 | 648 | 1892 | CHOOSE | 7A6730B8 | analyzed |
SYS | 14 | 0.30 | 0.19 | 2 | 0 | 0 | 4 | 0 | 1 | select /*+ index(idl_sb4$ i_idl_sb41) +*/ max(version) from idl_sb4$ where obj#=:1 and version<=:2 and (part=0 or part=2) and piece#=0 | 2002-01-27/21:37:57 | SELECT | 14 | 5 | 56 | 0 | 14 | 9392 | 612 | 2744 | CHOOSE | 7A79D280 | analyzed |
SYS | 14 | 0.97 | 0.23 | 3 | 0 | 1 | 4 | 1 | 1 | select /*+ index(idl_sb4$ i_idl_sb41) +*/ piece#,length,piece from idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece# | 2002-01-27/21:37:57 | SELECT | 14 | 16 | 68 | 14 | 19 | 8910 | 744 | 3316 | CHOOSE | 7A798D4C | analyzed |
SYS | 1 | 0.00 | 0.01 | 3 | 0 | 0 | 4 | 1 | 28 | select col#,intcol#,charsetid,charsetform from col$ where obj#=:1 order by intcol# asc | 2002-01-27/21:37:58 | SELECT | 1 | 0 | 4 | 1 | 28 | 8956 | 760 | 2188 | CHOOSE | 7A72FEC0 | analyzed |
SYS | 15 | 0.00 | 0.20 | 3 | 1 | 0 | 4 | 0 | 1 | select value$ from props$ where name = 'GLOBAL_DB_NAME' | 2002-01-27/21:44:13 | SELECT | 15 | 0 | 60 | 0 | 15 | 5845 | 572 | 9336 | CHOOSE | 7AF94838 | analyzed |
SYS | 1 | 0.00 | 0.01 | 3 | 0 | 0 | 4 | 0 | 1 | update idl_char$ set piece#=:1 ,length=:2 , piece=:3 where obj#=:4 and part=:5 and piece#=:6 and version=:7 | 2002-01-27/22:42:40 | UPDATE | 1 | 0 | 4 | 0 | 1 | 9293 | 656 | 36536 | CHOOSE | 79FEF528 | analyzed |
SYS | 3 | 0.00 | 0.04 | 3 | 0 | 0 | 4 | 0 | 1 | update idl_sb4$ set piece#=:1 ,length=:2 , piece=:3 where obj#=:4 and part=:5 and piece#=:6 and version=:7 | 2002-01-27/22:42:40 | UPDATE | 2 | 0 | 12 | 0 | 3 | 10760 | 656 | 36536 | CHOOSE | 79FF7684 | analyzed |
SYS | 3 | 0.00 | 0.05 | 3 | 0 | 0 | 4 | 0 | 1 | update idl_ub1$ set piece#=:1 ,length=:2 , piece=:3 where obj#=:4 and part=:5 and piece#=:6 and version=:7 | 2002-01-27/22:42:40 | UPDATE | 2 | 0 | 14 | 0 | 3 | 9792 | 656 | 36536 | CHOOSE | 79FF17CC | analyzed |
SYS | 2 | 0.00 | 0.03 | 0 | 0 | 0 | 4 | 0 | 1 | update idl_ub2$ set piece#=:1 ,length=:2 , piece=:3 where obj#=:4 and part=:5 and piece#=:6 and version=:7 | 2002-01-27/22:42:40 | UPDATE | 1 | 0 | 8 | 0 | 2 | 9320 | 656 | 36536 | CHOOSE | 79FE7D20 | error |
SYS | 18 | 0.06 | 0.24 | 0 | 0 | 0 | 3 | 0 | 1 | INSERT INTO SMON_SCN_TIME (THREAD, TIME_MP, TIME_DP, SCN_WRP, SCN_BAS) VALUES (:1, :2, :3, :4, :5) | 2002-01-27/21:37:57 | INSERT | 18 | 1 | 71 | 0 | 18 | 7285 | 628 | 1772 | CHOOSE | 7A7A93E0 | analyzed |
SYS | 14 | 0.18 | 0.18 | 0 | 0 | 0 | 3 | 0 | 0 | delete from dir$ where obj#=:1 | 2002-01-27/21:37:56 | DELETE | 14 | 3 | 54 | 0 | 0 | 6196 | 536 | 2576 | CHOOSE | 7B3FA0A4 | analyzed |
SYS | 2 | 0.00 | 0.02 | 0 | 0 | 0 | 3 | 0 | 0 | delete from idl_char$ where obj#=:1 and part=:2 and (piece#<:3 or piece#>:4) and version=:5 | 2002-01-27/22:42:40 | DELETE | 2 | 0 | 6 | 0 | 0 | 8261 | 616 | 3104 | CHOOSE | 79FE6AC0 | analyzed |
SYS | 3 | 0.00 | 0.03 | 0 | 0 | 0 | 3 | 0 | 0 | delete from idl_char$ where obj#=:1 and part=:2 and version<>:3 | 2002-01-27/22:42:40 | DELETE | 3 | 0 | 9 | 0 | 0 | 7681 | 576 | 3004 | CHOOSE | 79FFE768 | analyzed |
SYS | 45 | 0.06 | 0.52 | 0 | 0 | 0 | 3 | 0 | 1 | insert into access$(d_obj#,order#,columns,types) values (:1,:2,:3,:4) | 2002-01-27/21:44:15 | INSERT | 15 | 1 | 154 | 0 | 45 | 6963 | 608 | 1716 | CHOOSE | 7A669954 | analyzed |
SYS | 42 | 0.06 | 0.53 | 0 | 0 | 0 | 3 | 0 | 1 | insert into idl_sb4$(obj#,part,version,piece#,length,piece) values(:1,:2,:3,:4,:5,:6) | 2002-01-27/21:44:15 | INSERT | 28 | 1 | 158 | 0 | 42 | 8415 | 648 | 18204 | CHOOSE | 7A67BAF8 | analyzed |
SYS | 28 | 0.06 | 0.34 | 0 | 0 | 0 | 3 | 0 | 1 | insert into idl_ub2$(obj#,part,version,piece#,length,piece) values(:1,:2,:3,:4,:5,:6) | 2002-01-27/21:44:15 | INSERT | 14 | 1 | 100 | 0 | 28 | 8479 | 648 | 18204 | CHOOSE | 7A676378 | error |
SYS | 30 | 0.12 | 0.35 | 0 | 0 | 0 | 3 | 0 | 1 | insert into settings$(obj#, param, value) values (:1, :2, :3) | 2002-01-27/21:44:15 | INSERT | 15 | 2 | 105 | 0 | 30 | 6591 | 588 | 1676 | CHOOSE | 7A66B220 | analyzed |
SYS | 14 | 0.54 | 0.15 | 3 | 0 | 0 | 3 | 1 | 0 | select /*+ index(idl_char$ i_idl_char1) +*/ piece#,length,piece from idl_char$ where obj#=:1 and part=:2 and version=:3 order by piece# | 2002-01-27/21:37:57 | SELECT | 14 | 9 | 44 | 14 | 6 | 8897 | 744 | 3316 | CHOOSE | 7A74D254 | analyzed |
SYS | 3 | 0.00 | 0.03 | 3 | 0 | 0 | 3 | 0 | 1 | select action# from trigger$ where obj# = :1 | 2002-01-27/21:38:00 | SELECT | 3 | 0 | 9 | 0 | 3 | 7134 | 592 | 1480 | CHOOSE | 7AF8FE58 | analyzed |
SYS | 11 | 0.36 | 0.11 | 3 | 0 | 0 | 3 | 0 | 1 | select audit$,options from procedure$ where obj#=:1 | 2002-01-27/21:37:57 | SELECT | 11 | 6 | 33 | 0 | 11 | 6933 | 648 | 1548 | CHOOSE | 7A7A1634 | analyzed |
SYS | 13 | 0.30 | 0.17 | 3 | 0 | 0 | 3 | 0 | 1 | select count(*) from association$ where obj# = :1 | 2002-01-27/22:03:35 | SELECT | 13 | 5 | 51 | 0 | 13 | 6855 | 592 | 1432 | CHOOSE | 7A637D1C | analyzed |
SYS | 1 | 0.00 | 0.01 | 3 | 0 | 0 | 3 | 0 | 1 | select count(*),min(piece#),max(piece#) from idl_char$ where obj#=:1 and part=:2 and version=:3 | 2002-01-27/22:42:40 | SELECT | 1 | 0 | 3 | 0 | 1 | 8261 | 744 | 1972 | CHOOSE | 79FF0C5C | analyzed |
SYS | 114 | 0.18 | 1.45 | 3 | 0 | 0 | 3 | 0 | 0 | select intcol#,nvl(pos#,0),col# from ccol$ where con#=:1 | 2002-01-27/21:37:53 | SELECT | 16 | 3 | 432 | 0 | 108 | 8418 | 704 | 2812 | MULTIPLE CHILDREN PRESENT | 7B3E22B0 | analyzed |
SYS | 59 | 0.18 | 0.61 | 3 | 0 | 0 | 3 | 1 | 8 | select name,intcol#,segcol#,type#,length,nvl(precision#,0),decode(type#,2,nvl(scale,-127/*MAXSB1MINAL*/),178,scale,179,scale,180,scale,181,scale,182,scale,183,scale,231,scale,0),null$,fixedstorage,nvl(deflength,0),default$,rowid,col#,property, nvl(charsetid,0),nvl(charsetform,0),spare1,spare2,nvl(spare3,0) from col$ where obj#=:1 order by intcol# | 2002-01-27/21:37:54 | SELECT | 31 | 3 | 183 | 59 | 493 | 17038 | 1600 | 3732 | CHOOSE | 7B3CAB24 | analyzed |
SYS | 1 | 0.00 | 0.01 | 3 | 1 | 0 | 3 | 0 | 0 | select p.value$, lengthb(p.value$) from sys.props$ p where p.name = 'BACK_END_DB' | 2002-01-27/21:37:57 | SELECT | 1 | 0 | 3 | 0 | 0 | 5661 | 628 | 9408 | CHOOSE | 7A7A5630 | analyzed |
SYS | 1 | 0.00 | 0.01 | 3 | 0 | 0 | 3 | 0 | 1 | select ts#,file#,block#,cols,nvl(size$,-1),pctfree$,pctused$,initrans,maxtrans,hashkeys,func,extind,avgchn,nvl(degree,1),nvl(instances,1),nvl(flags,0) from clu$ where obj#=:1 | 2002-01-27/21:37:57 | SELECT | 1 | 0 | 3 | 0 | 1 | 12056 | 1432 | 2960 | CHOOSE | 7A7AF5D4 | analyzed |
SYS | 53 | 1.33 | 0.54 | 3 | 0 | 0 | 3 | 0 | 1 | select ts#,file#,block#,nvl(bobj#,0),nvl(tab#,0),intcols,nvl(clucols,0),audit$,flags,pctfree$,pctused$,initrans,maxtrans,rowcnt,blkcnt,empcnt,avgspc,chncnt,avgrln,analyzetime, samplesize,cols,property,nvl(degree,1),nvl(instances,1),avgspc_flb,flbcnt,kernelcols,nvl(trigflag, 0),nvl(spare1,0),nvl(spare2,0),spare4 from tab$ where obj#=:1 | 2002-01-27/21:37:54 | SELECT | 30 | 22 | 162 | 0 | 53 | 18094 | 2328 | 6304 | CHOOSE | 7B3D4134 | analyzed |
SYS | 28 | 0.78 | 0.28 | 3 | 0 | 0 | 3 | 0 | 1 | select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts,NVL(lists,65535),NVL(groups,65535),cachehint,hwmincr, NVL(spare1,0) from seg$ where ts#=:1 and file#=:2 and block#=:3 | 2002-01-27/21:37:53 | SELECT | 28 | 13 | 84 | 0 | 28 | 12004 | 1360 | 3048 | CHOOSE | 7B3EE544 | analyzed |
SYS | 30 | 0.36 | 0.35 | 3 | 1 | 0 | 3 | 0 | 0 | select value$ from sys.props$ where name = :1 | 2002-01-27/21:37:54 | SELECT | 5 | 6 | 104 | 0 | 21 | 14191 | 1776 | 28008 | MULTIPLE CHILDREN PRESENT | 7B3BB3B0 | analyzed |
SYS | 28 | 0.00 | 0.30 | 3 | 0 | 0 | 3 | 0 | 1 | update obj$ set obj#=:6,type#=:7,ctime=:8,mtime=:9,stime=:10,status=:11,dataobj#=:13,flags=:14,oid$=:15,spare1=:16, spare2=:17 where owner#=:1 and name=:2 and namespace=:3 and(remoteowner=:4 or remoteowner is null and :4 is null)and(linkname=:5 or linkname is null and :5 is null)and(subname=:12 or subname is null and :12 is null) | 2002-01-27/21:44:14 | UPDATE | 28 | 0 | 89 | 0 | 28 | 17597 | 916 | 5160 | CHOOSE | 7A6AC7A8 | analyzed |
SYS | 1 | 0.00 | 0.01 | 3 | 0 | 0 | 3 | 0 | 1 | update procedure$ set audit$=:2,options=:3 where obj#=:1 | 2002-01-27/22:42:39 | UPDATE | 1 | 0 | 3 | 0 | 1 | 7946 | 576 | 2856 | CHOOSE | 7A1F9C80 | analyzed |
SYS | 39 | 0.24 | 0.44 | 3 | 0 | 0 | 3 | 0 | 1 | update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag,1),0,0,1), equijoin_preds = equijoin_preds + decode(bitand(:flag,2),0,0,1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag,4),0,0,1), range_preds = range_preds + decode(bitand(:flag,8),0,0,1), like_preds = like_preds + decode(bitand(:flag,16),0,0,1), null_preds = null_preds + decode(bitand(:flag,32),0,0,1), timestamp = :time where obj# = :objn and intcol# = :coln | 2002-01-27/22:24:03 | UPDATE | 12 | 4 | 130 | 0 | 39 | 16489 | 696 | 4200 | CHOOSE | 7A6A1B98 | analyzed |
SYS | 1 | 0.00 | 0.01 | 0 | 0 | 0 | 2 | 0 | 0 | delete from idl_sb4$ where obj#=:1 and part=:2 and (piece#<:3 or piece#>:4) and version=:5 | 2002-01-27/22:42:40 | DELETE | 1 | 0 | 2 | 0 | 0 | 8420 | 616 | 3104 | CHOOSE | 79FE02FC | analyzed |
SYS | 3 | 0.00 | 0.02 | 0 | 0 | 0 | 2 | 0 | 0 | delete from idl_sb4$ where obj#=:1 and part=:2 and version<>:3 | 2002-01-27/22:42:40 | DELETE | 3 | 0 | 6 | 0 | 0 | 7684 | 576 | 3004 | CHOOSE | 79FFA248 | analyzed |
SYS | 1 | 0.00 | 0.01 | 0 | 0 | 0 | 2 | 0 | 0 | delete from idl_ub1$ where obj#=:1 and part=:2 and (piece#<:3 or piece#>:4) and version=:5 | 2002-01-27/22:42:40 | DELETE | 1 | 0 | 2 | 0 | 0 | 8420 | 616 | 3104 | CHOOSE | 79FE481C | analyzed |
SYS | 3 | 0.00 | 0.02 | 0 | 0 | 0 | 2 | 0 | 0 | delete from idl_ub1$ where obj#=:1 and part=:2 and version<>:3 | 2002-01-27/22:42:39 | DELETE | 3 | 0 | 7 | 0 | 0 | 7624 | 576 | 3004 | CHOOSE | 79FFF9C8 | analyzed |
SYS | 2 | 0.00 | 0.01 | 0 | 0 | 0 | 2 | 0 | 0 | delete from idl_ub2$ where obj#=:1 and part=:2 and (piece#<:3 or piece#>:4) and version=:5 | 2002-01-27/22:42:40 | DELETE | 2 | 0 | 4 | 0 | 0 | 8704 | 616 | 3104 | CHOOSE | 79FE338C | analyzed |
SYS | 3 | 0.00 | 0.02 | 0 | 0 | 0 | 2 | 0 | 0 | delete from idl_ub2$ where obj#=:1 and part=:2 and version<>:3 | 2002-01-27/22:42:40 | DELETE | 3 | 0 | 6 | 0 | 0 | 7800 | 576 | 3004 | CHOOSE | 79FFB4A8 | analyzed |
SYS | 24 | 0.24 | 0.20 | 3 | 0 | 0 | 2 | 0 | 0 | select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2 | 2002-01-27/22:22:26 | SELECT | 5 | 4 | 61 | 0 | 0 | 12312 | 1452 | 3876 | RULE | 7A5252C0 | analyzed |
SYS | 3 | 0.06 | 0.02 | 3 | 0 | 0 | 2 | 0 | 1 | select actionsize from trigger$ where obj# = :1 | 2002-01-27/21:38:00 | SELECT | 3 | 1 | 6 | 0 | 3 | 6853 | 592 | 1456 | CHOOSE | 7A6CEA68 | analyzed |
SYS | 3 | 0.00 | 0.02 | 3 | 0 | 0 | 2 | 0 | 1 | select baseobject,type#,update$,insert$,delete$,refnewname,refoldname,whenclause,definition,enabled,property,sys_evts,nttrigcol,nttrigatt,refprtname,rowid from trigger$ where obj# =:1 | 2002-01-27/21:38:00 | SELECT | 3 | 0 | 6 | 0 | 3 | 11357 | 1432 | 18516 | CHOOSE | 7A6CA0A4 | analyzed |
SYS | 2 | 0.00 | 0.01 | 3 | 0 | 0 | 2 | 0 | 1 | select count(*),min(piece#),max(piece#) from idl_sb4$ where obj#=:1 and part=:2 and version=:3 | 2002-01-27/22:42:40 | SELECT | 2 | 0 | 4 | 0 | 2 | 8136 | 744 | 1972 | CHOOSE | 79FF9618 | analyzed |
SYS | 2 | 0.00 | 0.02 | 3 | 0 | 0 | 2 | 0 | 1 | select count(*),min(piece#),max(piece#) from idl_ub1$ where obj#=:1 and part=:2 and version=:3 | 2002-01-27/22:42:40 | SELECT | 2 | 0 | 5 | 0 | 2 | 8520 | 744 | 1972 | CHOOSE | 79FF55B4 | analyzed |
SYS | 1 | 0.00 | 0.01 | 3 | 0 | 0 | 2 | 0 | 1 | select count(*),min(piece#),max(piece#) from idl_ub2$ where obj#=:1 and part=:2 and version=:3 | 2002-01-27/22:42:40 | SELECT | 1 | 0 | 2 | 0 | 1 | 8228 | 744 | 1972 | CHOOSE | 79FEBD94 | analyzed |
SYS | 1 | 0.00 | 0.01 | 3 | 0 | 0 | 2 | 0 | 0 | select length from fet$ where file#=:1 and block#=:2 and ts#=:3 | 2002-01-27/21:43:05 | SELECT | 1 | 0 | 2 | 0 | 0 | 7553 | 632 | 1776 | CHOOSE | 7A6B995C | analyzed |
SYS | 3 | 0.18 | 0.02 | 3 | 0 | 1 | 2 | 0 | 1 | select name,online$,contents$,undofile#,undoblock#,blocksize,dflmaxext,dflinit,dflincr,dflextpct,dflminext, dflminlen, owner#,scnwrp,scnbas, NVL(pitrscnwrp, 0), NVL(pitrscnbas, 0), dflogging, bitmapped, inc#, flags, plugged, NVL(spare1,0), NVL(spare2,0) from ts$ where ts#=:1 | 2002-01-27/21:37:53 | SELECT | 3 | 3 | 6 | 0 | 3 | 15057 | 1880 | 3592 | CHOOSE | 7B3FA294 | analyzed |
SYS | 3 | 0.00 | 0.02 | 3 | 0 | 0 | 2 | 0 | 1 | select name,password,datats#,tempts#,type#,defrole,resource$, ptime, exptime, ltime, astatus, lcount, decode(defschclass,NULL,'DEFAULT_CONSUMER_GROUP',defschclass) from user$ where user#=:1 | 2002-01-27/21:37:58 | SELECT | 3 | 0 | 6 | 0 | 3 | 11131 | 1264 | 2596 | CHOOSE | 7A70AF50 | analyzed |
SYS | 1 | 0.00 | 0.01 | 3 | 0 | 0 | 2 | 0 | 0 | select o.name from obj$ o where o.name like 'ORA_TEMP_1_%' and o.owner# = 0 and bitand(o.flags, 2) = 2 and o.type# = 2 | 2002-01-27/21:37:59 | SELECT | 1 | 0 | 2 | 0 | 0 | 9208 | 572 | 3164 | CHOOSE | 7A6DCABC | analyzed |
SYS | 27 | 0.00 | 0.18 | 3 | 0 | 0 | 2 | 0 | 0 | select o.owner#, u.name, o.name, o.namespace, o.obj#, d.d_timestamp, nvl(d.property,0), o.type#, o.subname from dependency$ d, obj$ o, user$ u where d.p_obj#=:1 and (d.p_timestamp=:2 or d.property=2) and d.d_obj#=o.obj# and o.owner#=u.user# and decode(:3,0,0,o.type#)=:3 | 2002-01-27/22:03:35 | SELECT | 27 | 0 | 54 | 0 | 0 | 17276 | 1108 | 5972 | CHOOSE | 7A63ABE8 | analyzed |
SYS | 67 | 0.30 | 0.67 | 3 | 0 | 0 | 2 | 0 | 0 | select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.dataobj#,o.flags from obj$ o where o.obj#=:1 | 2002-01-27/21:37:54 | SELECT | 29 | 5 | 200 | 0 | 66 | 9950 | 984 | 2260 | CHOOSE | 7B3C6704 | analyzed |
SYS | 90 | 1.69 | 0.90 | 3 | 0 | 0 | 2 | 0 | 0 | select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and(remoteowner=:4 or remoteowner is null and :4 is null)and(linkname=:5 or linkname is null and :5 is null)and(subname=:6 or subname is null and :6 is null) | 2002-01-27/21:37:54 | SELECT | 35 | 28 | 267 | 0 | 87 | 14353 | 1312 | 4172 | CHOOSE | 7B3D6EC4 | analyzed |
SYS | 40 | 0.00 | 0.27 | 3 | 0 | 0 | 2 | 0 | 1 | select text from view$ where rowid=:1 | 2002-01-27/21:44:15 | SELECT | 40 | 0 | 80 | 0 | 40 | 6619 | 592 | 768 | CHOOSE | 7A65F034 | analyzed |
SYS | 2 | 0.12 | 0.01 | 3 | 0 | 1 | 2 | 0 | 1 | select user#,type# from user$ where name=:1 | 2002-01-27/21:37:54 | SELECT | 1 | 2 | 4 | 0 | 2 | 7305 | 648 | 1572 | CHOOSE | 7B3B8118 | analyzed |
SYS | 1302 | 0.00 | 4.37 | 0 | 0 | 0 | 1 | 0 | 0 | COMMIT | 2002-01-27/22:22:24 | OTHERS | 10 | 0 | 1303 | 0 | 0 | 5360 | 508 | 240 | CHOOSE | 7A684834 | not analyzed |
SYS | 1 | 0.00 | 0.00 | 0 | 0 | 0 | 1 | 0 | 1 | SELECT COUNT(UID) FROM SYSTEM.LOGMNR_UID$ LU WHERE LU.SESSION# > 2147483647 | 2002-01-27/21:37:59 | SELECT | 1 | 0 | 1 | 0 | 1 | 5996 | 572 | 1400 | CHOOSE | 7A7AA1F4 | analyzed |
SYS | 35 | 0.48 | 0.13 | 0 | 0 | 0 | 1 | 0 | 1 | SELECT v.banner, d.name FROM sys.v_$version v, sys.v_$database d WHERE ROWNUM = 1 | 2002-01-27/21:44:15 | SELECT | 35 | 8 | 40 | 0 | 35 | 43239 | 656 | 4216 | CHOOSE | 7A65BC30 | analyzed |
SYS | 4479 | 0.00 | 24.32 | 0 | 0 | 0 | 1 | 0 | 1 | insert into plan_table (statement_id, timestamp, operation, options,object_node, object_owner, object_name, object_instance, object_type,search_columns, id, parent_id, position, other,optimizer, cost, cardinality, bytes, other_tag, partition_start, partition_stop, partition_id, distribution, cpu_cost, io_cost, temp_space ) values(:1,SYSDATE,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25) | 2002-01-27/22:22:24 | INSERT | 1302 | 0 | 7248 | 0 | 4479 | 18949 | 1028 | 19460 | CHOOSE | 7A5D7974 | analyzed |
SYS | 30 | 0.00 | 0.19 | 3 | 0 | 0 | 1 | 0 | 0 | select col#, grantee#, privilege#,max(mod(nvl(option$,0),2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee# | 2002-01-27/21:37:54 | SELECT | 23 | 0 | 58 | 29 | 0 | 9827 | 760 | 3404 | MULTIPLE CHILDREN PRESENT | 7B3DA014 | analyzed |
SYS | 29 | 0.06 | 0.10 | 3 | 0 | 0 | 1 | 0 | 0 | select con#,obj#,rcon#,enabled,nvl(defer,0) from cdef$ where robj#=:1 | 2002-01-27/21:37:53 | SELECT | 20 | 1 | 29 | 0 | 0 | 9791 | 816 | 2984 | CHOOSE | 7B3E5734 | analyzed |
SYS | 30 | 0.06 | 0.20 | 3 | 0 | 0 | 1 | 0 | 0 | select grantee#,privilege#,nvl(col#,0),max(mod(nvl(option$,0),2))from objauth$ where obj#=:1 group by grantee#,privilege#,nvl(col#,0) order by grantee# | 2002-01-27/21:37:54 | SELECT | 23 | 1 | 59 | 29 | 1 | 9917 | 760 | 3436 | MULTIPLE CHILDREN PRESENT | 7B3D83B4 | analyzed |
SYS | 15 | 0.00 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | ALTER SESSION SET NLS_LANGUAGE= 'AMERICAN' NLS_TERRITORY= 'AMERICA' NLS_CURRENCY= '$' NLS_ISO_CURRENCY= 'AMERICA' NLS_NUMERIC_CHARACTERS= '.,' NLS_CALENDAR= 'GREGORIAN' NLS_DATE_FORMAT= 'DD-MON-RR' NLS_DATE_LANGUAGE= 'AMERICAN' NLS_SORT= 'BINARY' TIME_ZONE= '+01:00' NLS_DUAL_CURRENCY = '$' NLS_TIME_FORMAT = 'HH.MI.SSXFF AM' NLS_TIMESTAMP_FORMAT = 'DD-MON-RR HH.MI.SSXFF AM' NLS_TIME_TZ_FORMAT = 'HH.MI.SSXFF AM TZR' NLS_TIMESTAMP_TZ_FORMAT = 'DD-MON-RR HH.MI.SSXFF AM TZR' | 2002-01-27/21:44:13 | ALTER SESSION | 15 | 0 | 0 | 0 | 0 | 4657 | 508 | 240 | CHOOSE | 7AF93D34 | not analyzed |
SYS | 1 | 0.00 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | ALTER SESSION SET NLS_LANGUAGE= 'AMERICAN' NLS_TERRITORY= 'AMERICA' NLS_CURRENCY= '$' NLS_ISO_CURRENCY= 'AMERICA' NLS_NUMERIC_CHARACTERS= '.,' NLS_CALENDAR= 'GREGORIAN' NLS_DATE_FORMAT= 'DD-MON-RR' NLS_DATE_LANGUAGE= 'AMERICAN' NLS_SORT= 'BINARY' | 2002-01-27/21:37:37 | ALTER SESSION | 0 | 0 | 0 | 0 | 0 | 1664 | 0 | 0 | NONE | 7AF92054 | not analyzed |
SYS | 1 | 0.00 | 0.00 | 0 | 0 | 0 | 0 | 0 | 1 | SELECT VALUE FROM V$OPTION WHERE LOWER(PARAMETER) = 'partitioning' | 2002-01-27/21:37:59 | SELECT | 1 | 0 | 0 | 0 | 1 | 9443 | 580 | 748 | CHOOSE | 7A6ED3E0 | analyzed |
SYS | 1 | 0.00 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | alter database mount exclusive | 2002-01-27/21:37:37 | ALTER DATABASE | 0 | 0 | 0 | 0 | 0 | 1449 | 0 | 0 | NONE | 7AF914E8 | not analyzed |
SYS | 1 | 0.00 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | alter database open | 2002-01-27/21:37:43 | ALTER DATABASE | 0 | 0 | 0 | 0 | 0 | 1437 | 0 | 0 | NONE | 7AF90DCC | not analyzed |
SYS | 0 | 0.00 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | insert into sys.col_usage$ values ( :objn, :coln, decode(bitand(:flag,1),0,0,1), decode(bitand(:flag,2),0,0,1), decode(bitand(:flag,4),0,0,1), decode(bitand(:flag,8),0,0,1), decode(bitand(:flag,16),0,0,1), decode(bitand(:flag,32),0,0,1), :time) | 2002-01-27/22:24:03 | INSERT | 12 | 0 | 0 | 0 | 0 | 15090 | 680 | 0 | CHOOSE | 7A6A56F4 | analyzed |
SYS | 31 | 0.00 | 0.00 | 3 | 0 | 0 | 0 | 0 | 0 | select blevel, leafcnt, distkey, lblkkey, dblkkey, clufac, nvl(degree,1), nvl(instances,1) from ind$ where bo# = :1 and obj# = :2 | 2002-01-27/21:37:52 | SELECT | 0 | 0 | 0 | 0 | 0 | 1554 | 0 | 0 | NONE | 7B3F9134 | analyzed |
SYS | 45 | 0.00 | 0.00 | 3 | 0 | 0 | 0 | 0 | 0 | select charsetid, charsetform from col$ where obj# = :1 and col# = :2 | 2002-01-27/21:37:52 | SELECT | 0 | 0 | 0 | 0 | 0 | 1488 | 0 | 0 | NONE | 7B3F5244 | analyzed |
SYS | 55 | 0.00 | 0.00 | 3 | 0 | 0 | 0 | 0 | 0 | select ctime, mtime, stime from obj$ where obj# = :1 | 2002-01-27/21:37:52 | SELECT | 0 | 0 | 0 | 0 | 0 | 1470 | 0 | 0 | NONE | 7B3F2448 | analyzed |
SYS | 1 | 0.00 | 0.00 | 3 | 1 | 0 | 0 | 0 | 0 | select file#, block#, ts# from seg$ where type# = 3 | 2002-01-27/21:37:54 | SELECT | 0 | 0 | 0 | 0 | 0 | 1469 | 0 | 0 | NONE | 7B3B75AC | analyzed |
SYS | 1 | 0.00 | 0.00 | 3 | 1 | 0 | 0 | 0 | 0 | select line#, sql_text from bootstrap$ where obj# != :1 | 2002-01-27/21:37:48 | SELECT | 0 | 0 | 0 | 0 | 0 | 1473 | 0 | 0 | NONE | 7AF8B344 | analyzed |
SYS | 11 | 0.00 | 0.00 | 3 | 0 | 0 | 0 | 0 | 0 | select name,file#,block#,status$,user#,undosqn,xactsqn,scnbas,scnwrp,DECODE(inst#,0,NULL,inst#),ts#,spare1 from undo$ where us#=:1 | 2002-01-27/21:37:52 | SELECT | 0 | 0 | 0 | 0 | 0 | 1472 | 0 | 0 | NONE | 7B3EF7B8 | analyzed |
SYS | 0 | 0.00 | 0.00 | 3 | 0 | 0 | 0 | 0 | 0 | select o.name, u.name from sys.obj$ o, sys.user$ u where obj# = :1 and owner# = user# | 2002-01-27/22:22:24 | SELECT | 1302 | 0 | 0 | 0 | 0 | 11711 | 632 | 0 | CHOOSE | 7A5D2524 | analyzed |
SYS | 19 | 0.00 | 0.00 | 3 | 0 | 0 | 0 | 0 | 0 | select rowcnt,blkcnt,empcnt,avgspc,chncnt,avgrln,nvl(degree,1), nvl(instances,1) from tab$ where obj# = :1 | 2002-01-27/21:37:52 | SELECT | 0 | 0 | 0 | 0 | 0 | 1844 | 0 | 0 | NONE | 7B3FC3A0 | analyzed |
SYS | 20 | 0.00 | 0.00 | 3 | 0 | 0 | 0 | 0 | 0 | update undo$ set name=:2,file#=:3,block#=:4,status$=:5,user#=:6,undosqn=:7,xactsqn=:8,scnbas=:9,scnwrp=:10,inst#=:11,ts#=:12,spare1=:13 where us#=:1 | 2002-01-27/21:37:53 | UPDATE | 0 | 0 | 0 | 0 | 0 | 1558 | 0 | 0 | NONE | 7B3E9224 | analyzed |
Automatically generated Sun Jan 27 23:13:42 2002 with: Top100 - The Oracle SQL Area Profiler Version 1.7.0 Beta 1 Copyright © 1995-2002 by Material Dreams All Rights Reserved. WWW: www.materialdreams.com EMail: info@materialdreams.com |