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