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 Elapsed mins. Command # Parses Disk Rds Buf Get Sorts Rows Sharable Mem Persist. Mem Runtime Mem Optimizer Address Status Error Message
SYS 1 2.85 3.40 110 0 394 4983 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) 2003-SEP-30 08:57:21 0 SELECT 1 394 4983 1 0 9527 592 3188 CHOOSE 7932D000 analyzed  
SYS 1 1.23 1.96 303 1 170 2875 1 572 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 2003-SEP-30 08:57:19 0 SELECT 1 170 2875 1 572 11301 652 4600 CHOOSE 793AA3B0 analyzed  
SYS 1 3.58 1.02 241 1 496 1498 0 338 update lob$ set retention = :1 where retention >= 0 2003-SEP-30 08:57:23 0 UPDATE 1 496 1498 0 338 7996 528 4012 CHOOSE 792F8324 analyzed  
SYS 1 4.87 0.87 302 2 674 1282 0 0 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#) for update 2003-SEP-30 08:57:19 0 SELECT 1 674 1282 0 0 17851 956 9752 CHOOSE 79368794 analyzed  
SYS 6 38.37 4.21 260 2 885 1027 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# 2003-SEP-30 08:57:22 0 SELECT 6 5314 6165 0 0 15093 756 5108 CHOOSE 79377C2C analyzed  
SYS 6 35.99 4.16 253 1 830 1016 0 0 select u.name, o.name, t.spare1, t.pctfree$ 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# 2003-SEP-30 08:57:25 0 SELECT 6 4984 6096 0 0 14081 756 4996 CHOOSE 792C3550 analyzed  
SYS 1 0.56 0.52 5 1 78 769 0 1 select e.xmldata."sysconfig"."protocolconfig"."ftpconfig"."ftp-port", e.xmldata."sysconfig"."protocolconfig"."ftpconfig"."ftp-protocol", e.xmldata."sysconfig"."protocolconfig"."ftpconfig"."ftp-listener", e.xmldata."sysconfig"."protocolconfig"."httpconfig"."http-port", e.xmldata."sysconfig"."protocolconfig"."httpconfig"."http-protocol", e.xmldata."sysconfig"."protocolconfig"."httpconfig"."http-listener" from xdb.xdb$config e 2003-SEP-30 08:57:27 0 SELECT 1 78 769 0 1 44357 868 38620 CHOOSE 79234C50 analyzed  
SYS 1 0.32 0.45 1 0 45 653 0 1 select rowid from XDB.XDB$SCHEMA s where s.xmldata.schema_url = :1 2003-SEP-30 08:57:26 0 SELECT 1 45 653 0 1 16787 588 4292 CHOOSE 7925F8C4 analyzed  
SYS 2 0.23 0.61 3661 0 16 449 0 314 insert into source$(obj#,line,source) values (:1,:2,:3) 2003-SEP-30 14:38:05 0 INSERT 2 32 899 0 629 7464 588 1996 CHOOSE 78D60F78 analyzed  
SYS 1 0.07 0.17 13 0 10 243 1 35 select column_name "Name", decode(nullable, 'Y', '', 'N', 'NOT NULL', nullable) "Null?", decode(data_type, 'CHAR', data_type || '(' || data_length || ')', 'NCHAR', data_type || '(' || data_length || ')', 'VARCHAR2', data_type || '(' || data_length || ')', 'NVARCHAR2', data_type || '(' || data_length || ')', 'NUMBER', data_type || decode(data_precision, '', '', '(' || data_precision || decode(data_scale, 0, '', '', '', ',' || data_scale) || ')'), 'RAW', data_type || '(' || data_length || ')', data_type) "Type" from all_tab_columns where owner = 'SYS' and table_name = 'V_$SQLAREA' order by column_id
 2003-SEP-30 12:12:22 0 SELECT 1 10 243 1 35 101807 764 31944 CHOOSE 78E3C768 analyzed  
SYS 1 0.09 0.15 4 1 13 217 0 0 select a.schema, a.name, b.name, b.eventid from system.aq$_queues b, system.aq$_queue_tables a, sys.aq$_queue_table_affinities t where a.objno = b.table_objno and t.table_objno = b.table_objno and bitand(b.properties, 512) = 512 and t.owner_instance = :1 2003-SEP-30 08:57:25 0 SELECT 1 13 217 0 0 13660 776 4732 CHOOSE 792D9B08 analyzed  
XDB 10 0.58 1.32     8 192 0 1 BEGIN
IF (xdb.DBMS_XDBZ.is_hierarchy_enabled(sys.dictionary_obj_owner, sys.dictionary_obj_name)) THEN
xdb.XDB_PITRIG_PKG.pitrig_truncate(sys.dictionary_obj_owner, sys.dictionary_obj_name);
END IF;
EXCEPTION
WHEN OTHERS THEN
null;
END;		 2003-SEP-30 12:00:53 0 PL/SQL 10 81 1929 0 10 10722 500 260 CHOOSE 79038BAC not analyzed  
SYS 1 0.14 0.10 7 1 19 145 1 12 select u.name, o.name, trigger$.sys_evts, trigger$.type# from obj$ o, user$ u, trigger$ where (bitand(trigger$.property, 8) = 8) and (bitand(trigger$.property, 16) != 16) and trigger$.obj# = o.obj# and o.owner# = u.user# order by o.obj# 2003-SEP-30 08:57:25 0 SELECT 1 19 145 1 12 15175 756 5484 CHOOSE 792976C0 analyzed  
SYS 1 0.06 0.09 4 0 8 130 0 1 select jf.flaglength, js.siglength, jm.methodlength, jc.ownerlength, jc.classlength, jm.cookiesize from triggerjavaf$ jf, triggerjavas$ js, triggerjavac$ jc, triggerjavam$ jm where jf.obj#=:1 and jf.obj#=js.obj# and js.obj#=jc.obj# and jc.obj#=jm.obj# 2003-SEP-30 08:57:26 0 SELECT 1 8 130 0 1 15696 900 5820 CHOOSE 7926F03C analyzed  
SYS 3 1.58 0.23 0 1 73 114 0 0 select file#, block#, ts# from seg$ where type# = 3 2003-SEP-30 08:57:19 0 SELECT 3 219 342 0 0 6856 688 1920 CHOOSE 79328EA0 analyzed  
XDB 10 0.28 0.67 57 6 3 98 1 1 SELECT COUNT(*) FROM ALL_POLICIES V WHERE V.OBJECT_OWNER = :b1 AND V.OBJECT_NAME = :b2 AND POLICY_NAME LIKE '%xdbrls%' 2003-SEP-30 12:00:53 0 SELECT 7 39 989 10 10 232061 832 71208 CHOOSE 79032D18 analyzed  
SYS 1 0.04 0.06 2 1 6 82 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)) 2003-SEP-30 08:57:25 0 SELECT 1 6 82 0 0 10138 572 3308 CHOOSE 792A68FC analyzed  
SYS 643 0.30 34.96 6 2 0 79 0 4 select t.schema, t.name, t.flags, q.name from system.aq$_queue_tables t, sys.aq$_queue_table_affinities aft, system.aq$_queues q where aft.table_objno = t.objno and aft.owner_instance = :1 and q.table_objno = t.objno and q.usage = 0 and bitand(t.flags, 4+16+32+64+128+256) = 0 for update of t.name, aft.table_objno skip locked 2003-SEP-30 08:57:52 0 SELECT 643 41 51244 0 2572 16521 776 8596 CHOOSE 791FB2BC analyzed  
SYS 1 0.01 0.05 1 0 2 76 0 1 update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,order$=:6,cache=:7,highwater=:8,audit$=:9,flags=:10 where obj#=:1 2003-SEP-30 10:14:35 0 UPDATE 1 2 76 0 1 11358 708 3612 CHOOSE 7919BC9C analyzed  
SYS 1 0.01 0.05 1 0 2 71 0 0 delete from error$ where obj#=:1 2003-SEP-30 14:38:05 0 DELETE 1 2 71 0 0 7493 528 2856 CHOOSE 78D7DB24 analyzed  
SYS 1 0.04 0.05 2 0 5 70 0 3 select gname,pname,stmt_type,check_opt,enable_flag,pfschma,ppname,pfname,decode(ptype,null,0,ptype) from rls$ where obj#=:1 2003-SEP-30 08:57:27 0 SELECT 1 5 70 0 3 10276 1068 3644 CHOOSE 7922AE50 analyzed  
SYS 1 0.04 0.04 0 0 6 64 0 0 select /*+RULE */ user, object_type from user_objects where object_name = 'V$SQLAREA' and object_type <> 'TABLE PARTITION'
 2003-SEP-30 12:12:22 0 SELECT 1 6 64 0 0 39056 640 8732 RULE 78E7E578 analyzed  
XDB 10 0.01 0.37 14 2 0 54 1 1 SELECT COUNT(*) FROM USER_POLICIES V WHERE V.OBJECT_NAME = :b1 AND POLICY_NAME LIKE '%xdbrls%' 2003-SEP-30 12:00:53 0 SELECT 7 2 546 10 10 46136 616 12484 CHOOSE 79032B24 analyzed  
SYS 1 0.04 0.04 0 0 6 53 0 1 select /*+RULE */ object_type from all_objects where owner = 'SYS' and object_name = 'V_$SQLAREA' and object_type <> 'TABLE PARTITION'
 2003-SEP-30 12:12:22 0 SELECT 1 6 53 0 1 144724 792 24276 RULE 78E62220 analyzed  
SYS 1 0.02 0.03 4 0 3 46 1 0 select job, nvl2(last_date, 1, 0) from sys.job$ where next_date < :1 and (field1 = :2 or (field1 = 0 and 'Y' = :3)) order by next_date, job 2003-SEP-30 08:57:27 0 SELECT 1 3 46 1 0 10574 688 3332 CHOOSE 7920D9BC analyzed  
SYS 1 0.01 0.03 1 0 1 41 0 0 SELECT apply#, apply_name FROM sys.streams$_apply_process WHERE status = :1 ORDER BY apply# 2003-SEP-30 08:57:25 0 SELECT 1 1 41 0 0 7946 648 2836 CHOOSE 7929BC00 analyzed  
SYS 6 0.05 0.16 4 1 1 39 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# 2003-SEP-30 08:57:24 0 SELECT 6 7 234 0 0 16284 760 5832 CHOOSE 792F2EF0 analyzed  
SYS 1 0.00 0.03 1 0 0 39 0 1 select blocks,maxblocks,grantor#,priv1,priv2,priv3 from tsq$ where ts#=:1 and user#=:2 2003-SEP-30 12:00:54 0 SELECT 1 0 39 0 1 9019 908 2312 CHOOSE 78F9F654 analyzed  
SYS 1 0.01 0.02 1 0 1 31 0 0 SELECT capture#, capture_name FROM sys.streams$_capture_process WHERE status = :1 ORDER BY capture# 2003-SEP-30 08:57:25 0 SELECT 1 1 31 0 0 7514 648 2820 CHOOSE 792A2400 analyzed  
SYS 1 0.12 0.02 12 2 17 30 0 1 select c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user# 2003-SEP-30 12:00:55 0 SELECT 1 17 30 0 1 15144 656 6696 CHOOSE 78F29E00 analyzed  
SYS 1 0.05 0.02 0 1 7 30 0 1 select /*+RULE */ * from global_name
 2003-SEP-30 12:12:21 0 SELECT 1 7 30 0 1 7474 572 9736 RULE 78F92CCC analyzed  
SYS 2 0.03 0.04 241 0 2 29 0 1 insert into lob$(obj#, intcol#, col#, lobj#, part#, ind#, ts#, file#, block#, chunk, pctversion$, flags, property, retention, freepools) values (:1, :2, :3, :4, 0, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14) 2003-SEP-30 14:38:04 0 INSERT 2 4 59 0 2 13781 808 2236 CHOOSE 78D9088C analyzed  
SYS 9 0.04 0.17 14 0 0 28 0 1 insert into ccol$(con#,obj#,intcol#,pos#,col#) values(:1,:2,:3,decode(:4,0,null,:4),:5) 2003-SEP-30 12:00:55 0 INSERT 8 5 256 0 9 11856 648 2116 CHOOSE 78F59534 analyzed  
SYS 1 0.01 0.02 3 1 2 28 0 0 select q.eventid, s.destination, q.name, t.schema, s.disabled from system.aq$_queues q, sys.aq$_schedules s, system.aq$_queue_tables t where q.oid = s.oid and q.table_objno = t.objno and bitand(q.properties, 512) = 512 2003-SEP-30 08:57:25 0 SELECT 1 2 28 0 0 13315 816 4896 CHOOSE 792B61BC analyzed  
SYS 1 0.02 0.02 1 0 3 26 0 0 select pval2 from sys.aux_stats$ where sname = 'SYSSTATS_INFO' and pname = 'STATUS' 2003-SEP-30 08:57:24 0 SELECT 1 3 26 0 0 6608 568 2308 CHOOSE 792E6A14 analyzed  
SYS 2 0.01 0.04 4 0 0 26 0 0 delete from dependency$ where d_obj#=:1 2003-SEP-30 12:01:18 0 DELETE 8 1 52 0 0 17284 1040 4576 CHOOSE 78F12478 analyzed  
SYS 9 0.01 0.15 241 0 0 25 0 1 insert into icol$(obj#,bo#,intcol#,pos#,segcol#,segcollength,offset,col#,spare1,spare2)values(:1,:2,:3,:4,0,0,0,:5,:6,:7) 2003-SEP-30 12:00:54 0 INSERT 10 1 227 0 9 12002 668 2072 CHOOSE 78F89618 analyzed  
SYS 8 0.00 0.14 241 0 0 24 0 1 insert into tab$(obj#,ts#,file#,block#,bobj#,tab#,intcols,kernelcols,clucols,audit$,flags,pctfree$,pctused$,initrans,maxtrans,rowcnt,blkcnt,empcnt,avgspc,chncnt,avgrln,analyzetime,samplesize,cols,property,degree,instances,dataobj#,avgspc_flb,flbcnt,trigflag,spare1,spare6)values(:1,:2,:3,:4,decode(:5,0,null,:5),decode(:6,0,null,:6),:7,:8,decode(:9,0,null,:9),:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,decode(:26,1,null,:26),decode(:27,1,null,:27),:28,:29,:30,:31,:32,:33) 2003-SEP-30 12:00:54 0 INSERT 8 0 199 0 8 24927 1288 3640 CHOOSE 78F7C458 analyzed  
SYS 10 0.01 0.16 241 0 0 24 0 1 insert into ind$(bo#,obj#,ts#,file#,block#,intcols,type#,flags,property,pctfree$,initrans,maxtrans,blevel,leafcnt,distkey,lblkkey,dblkkey,clufac,cols,analyzetime,samplesize,dataobj#,degree,instances,rowcnt,pctthres$,indmethod#,trunccnt,spare1,spare4,spare2,spare6)values(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,decode(:23,1,null,:23),decode(:24,1,null,:24),:25, :32*256+:26,:27,:28,:29,:30,:31,:33) 2003-SEP-30 12:00:54 0 INSERT 10 1 240 0 10 22522 1228 3172 CHOOSE 78F868A4 analyzed  
SYS 1 0.04 0.02 2 1 5 23 0 4 select table_objno, primary_instance, secondary_instance, owner_instance from sys.aq$_queue_table_affinities for update SKIP LOCKED 2003-SEP-30 08:57:52 0 SELECT 1 5 23 0 4 7179 748 3528 CHOOSE 791FD818 analyzed  
SYS 4 0.02 0.06 1 0 0 22 0 0 select parttype, partcnt, partkeycols, flags, defts#, defpctfree, defpctused, definitrans, defmaxtrans, deftiniexts, defextsize, defminexts, defmaxexts, defextpct, deflists, defgroups, deflogging, spare1, mod(spare2, 256) subparttype, mod(trunc(spare2/256), 256) subpartkeycols, mod(trunc(spare2/65536), 65536) defsubpartcnt, mod(trunc(spare2/4294967296), 256) defhscflags from partobj$ where obj# = :1 2003-SEP-30 08:57:26 0 SELECT 4 3 88 0 0 14235 1848 3484 CHOOSE 7924743C analyzed  
SYS 27 1.10 0.42     5 22 0 1 BEGIN
/* NOP UNLESS A TABLE OBJECT */
IF dictionary_obj_type = 'TABLE' AND sys.dbms_cdc_publish.active > 0
THEN
sys.dbms_cdc_publish.change_table_trigger(dictionary_obj_owner,dictionary_obj_name,sysevent);
END IF;
END;		 2003-SEP-30 12:00:51 0 PL/SQL 27 153 618 0 27 9641 500 260 CHOOSE 790BCAD8 not analyzed  
SYS 2 0.05 0.03 0 0 3 21 0 0 select /*+rule */ 'DBA' from session_roles where role in ('DBA', 'SELECT_CATALOG_ROLE', 'BENTHIC_USE_DBA_VIEWS')
 2003-SEP-30 10:42:21 0 SELECT 2 7 43 0 0 14594 576 4460 RULE 7915F86C analyzed  
SYS 6 0.02 0.08 5 2 0 19 0 0 delete from jijoin$ where obj# in ( select obj# from jijoin$ where tab1obj# = :1 or tab2obj# = :1) 2003-SEP-30 12:01:19 0 DELETE 6 3 116 0 0 15327 552 5756 CHOOSE 78EC10F4 analyzed  
SYS 8 0.05 0.11 14 0 0 19 0 1 insert into cdef$(obj#,con#,type#,intcols,condlength,condition,robj#,rcon#,match#,refact,enabled,cols,defer,mtime,spare1)values(:1,:2,:3,decode(:4,0,null,:4),decode(:5,0,null,:5),:6,decode(:7,0,null,:7),decode(:8,0,null,:8),decode(:9,0,null,:9),decode(:10,0,null,:10), decode(:11,0,null,:11),:12, decode(:13,0,null,:13),:14,:15) 2003-SEP-30 12:00:55 0 INSERT 8 7 157 0 8 20729 988 19996 CHOOSE 78F4F444 analyzed  
SYS 4 0.01 0.05 2 0 0 18 0 0 select n.intcol# from ntab$ n, col$ c where n.obj#=:1 and c.obj#=:1 and c.intcol#=n.intcol# and bitand(c.property, 32768)!=32768 2003-SEP-30 14:38:13 0 SELECT 4 1 72 0 0 12850 612 3072 CHOOSE 78CE03BC analyzed  
SYS 6 0.04 0.07 24 0 0 17 0 1 insert into procedureinfo$(obj#,procedure#,overload#,procedurename,properties,itypeobj#) values (:1,:2,:3,:4,:5,:6) 2003-SEP-30 14:38:05 0 INSERT 1 5 106 0 6 9908 648 1892 CHOOSE 78D53B30 analyzed  
SYS 2 0.01 0.02 3 0 0 17 0 0 delete from access$ where d_obj#=:1 2003-SEP-30 14:38:06 0 DELETE 2 1 35 0 0 7084 528 2832 CHOOSE 78D39E30 analyzed  
SYS 1 0.01 0.01 0 1 2 17 0 0 SELECT 0 FROM PLAN_TABLE WHERE 1=0 2003-SEP-30 14:38:03 0 SELECT 1 2 17 0 0 5351 568 1660 CHOOSE 78E1E08C analyzed  
SYS 1 0.01 0.01 2 1 2 16 0 1 select TOTAL from SYS.ID_GENS$ 2003-SEP-30 08:57:22 0 SELECT 1 2 16 0 1 4591 568 1688 CHOOSE 7931E1F0 analyzed  
SYS 1 0.01 0.01 2 1 1 16 0 0 select location_name from loc$ 2003-SEP-30 08:57:24 0 SELECT 1 1 16 0 0 5231 568 2152 CHOOSE 792DF0C4 analyzed  
SYS 6 0.02 0.07 3 0 0 16 0 0 delete from jirefreshsql$ where iobj# in ( select iobj# from jirefreshsql$ where tobj# = :1) 2003-SEP-30 12:01:19 0 DELETE 6 3 97 0 0 14433 532 9816 CHOOSE 78EBA1B4 analyzed  
SYS 1 0.02 0.01 2 1 3 16 0 1 select migrated from MIGRATE$ 2003-SEP-30 08:57:23 0 SELECT 1 3 16 0 1 5354 568 1688 CHOOSE 7931F220 analyzed  
SYS 1 0.04 0.01 5 1 5 16 1 34 select obj#, intcol# from sys.LOGMNR_INTERESTING_COLS order by obj#, intcol# 2003-SEP-30 08:57:23 0 SELECT 1 5 16 1 34 5901 628 2200 CHOOSE 7930E7B8 analyzed  
SYS 4 0.03 0.04 13 0 1 16 0 1 insert into settings$(obj#, param, value) values (:1, :2, :3) 2003-SEP-30 14:38:06 0 INSERT 2 4 64 0 4 7090 588 1676 CHOOSE 78D430B4 analyzed  
SYS 2 0.01 0.02 5 0 0 16 0 1 insert into procedure$(obj#,audit$,options) values (:1,:2,:3) 2003-SEP-30 14:38:05 0 INSERT 2 1 32 0 2 7494 588 1708 CHOOSE 78D63974 analyzed  
SYS 9 0.06 0.10 2 0 0 15 1 4 select privilege#,level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with (grantee#=:1 or grantee#=1) and privilege#>0 2003-SEP-30 10:14:35 0 SELECT 9 8 140 12 38 13700 652 4392 CHOOSE 791944F0 analyzed  
SYS 67 0.01 0.69 5 1 0 15 0 1 UPDATE SMON_SCN_TIME SET SCN_WRP=:1, SCN_BAS=:2, TIME_MP=:3, TIME_DP=:4 WHERE TIME_MP = :5 AND THREAD = :6 AND ROWNUM <= 1 2003-SEP-30 08:57:22 0 UPDATE 67 1 1014 0 67 10269 628 3844 CHOOSE 7934A068 analyzed  
SYS 6 0.02 0.06 1 0 0 15 0 0 DELETE FROM sys.sumdelta$ sd WHERE sd.tableobj# = :1 2003-SEP-30 12:01:18 0 DELETE 6 3 90 0 0 8179 528 3096 CHOOSE 78EFDBE8 analyzed  
SYS 1 0.01 0.01 0 0 1 14 0 1 select /*+RULE */ 'SYNONYM' ot from all_synonyms where owner = 'PUBLIC' and synonym_name = 'V$SQLAREA'
 2003-SEP-30 12:12:22 0 SELECT 1 1 14 0 1 35388 608 12452 RULE 78E73F70 analyzed  
SYS 6 0.01 0.06 1 0 0 13 0 0 DELETE FROM sys.sumpartlog$ sp WHERE sp.bo# = :1 2003-SEP-30 12:01:18 0 DELETE 6 2 82 0 0 8023 528 4652 CHOOSE 78EF6198 analyzed  
SYS 38 0.05 0.34 241 0 0 13 0 1 insert into col$(obj#,name,intcol#,segcol#,type#,length,precision#,scale,null$,offset,fixedstorage,segcollength,deflength,default$,col#,property,charsetid,charsetform,spare1,spare2,spare3)values(:1,:2,:3,:4,:5,:6,decode(:7,0,null,:7),decode(:5,2,decode(:8,-127/*MAXSB1MINAL*/,null,:8),178,:8,179,:8,180,:8,181,:8,182,:8,183,:8,231,:8,null),:9,0,:10,:11,decode(:12,0,null,:12),:13,:14,:15,:16,:17,:18,:19,:20) 2003-SEP-30 12:00:55 0 INSERT 8 7 501 0 38 21845 1148 19880 CHOOSE 78F5F3DC analyzed  
SYS 6 0.02 0.05 2 0 0 13 0 0 delete from icoldep$ where obj# in (select obj# from ind$ where bo#=:1) 2003-SEP-30 12:01:19 0 DELETE 6 3 79 0 0 10500 532 4336 CHOOSE 78EC6004 analyzed  
SYS 67 0.14 0.62 5 1 0 13 0 1 SELECT MIN(TIME_MP), COUNT(*) FROM SMON_SCN_TIME WHERE THREAD = :1 2003-SEP-30 08:57:22 0 SELECT 67 19 907 0 67 7351 648 2332 CHOOSE 79358388 analyzed  
SYS 70 0.36 0.62 14 0 0 13 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# 2003-SEP-30 08:57:14 0 SELECT 70 50 910 70 256 13525 1132 5524 CHOOSE 7935B800 analyzed  
SYS 12 0.00 0.11 2 0 0 13 0 1 delete from col$ where obj#=:1 2003-SEP-30 12:01:19 0 DELETE 12 0 156 0 12 9907 528 3912 CHOOSE 78ED04A4 analyzed  
SYS 11 0.01 0.10 15 0 0 13 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 2003-SEP-30 08:57:26 0 SELECT 11 2 144 11 0 33483 1148 9444 CHOOSE 7927BFAC analyzed  
SYS 65 0.06 0.53 0 1 0 12 0 0 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 2003-SEP-30 09:02:32 0 SELECT 65 8 780 0 0 10148 752 2856 CHOOSE 791C3438 analyzed  
SYS 4 0.01 0.03 1 0 0 12 0 0 delete from superobj$ where subobj# = :1 2003-SEP-30 14:38:05 0 DELETE 4 1 51 0 0 7845 528 3188 CHOOSE 78D7F954 analyzed  
SYS 12 0.00 0.09 4 0 0 11 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) 2003-SEP-30 12:01:19 0 DELETE 12 0 134 0 12 13724 688 5964 CHOOSE 78E9085C analyzed  
SYS 14 0.02 0.11 4 0 0 11 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) 2003-SEP-30 12:00:54 0 UPDATE 14 3 156 0 14 17712 908 5120 CHOOSE 78FB66FC analyzed  
SYS 1 0.00 0.01 0 0 0 11 0 1 SELECT /*+RULE */ TABLE_OWNER, TABLE_NAME, DB_LINK FROM ALL_SYNONYMS WHERE OWNER = 'PUBLIC' AND SYNONYM_NAME = 'V$SQLAREA'
2003-SEP-30 12:12:22 0 SELECT 1 0 11 0 1 36457 728 12828 RULE 78E6AC64 analyzed  
SYS 47 0.06 0.34 218 0 0 10 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) 2003-SEP-30 14:38:06 0 INSERT 1 9 494 0 47 17319 988 18876 CHOOSE 78D4B530 analyzed  
SYS 8 0.01 0.06 2 0 0 10 0 1 update con$ set con#=:3 where owner#=:1 and name=:2 2003-SEP-30 12:00:54 0 UPDATE 8 2 87 0 8 8140 568 3120 CHOOSE 78F8ED18 analyzed  
SYS 35 1.13 0.26 3 0 4 10 0 1 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# 2003-SEP-30 12:00:52 0 SELECT 35 157 380 0 58 8913 748 3312 CHOOSE 7906431C analyzed  
SYS 6 0.00 0.04 2 0 0 10 0 0 delete ntab$ where obj#=:1 2003-SEP-30 12:01:19 0 DELETE 6 0 63 0 0 9179 528 3652 CHOOSE 78EA3450 analyzed  
SYS 6 0.01 0.04 2 0 0 10 0 0 delete coltype$ where obj#=:1 2003-SEP-30 12:01:19 0 DELETE 6 1 65 0 0 8702 528 3644 CHOOSE 78EA908C analyzed  
SYS 5 0.04 0.03 2 0 1 10 0 1 select node,owner,name from syn$ where obj#=:1 2003-SEP-30 10:14:36 0 SELECT 5 6 50 0 5 7591 708 2020 CHOOSE 791818DC analyzed  
SYS 6 0.00 0.04 2 0 0 10 0 1 delete from ccol$ where obj#=:1 2003-SEP-30 12:01:19 0 DELETE 6 0 60 0 6 8856 528 3692 CHOOSE 78EB56DC analyzed  
SYS 6 0.02 0.04 2 0 0 9 0 0 delete com$ where obj#=:1 2003-SEP-30 12:01:18 0 DELETE 6 3 56 0 0 7218 528 2804 CHOOSE 78F29754 analyzed  
SYS 8 0.00 0.05 7 0 0 9 0 0 select u2.name, o2.name from ind$ i, obj$ o1, obj$ o2, user$ u1, user$ u2 where i.bo# = o1.obj# and o1.owner#=u1.user# and i.obj#=o2.obj# and o2.owner#=u2.user# and u1.name=:1 and o1.name=:2 and i.type#=9 2003-SEP-30 12:00:54 0 SELECT 8 0 73 0 0 21830 684 9216 CHOOSE 78FBF3A4 analyzed  
SYS 3 0.03 0.02 1 0 1 9 0 1 select increment$,minvalue,maxvalue,cycle#,order$,cache,highwater,audit$,flags from seq$ where obj#=:1 2003-SEP-30 08:57:23 0 SELECT 2 4 29 0 3 9167 1068 2268 CHOOSE 7931EF2C analyzed  
SYS 6 0.02 0.04 3 0 0 9 0 0 delete from hist_head$ where obj# = :1 2003-SEP-30 12:01:18 0 DELETE 6 3 54 0 0 8151 528 4664 CHOOSE 78F1B6B8 analyzed  
SYS 2 0.00 0.01 154 0 0 9 1 0 SELECT l.addr, l.kaddr, l.type, l.id1, l.id2, ctime, block,
DECODE(l.lmode, 0,'NONE',1,'NULL',2,'ROW SHARE',3,'ROW EXCLUSIVE',4,'SHARE',5,'SHARE ROW EXCLUSIVE',6,'EXCLUSIVE','?') mode_held,
DECODE(l.request,0,'NONE',1,'NULL',2,'ROW SHARE',3,'ROW EXCLUSIVE',4,'SHARE',5,'SHARE ROW EXCLUSIVE',6,'EXCLUSIVE','?') mode_requested
FROM v$lock l
WHERE l.sid = :sid
ORDER BY l.addr, l.kaddr		 2003-SEP-30 12:16:12 0 SELECT 2 0 19 2 0 55545 1112 6004 CHOOSE 78DB77A8 analyzed  
SYS 20 0.01 0.13 0 0 0 9 0 1 insert into seg$ (file#,block#,type#,ts#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts,lists,groups,cachehint,bitmapranges,scanhint, hwmincr, spare1) values (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,0,0,:16,DECODE(:17,0,NULL,:17)) 2003-SEP-30 12:00:54 0 INSERT 20 2 192 0 20 14631 888 2492 CHOOSE 78FA5654 analyzed  
SYS 6 0.00 0.03 2 0 0 8 0 1 delete from con$ where owner#=:1 and name=:2 2003-SEP-30 12:01:19 0 DELETE 6 0 48 0 6 8457 548 3508 CHOOSE 78E8A068 analyzed  
SYS 8 0.01 0.05 5 0 0 8 0 1 insert into con$(owner#,name,con#)values(:1,:2,:3) 2003-SEP-30 12:00:55 0 INSERT 8 2 66 0 8 9187 588 1856 CHOOSE 78F36BC4 analyzed  
SYS 22 0.00 0.12 160 0 0 8 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) 2003-SEP-30 12:00:54 0 INSERT 22 0 177 0 22 15334 868 2308 CHOOSE 78FA77E4 analyzed  
SYS 6 0.02 0.03 2 1 0 8 0 0 select 1 from sys.cdc_change_tables$ where source_schema_name = :1 and source_table_name = :2 and bitand(mvl_flag, 128)=128 2003-SEP-30 12:01:18 0 SELECT 6 3 50 0 0 7259 608 1892 CHOOSE 78F06024 analyzed  
SYS 6 0.04 0.03 4 1 0 8 0 0 select obj# from oid$ where user#=:1 and oid$=:2 2003-SEP-30 08:57:26 0 SELECT 3 5 49 0 3 7545 608 1740 CHOOSE 792523A4 analyzed  
SYS 2 0.00 0.01 2 0 0 8 0 1 update col$ set intcol#=:3,segcol#=:4,type#=:5,length=:6,precision#=decode(:7,0,null,:7),scale=decode(:5,2,decode(:8,-127/*MAXSB1MINAL*/,null,:8),178,:8,179,:8,180,:8,181,:8,182,:8,183,:8,231,:8,null),null$=:9,fixedstorage=:10,segcollength=:11,col#=:12,property=:13,charsetid=:14,charsetform=:15,spare1=:16,spare2=:17,spare3=:18,deflength=decode(:19,0,null,:19),default$=:20 where obj#=:1 and name=:2 2003-SEP-30 14:38:05 0 UPDATE 1 0 16 0 2 22741 1128 40096 CHOOSE 78D6DD94 analyzed  
SYS 6 0.00 0.04 2 0 0 8 0 0 delete refcon$ where obj#=:1 2003-SEP-30 12:01:19 0 DELETE 6 0 52 0 0 8809 528 3572 CHOOSE 78E9569C analyzed  
SYS 6 0.00 0.03 2 0 0 8 0 1 delete from ind$ where bo#=:1 2003-SEP-30 12:01:19 0 DELETE 6 0 48 0 6 8110 528 3824 CHOOSE 78EAD160 analyzed  
SYS 1 0.00 0.01 1 0 0 8 0 1 select ownername, classname from triggerjavac$ where obj#=:1 2003-SEP-30 08:57:26 0 SELECT 1 0 8 0 1 7257 648 1808 CHOOSE 79263868 analyzed  
SYS 6 0.01 0.04 1 0 0 8 0 0 select master from sys.mlog$ where master = :2 and mowner = :1 2003-SEP-30 12:01:18 0 SELECT 6 2 52 0 0 7395 608 2052 CHOOSE 78F047E4 analyzed  
SYS 12 0.01 0.07 2 1 0 8 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' 2003-SEP-30 08:57:55 0 SELECT 12 2 101 0 0 12311 1288 2868 CHOOSE 791CB34C analyzed  
SYS 4 0.03 0.02 2 0 1 8 0 1 select audit$,properties from type_misc$ where obj#=:1 2003-SEP-30 08:57:52 0 SELECT 4 4 34 0 4 7343 648 1976 CHOOSE 791ED928 analyzed  
SYS 18 0.00 0.10 1 0 0 8 0 1 update tsq$ set blocks=:3,maxblocks=:4,grantor#=:5,priv1=:6,priv2=:7,priv3=:8 where ts#=:1 and user#=:2 2003-SEP-30 12:00:55 0 UPDATE 18 0 145 0 18 10716 668 4064 CHOOSE 78F35358 analyzed  
SYS 6 0.00 0.03 2 0 0 8 0 1 delete from icol$ where bo#=:1 2003-SEP-30 12:01:19 0 DELETE 6 0 50 0 6 8115 528 3564 CHOOSE 78ECCAF8 analyzed  
SYS 6 0.00 0.03 5 0 0 7 0 1 select c.owner#,c.name,c.con# from con$ c,cdef$ d where d.obj#=:1 and d.con#=c.con# 2003-SEP-30 12:01:18 0 SELECT 6 0 42 0 6 12504 712 3388 CHOOSE 78F32E98 analyzed  
SYS 14 0.06 0.07 118 0 0 7 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) 2003-SEP-30 14:38:06 0 INSERT 2 9 105 0 14 10175 668 1832 CHOOSE 78D3641C analyzed  
SYS 4 0.04 0.02 1 0 1 7 0 1 select metadata from kopm$ where name='DB_FDO' 2003-SEP-30 08:57:23 0 SELECT 4 5 31 0 4 6568 568 2132 CHOOSE 7930F8AC analyzed  
SYS 54 0.01 0.28 2 0 0 7 0 4 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 2003-SEP-30 08:57:15 0 SELECT 30 2 410 0 248 12319 1368 2956 CHOOSE 7934FEA8 analyzed  
SYS 12 0.00 0.06 2 0 0 7 0 0 delete from cdef$ where obj#=:1 2003-SEP-30 12:01:19 0 DELETE 12 0 92 0 6 10160 528 3876 CHOOSE 78EB87E8 analyzed  
SYS 17 0.03 0.08 5 1 0 7 1 13 select distinct(-privilege#),nvl(option$,0) from sysauth$ where grantee#=:1 and privilege#<0 2003-SEP-30 10:14:36 0 SELECT 17 4 122 17 233 7533 648 2360 CHOOSE 7918E890 analyzed  
SYS 35 0.48 0.18 3 0 1 7 0 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# 2003-SEP-30 12:00:51 0 SELECT 35 67 263 0 56 8869 748 3312 CHOOSE 7906E088 analyzed  
SYS 35 0.28 0.18 3 0 1 7 0 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# 2003-SEP-30 12:00:51 0 SELECT 35 39 259 0 46 8865 748 3312 CHOOSE 790BA620 analyzed  
SYS 2572 0.01 12.39 2 1 0 7 0 1 select t.name, (select owner_instance from sys.aq$_queue_table_affinities where table_objno = t.objno) from system.aq$_queue_tables t where t.name = :1 and t.schema = :2 for update skip locked 2003-SEP-30 08:57:52 0 SELECT 643 2 18167 0 2572 11585 672 4948 CHOOSE 791EF5B0 analyzed  
SYS 70 0.39 0.36 4 0 0 7 0 2 select order#,columns,types from access$ where d_obj#=:1 2003-SEP-30 08:57:14 0 SELECT 70 54 525 0 145 7421 708 3156 CHOOSE 79359BB0 analyzed  
SYS 6 0.00 0.02 2 0 0 6 0 1 delete from tab$ where obj#=:1 2003-SEP-30 12:01:19 0 DELETE 6 0 36 0 6 7831 528 3868 CHOOSE 78EAFFD4 analyzed  
SYS 1 0.00 0.00 5 0 0 6 0 1 SELECT COUNT(1) FROM user_objects WHERE object_type = :t AND object_name = :n AND status = 'VALID' 2003-SEP-30 14:38:08 0 SELECT 1 0 6 0 1 40491 620 9196 CHOOSE 78CE018C analyzed  
SYS 52 0.00 0.22 0 0 0 6 0 1 update seg$ set type#=:4,blocks=:5,extents=:6,minexts=:7,maxexts=:8,extsize=:9,extpct=:10,user#=:11,iniexts=:12,lists=decode(:13, 65535, NULL, :13),groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17,0,NULL,:17) where ts#=:1 and file#=:2 and block#=:3 2003-SEP-30 12:00:55 0 UPDATE 52 0 325 0 52 16556 908 5672 CHOOSE 78F9FEA0 analyzed  
SYS 17 0.00 0.07 5 0 0 6 1 0 select col#,intcol#,ntab# from ntab$ where obj#=:1 order by intcol# asc 2003-SEP-30 08:57:25 0 SELECT 17 0 104 17 0 8684 708 2496 CHOOSE 792D6DDC analyzed  
SYS 12 0.00 0.05 0 0 0 6 0 1 delete from seg$ where ts#=:1 and file#=:2 and block#=:3 2003-SEP-30 12:01:19 0 DELETE 12 0 72 0 12 8289 568 3736 CHOOSE 78FB98C4 analyzed  
SYSTEM 25 0.16 0.11 0 0 0 6 0 1 SELECT banner FROM v$version WHERE ROWNUM = 1 2003-SEP-30 10:14:19 0 SELECT 25 22 155 0 25 19112 1156 1400 CHOOSE 791B82FC analyzed  
SYS 6 0.01 0.03 1 0 0 6 0 0 DELETE FROM sys.snap_loadertime$ sd WHERE sd.tableobj# = :1 2003-SEP-30 12:01:18 0 DELETE 6 2 38 0 0 6873 528 2720 CHOOSE 78EEF2A8 analyzed  
SYS 1 0.00 0.00 0 0 0 6 4 1 SELECT s.username,
s.sid,
s.serial#,
s.status,
s.osuser,
s.machine,
s.terminal,
s.program,
TO_CHAR(s.logon_time, 'DD-MON-YYYY HH24:MI:SS'),
s.schemaname,
a.sql_text
FROM v$session s,
v$sqlarea a
WHERE s.sql_address = a.address (+) AND username IS NOT NULL AND status != 'KILLED'
ORDER BY s.sid
 2003-SEP-30 10:42:59 0 SELECT 1 0 6 4 1 88887 1188 12972 CHOOSE 7915B528 analyzed  
SYS 4 0.00 0.02 2 0 0 6 0 1 update tab$ set ts#=:2,file#=:3,block#=:4,bobj#=decode(:5,0,null,:5),tab#=decode(:6,0,null,:6),intcols=:7,kernelcols=:8,clucols=decode(:9,0,null,:9),audit$=:10,flags=:11,pctfree$=:12,pctused$=:13,initrans=:14,maxtrans=:15,rowcnt=:16,blkcnt=:17,empcnt=:18,avgspc=:19,chncnt=:20,avgrln=:21,analyzetime=:22,samplesize=:23,cols=:24,property=:25,degree=decode(:26,1,null,:26),instances=decode(:27,1,null,:27),dataobj#=:28,avgspc_flb=:29,flbcnt=:30,trigflag=:31,spare1=:32,spare2=decode(:33,0,null,:33),spare4=:34,spare6=:35 where obj#=:1 2003-SEP-30 14:38:05 0 UPDATE 4 0 25 0 4 27625 1328 10276 CHOOSE 78D71AF4 analyzed  
SYS 7 0.02 0.03 1 0 0 6 0 1 select count(*) from association$ where obj# = :1 2003-SEP-30 12:01:18 0 SELECT 7 3 45 0 7 7614 588 1564 CHOOSE 78F21010 analyzed  
SYS 6 0.01 0.03 1 0 0 6 0 0 select intcol# from ustats$ where obj# = :1 2003-SEP-30 12:01:18 0 SELECT 6 2 37 0 0 6736 588 1240 CHOOSE 78F23884 analyzed  
SYS 1 0.00 0.00 1 0 0 6 0 1 select flags from triggerjavaf$ where obj#=:1 2003-SEP-30 08:57:26 0 SELECT 1 0 6 0 1 6790 588 1716 CHOOSE 79266C0C analyzed  
SYS 6 0.01 0.03 1 0 0 6 0 0 delete from subcoltype$ where obj#=:1 2003-SEP-30 12:01:19 0 DELETE 6 1 40 0 0 7546 528 2900 CHOOSE 78EA2AA8 analyzed  
SYS 18 0.15 0.07 2 0 1 5 0 1 select cols,audit$,textlength,intcols,property,flags,rowid from view$ where obj#=:1 2003-SEP-30 10:14:36 0 SELECT 13 21 100 0 18 8544 948 2060 CHOOSE 7917BAC4 analyzed  
SYS 1 0.00 0.00 1 0 0 5 0 1 select methodname from triggerjavam$ where obj#=:1 2003-SEP-30 08:57:26 0 SELECT 1 0 5 0 1 6983 588 1716 CHOOSE 792603D8 analyzed  
SYS 8 0.04 0.03 5268 0 0 5 0 1 insert into idl_ub1$(obj#,part,version,piece#,length,piece) values(:1,:2,:3,:4,:5,:6) 2003-SEP-30 14:38:05 0 INSERT 5 6 45 0 8 8746 648 18212 CHOOSE 78D5A740 analyzed  
SYS 17 0.01 0.07 5 0 0 5 1 4 select col#,intcol#,toid,version#,packed,intcols,intcol#s,flags, synobj#, nvl(typidcol#, 0) from coltype$ where obj#=:1 order by intcol# desc 2003-SEP-30 08:57:24 0 SELECT 17 1 96 17 71 10794 1128 7036 CHOOSE 792E3B48 analyzed  
SYS 11 0.00 0.04 1 0 0 5 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 2003-SEP-30 08:57:26 0 SELECT 11 0 60 0 11 11480 1488 18704 CHOOSE 79280B20 analyzed  
SYS 6 0.00 0.02 3 0 0 5 0 1 select o.name, u.name from sys.obj$ o, sys.user$ u where u.user#=o.owner# and o.obj# = :1 2003-SEP-30 12:01:18 0 SELECT 6 0 30 0 6 11391 652 3336 CHOOSE 78F9FA7C analyzed  
SYS 17 0.01 0.06 5 0 0 5 1 1 select intcol#, toid, version#, intcols, intcol#s, flags, synobj# from subcoltype$ where obj#=:1 order by intcol# asc 2003-SEP-30 08:57:25 0 SELECT 17 1 87 17 18 9446 948 6720 CHOOSE 792E1E6C analyzed  
SYS 7 0.01 0.02 13 0 0 5 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 2003-SEP-30 12:01:18 0 SELECT 7 1 36 0 0 18135 1136 6440 CHOOSE 78F1A294 analyzed  
SYS 6 0.02 0.02 1 0 0 5 0 0 select 1 from sys.streams$_prepare_object where obj#= :1 and rownum= 1 2003-SEP-30 12:01:18 0 SELECT 6 3 32 0 0 6647 588 1236 CHOOSE 78EEE1B4 analyzed  
SYS 6 0.01 0.02 1 0 0 5 0 0 delete from opqtype$ where obj#=:1 2003-SEP-30 12:01:19 0 DELETE 6 1 30 0 0 7979 528 2904 CHOOSE 78E91734 analyzed  
SYS 1 0.00 0.00 1 0 0 5 0 1 select signature from triggerjavas$ where obj#=:1 2003-SEP-30 08:57:26 0 SELECT 1 0 5 0 1 6982 588 1716 CHOOSE 79265660 analyzed  
SYS 12 0.00 0.04 2 0 0 5 0 0 delete from objauth$ where obj#=:1 2003-SEP-30 12:01:19 0 DELETE 12 0 63 0 0 8607 528 3180 CHOOSE 78ED4170 analyzed  
SYS 17 0.00 0.06 5 0 0 5 1 0 select intcol#,type,flags,lobcol,objcol,extracol,schemaoid, elemnum from opqtype$ where obj# = :1 order by intcol# asc 2003-SEP-30 08:57:25 0 SELECT 17 0 87 17 2 9188 1008 2828 CHOOSE 792CA05C analyzed  
SYS 88 0.20 0.35 8 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,spare6, 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 2003-SEP-30 08:57:13 0 SELECT 38 28 506 240 159 28666 2596 10276 CHOOSE 79369294 analyzed  
SYS 17 0.01 0.07 5 0 0 5 1 0 select col#,intcol#,reftyp,stabid,expctoid from refcon$ where obj#=:1 order by intcol# asc 2003-SEP-30 08:57:25 0 SELECT 17 1 96 17 0 9019 828 2600 CHOOSE 792D0618 analyzed  
SYS 17 0.01 0.05 2 0 0 4 0 1 select limit# from profile$ where profile#=:1 and resource#=:2 and type#=:3 2003-SEP-30 10:14:35 0 SELECT 1 2 69 0 17 8444 628 2892 CHOOSE 7919AA88 analyzed  
SYS 35 0.14 0.11 3 0 0 4 0 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# 2003-SEP-30 12:00:52 0 SELECT 35 19 160 0 14 9004 748 3312 CHOOSE 7906D458 analyzed  
SYS 6 0.03 0.02     0 4 0 1 insert into idl_ub2$(obj#,part,version,piece#,length,piece) values(:1,:2,:3,:4,:5,:6) 2003-SEP-30 14:38:05 0 INSERT 3 4 28 0 6 8662 648 18212 CHOOSE 78D56220 error ORA-00932: inconsistent datatypes: expected - got CHAR
SYS 2 0.00 0.01 1 0 0 4 0 0 select log, sysdate, sysdate+1/86400, flag from sys.mlog$ where mowner = :1 and master = :2 for update 2003-SEP-30 14:38:13 0 SELECT 2 0 8 0 0 9018 788 4016 CHOOSE 78CA2B4C analyzed  
SYS 8 0.04 0.03 1 0 0 4 0 0 select 1 from sys.streams$_prepare_ddl p where ((p.global_flag = 1 and :1 is null) or (p.global_flag = 0 and p.usrid = :2)) and rownum = 1 2003-SEP-30 12:00:55 0 SELECT 8 5 39 0 0 8211 608 1320 CHOOSE 78F48884 analyzed  
SYS 6 0.00 0.02 2 0 0 4 0 0 delete lob$ where obj#=:1 2003-SEP-30 12:01:19 0 DELETE 6 0 27 0 0 8850 528 3728 CHOOSE 78E999FC analyzed  
SYS 159 0.05 0.50 2 0 0 4 0 1 select pos#,intcol#,col#,spare1,bo#,spare2 from icol$ where obj#=:1 2003-SEP-30 08:57:13 0 SELECT 35 7 729 0 206 8696 888 3160 CHOOSE 793663BC analyzed  
SYS 248 0.07 0.68 3 0 0 4 0 1 select intcol#,nvl(pos#,0),col# from ccol$ where con#=:1 2003-SEP-30 08:57:15 0 SELECT 27 10 999 0 252 8281 708 3000 CHOOSE 79343258 analyzed  
SYS 11 0.01 0.04 73 0 0 4 0 1 insert into access$(d_obj#,order#,columns,types) values (:1,:2,:3,:4) 2003-SEP-30 14:38:06 0 INSERT 2 2 54 0 11 14920 1216 3432 CHOOSE 78D3347C analyzed  
SYS 8 0.01 0.02 241 0 0 4 0 1 insert into idl_sb4$(obj#,part,version,piece#,length,piece) values(:1,:2,:3,:4,:5,:6) 2003-SEP-30 14:38:05 0 INSERT 5 2 32 0 8 8742 648 18212 CHOOSE 78D5EAB4 analyzed  
SYS 32 0.11 0.09 2 0 0 4 0 1 select audit$,options from procedure$ where obj#=:1 2003-SEP-30 08:57:25 0 SELECT 32 15 129 0 32 7268 648 1736 CHOOSE 792899C8 analyzed  
SYS 3 0.01 0.01 149 0 0 4 0 1 insert into idl_char$(obj#,part,version,piece#,length,piece) values(:1,:2,:3,:4,:5,:6) 2003-SEP-30 14:38:05 0 INSERT 3 2 12 0 3 8823 648 18212 CHOOSE 78D57480 analyzed  
SYS 6 0.00 0.02 4 0 0 4 0 0 select o.name from obj$ o, refcon$ r where o.oid$ = r.expctoid and r.obj# = :1 2003-SEP-30 12:01:19 0 SELECT 6 0 24 0 0 11779 592 11152 CHOOSE 78E99108 analyzed  
SYS 9 0.01 0.03 2 1 0 4 0 1 select value$ from props$ where name = 'GLOBAL_DB_NAME' 2003-SEP-30 08:57:32 0 SELECT 9 1 42 0 9 6052 568 9720 CHOOSE 79204904 analyzed  
SYS 7 0.03 0.02 0 0 0 4 1 1 SELECT t.sql_text FROM v$sqltext_with_newlines t WHERE t.address = (SELECT s.sql_address FROM sys.v_$session s WHERE s.sid = :sid) ORDER BY t.piece 2003-SEP-30 12:15:49 0 SELECT 7 4 30 7 9 52956 612 3652 CHOOSE 78DD853C analyzed  
SYS 9 0.04 0.02 2 0 0 3 0 0 select con# from con$ where owner#=:1 and name=:2 2003-SEP-30 12:00:54 0 SELECT 8 5 28 0 1 7934 608 1820 CHOOSE 78F942D8 analyzed  
SYS 1 0.00 0.00 2 0 0 3 0 0 delete from idl_char$ where obj#=:1 2003-SEP-30 14:38:05 0 DELETE 1 0 3 0 0 7728 528 3028 CHOOSE 78D83E74 analyzed  
SYS 11 0.00 0.02 1 0 0 3 0 1 select action# from trigger$ where obj# = :1 2003-SEP-30 08:57:26 0 SELECT 11 0 35 0 11 7525 588 1732 CHOOSE 79282BCC analyzed  
SYS 25 0.02 0.06 2 1 0 3 0 1 SELECT MINOR_VERSION FROM SYS.CDC_SYSTEM$ 2003-SEP-30 12:00:53 0 SELECT 7 3 91 0 25 5552 568 1688 CHOOSE 7904BB04 analyzed  
SYS 28 0.02 0.06 2 0 0 3 0 1 select file# from file$ where ts#=:1 2003-SEP-30 10:26:48 0 SELECT 28 3 90 0 28 7517 588 2792 CHOOSE 791ACA18 analyzed  
SYS 6 0.00 0.01 2 0 0 3 0 1 select nvl(spare3,0), property, flags from tab$ where obj# = :1 2003-SEP-30 12:01:18 0 SELECT 6 0 18 0 6 8608 708 2076 CHOOSE 78F0F750 analyzed  
SYS 17 0.00 0.04 5 0 0 3 1 25 select col#,intcol#,charsetid,charsetform from col$ where obj#=:1 order by intcol# asc 2003-SEP-30 08:57:25 0 SELECT 17 0 62 17 437 9015 768 2572 CHOOSE 792CD358 analyzed  
SYS 30 0.02 0.06 2 1 0 3 0 0 select value$ from sys.props$ where name = :1 2003-SEP-30 08:57:16 0 SELECT 5 3 92 0 21 16998 1764 29160 CHOOSE 793308F0 analyzed  
SYS 5 0.00 0.01 2 0 0 3 0 1 update ind$ set ts#=:2,file#=:3,block#=:4,intcols=:5,type#=:6,flags=:7,property=:8,pctfree$=:9,initrans=:10,maxtrans=:11,blevel=:12,leafcnt=:13,distkey=:14,lblkkey=:15,dblkkey=:16,clufac=:17,cols=:18,analyzetime=:19,samplesize=:20,dataobj#=:21,degree=decode(:22,1,null,:22),instances=decode(:23,1,null,:23),rowcnt=:24,pctthres$=:31*256+:25, indmethod#=:26, trunccnt=:27,spare1=:28,spare4=:29,spare2=:30,spare6=:32where obj#=:1 2003-SEP-30 14:38:13 0 UPDATE 5 0 15 0 5 23435 1188 8384 CHOOSE 78C9E710 analyzed  
SYS 2 0.00 0.00 5 0 0 3 1 13 select '"'||name||'" '||decode(type#,1,decode(charsetform,2,'NVARCHAR2('||decode(bitand(property,8388608),8388608,decode(spare3,0,1,spare3)||')','BYTECOUNT=>'||decode(length,0,1,length)||')'),'VARCHAR2('||decode(bitand(property,8388608),8388608,decode(spare3,0,1,spare3)||' char)',decode(length,0,1,length)||' byte)')),2,decode(scale,null,decode(precision#,null,'NUMBER','FLOAT('||precision#||')'),'NUMBER('||decode(precision#,null,'38', precision#)||','||scale||')'),8,'LONG',9,'VARCHAR('||(decode(length,0,1,length))||')',12,'DATE',23,'RAW('||length||')',24,'LONG RAW',69,'ROWID',96,decode(charsetform,2,'NCHAR('||decode(bitand(property,8388608),8388608,decode(spare3,0,1,spare3)||')','BYTECOUNT=>'||decode(length,0,1,length)||')'),'CHAR('||decode(bitand(property,8388608),8388608,decode(spare3,0,1,spare3)||' char)',decode(length,0,1,length)||' byte)')),97,'VARCHAR('||(decode(length,0,1,length))|| ')',105,'MLSLABEL',106,'MLSLABEL',112,decode(charsetform,2,'NCLOB','CLOB'),113,'BLOB',114,'BFILE',115,decode(charsetform,2,'NCFILE','CFILE'),178,'TIME('||scale||')',179,'TIME('||scale||') WITH TIME ZONE',180,'TIMESTAMP('||scale||')',181,'TIMESTAMP('||scale||') WITH TIME ZONE',231,'TIMESTAMP('||scale||') WITH LOCAL TIME ZONE',182,'INTERVAL YEAR('||precision#||') TO MONTH',183,'INTERVAL DAY('||precision#||') TO SECOND('||scale||')',208,'UROWID('||spare1||')','UNDEFINED')||decode(null$,0,'',' NOT NULL')||decode(bitand(property, 32), 0, ',', ' HIDDEN,'),name, type#, intcol#, null$, bitand(property, 32) from col$ where obj#=:1 and (bitand(property,32) = 0 or bitand(property, 4194304) <> 0) order by col# 2003-SEP-30 14:38:06 0 SELECT 2 0 6 2 26 38206 888 10556 CHOOSE 78D285CC analyzed  
SYS 1 0.00 0.00 3 0 0 3 0 1 SELECT NULL FROM OBJ$ WHERE NAME='MAP_FILE$' AND OWNER# = 0 2003-SEP-30 08:57:23 0 SELECT 1 0 3 0 1 7376 568 1600 CHOOSE 79312EEC analyzed  
SYS 17 0.00 0.04 5 0 0 3 1 2 select l.col#, l.intcol#, l.lobj#, l.ind#, l.ts#, l.file#, l.block#, l.chunk, l.pctversion$, l.flags, l.property, l.retention, l.freepools from lob$ l where l.obj# = :1 order by l.intcol# asc 2003-SEP-30 08:57:25 0 SELECT 17 0 62 17 50 11344 1308 3240 CHOOSE 792D4100 analyzed  
SYS 106 0.17 0.25 5 0 0 3 1 12 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# 2003-SEP-30 08:57:14 0 SELECT 47 23 366 106 1294 16633 1668 4176 CHOOSE 79360D6C analyzed  
SYS 1 0.00 0.00 2 1 0 3 0 0 select p.value$, lengthb(p.value$) from sys.props$ p where p.name = 'BACK_END_DB' 2003-SEP-30 10:14:36 0 SELECT 1 0 3 0 0 5664 628 9792 CHOOSE 79173E6C analyzed  
SYS 239 0.43 0.62 4 0 0 3 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) 2003-SEP-30 08:57:12 0 SELECT 74 59 902 0 174 15180 1348 4364 CHOOSE 7937D9AC analyzed  
SYS 1 0.00 0.00 1 0 0 3 0 1 select action# from trigger$ t where t.obj#=:1 2003-SEP-30 08:57:26 0 SELECT 1 0 3 0 1 7527 588 1732 CHOOSE 792712FC analyzed  
SYS 21 0.01 0.05 1 0 0 3 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 2003-SEP-30 08:57:25 0 SELECT 21 1 78 0 21 11414 1308 2816 CHOOSE 7928D894 analyzed  
SYS 3986 0.01 8.16 5 1 0 3 1 0 select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date < :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) order by next_date, job 2003-SEP-30 08:57:36 0 SELECT 1 1 11961 3986 0 11118 728 2496 CHOOSE 79202D4C analyzed  
SYS 36 0.01 0.10 2 0 0 3 0 0 delete from idl_ub1$ where obj#=:1 and part=:2 2003-SEP-30 12:01:18 0 DELETE 36 1 141 0 0 8039 548 3112 CHOOSE 78EE4FF8 analyzed  
SYS 1 0.00 0.00 2 0 0 3 0 0 delete from idl_ub1$ where obj#=:1 2003-SEP-30 14:38:05 0 DELETE 1 0 3 0 0 7735 528 3028 CHOOSE 78D84E14 analyzed  
SYS 161 0.05 0.43 1 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 2003-SEP-30 09:12:46 0 UPDATE 84 7 637 0 161 15432 688 4216 CHOOSE 791BA5F4 analyzed  
SYS 36 0.01 0.10 2 0 0 3 0 0 delete from idl_char$ where obj#=:1 and part=:2 2003-SEP-30 12:01:18 0 DELETE 36 1 141 0 0 8172 548 3112 CHOOSE 78EE4548 analyzed  
SYS 643 0.04 1.42 2 1 0 3 0 0 select q_name, state, delay, expiration, rowid, msgid, dequeue_msgid, chain_no, local_order_no, enq_time, enq_tid, step_no, priority, exception_qschema, exception_queue, retry_count, corrid, time_manager_info from SYSTEM.DEF$_AQCALL where time_manager_info <= :1 and state != :2 for update skip locked 2003-SEP-30 08:57:52 0 SELECT 643 5 2080 0 0 14637 1628 5108 CHOOSE 791E2774 analyzed  
SYSTEM 17 0.04 0.04 0 0 0 3 0 1 SELECT name FROM v$database WHERE ROWNUM = 1 2003-SEP-30 10:14:20 0 SELECT 17 5 63 0 17 93898 1156 9640 CHOOSE 791A7F14 analyzed  
SYS 86 0.23 0.18 2 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,spare6 from tab$ where obj#=:1 2003-SEP-30 08:57:13 0 SELECT 40 32 268 0 86 18096 2508 6572 CHOOSE 7937030C analyzed  
SYS 2 0.01 0.00 2 1 1 3 0 1 select user from dual
 2003-SEP-30 10:42:21 0 SELECT 2 2 6 0 2 5407 568 1656 CHOOSE 791A9D38 analyzed  
SYS 643 0.01 1.40 2 1 0 3 0 0 select q_name, state, delay, expiration, rowid, msgid, dequeue_msgid, chain_no, local_order_no, enq_time, enq_tid, step_no, priority, exception_qschema, exception_queue, retry_count, corrid, time_manager_info from SYSTEM.DEF$_AQERROR where time_manager_info <= :1 and state != :2 for update skip locked 2003-SEP-30 08:57:52 0 SELECT 643 1 2057 0 0 14374 1628 5092 CHOOSE 791D2FEC analyzed  
SYS 3 0.00 0.01 2 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 2003-SEP-30 08:57:14 0 SELECT 3 0 9 0 3 11991 1488 3180 CHOOSE 79350E8C analyzed  
SYS 200 0.04 0.39 2 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 2003-SEP-30 08:57:13 0 SELECT 48 5 578 0 178 9793 1008 2448 CHOOSE 79374D14 analyzed  
SYS 4 0.02 0.01 0 0 0 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 2003-SEP-30 08:57:15 0 SELECT 4 3 8 0 4 14792 1968 3812 CHOOSE 79335FD0 analyzed  
SYS 676 0.41 1.32 0 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 2003-SEP-30 08:57:25 0 SELECT 49 57 1939 0 587 12071 1508 4064 RULE 792927B4 analyzed  
SYS 11 0.01 0.02 1 0 0 2 0 1 select actionsize from trigger$ where obj# = :1 2003-SEP-30 08:57:25 0 SELECT 11 1 25 0 11 7460 588 1644 CHOOSE 79286204 analyzed  
SYS 61 0.06 0.10 6 0 0 2 1 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# 2003-SEP-30 08:57:15 0 SELECT 37 9 142 61 21 11408 768 3792 NONE 79339CD4 analyzed  
SYS 7 0.00 0.01 1 0 0 2 0 1 select user# from sys.user$ where name = 'OUTLN' 2003-SEP-30 12:00:53 0 SELECT 7 0 14 0 7 7457 568 1684 CHOOSE 790315F4 analyzed  
SYS 59 0.05 0.08 5 0 0 2 1 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# 2003-SEP-30 08:57:15 0 SELECT 37 7 118 59 0 11308 768 3760 NONE 7933F608 analyzed  
SYS 3 0.00 0.00 0 0 0 2 0 0 SELECT 0 FROM v$sesstat WHERE 1=0 2003-SEP-30 12:15:17 0 SELECT 3 0 6 0 0 11738 580 956 CHOOSE 78E0A908 analyzed  
SYS 27 0.03 0.04 1 0 0 2 0 1 select text from view$ where rowid=:1 2003-SEP-30 10:14:36 0 SELECT 27 4 60 0 27 6590 588 960 CHOOSE 791761AC analyzed  
SYS 36 0.01 0.07 2 0 0 2 0 0 delete from idl_ub2$ where obj#=:1 and part=:2 2003-SEP-30 12:01:18 0 DELETE 36 1 105 0 0 8123 548 3112 CHOOSE 78EDCFE8 analyzed  
SYS 1 0.00 0.00 2 0 0 2 0 0 delete from idl_sb4$ where obj#=:1 2003-SEP-30 14:38:05 0 DELETE 1 0 2 0 0 7627 528 3028 CHOOSE 78D7EB54 analyzed  
SYS 36 0.01 0.07 2 0 0 2 0 0 delete from idl_sb4$ where obj#=:1 and part=:2 2003-SEP-30 12:01:19 0 DELETE 36 1 105 0 0 8015 548 3112 CHOOSE 78ED9E50 analyzed  
SYS 1 0.00 0.00 2 0 0 2 0 0 select 1 from cdef$ where obj#=:1 and type#=2 2003-SEP-30 14:38:05 0 SELECT 1 0 2 0 0 9002 588 1936 CHOOSE 78D89408 analyzed  
SYS 1 0.01 0.00 0 0 2 2 0 1 select ts# from ts$ where name=:1 2003-SEP-30 08:57:19 0 SELECT 1 2 2 0 1 4234 588 1684 CHOOSE 793278C8 analyzed  
SYS 1 0.00 0.00 2 0 0 2 0 0 delete from idl_ub2$ where obj#=:1 2003-SEP-30 14:38:05 0 DELETE 1 0 2 0 0 9063 528 3028 CHOOSE 78D80BB4 analyzed  
SYS 107 0.09 0.22 0 0 0 2 0 0 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 2003-SEP-30 08:57:15 0 SELECT 107 13 318 0 87 11779 1408 3268 CHOOSE 79346538 analyzed  
SYS 53 0.01 0.04 2 0 0 1 0 0 select con#,obj#,rcon#,enabled,nvl(defer,0) from cdef$ where robj#=:1 2003-SEP-30 08:57:15 0 SELECT 30 1 53 0 0 9894 828 3172 CHOOSE 79343DC4 analyzed  
SYS 2 0.00 0.00 7 0 0 1 1 0 select u.name, o.name, trigger$.sys_evts, trigger$.type# from obj$ o, user$ u, trigger$ where bitand(trigger$.property,16) = 16 and trigger$.baseobject = :1 and trigger$.obj# = o.obj# and o.owner# = u.user# order by o.obj# 2003-SEP-30 10:14:36 0 SELECT 2 0 2 2 0 15666 776 6496 CHOOSE 791859C4 analyzed  
SYS 66 0.00 0.05 1 0 0 1 0 1 select count(*) from sys.job$ where next_date < :1 and (field1 = :2 or (field1 = 0 and 'Y' = :3)) 2003-SEP-30 09:02:34 0 SELECT 1 0 66 0 66 9472 628 3136 CHOOSE 791BF99C analyzed  
SYS 3 0.00 0.00 0 0 0 1 0 0 SELECT 0 FROM v$sqltext WHERE 1=0 2003-SEP-30 12:15:17 0 SELECT 3 0 3 0 0 10138 576 708 CHOOSE 78E11F5C analyzed  
SYS 3 0.00 0.00 0 0 0 1 0 0 SELECT 0 FROM v$statname WHERE 1=0 2003-SEP-30 12:15:17 0 SELECT 3 0 3 0 0 9127 576 536 CHOOSE 78E067A4 analyzed  
SYS 10 0.01 0.01 9 0 0 1 1 0 select u.name,o.name, t.update$, t.insert$, t.delete$, t.enabled from obj$ o,user$ u,trigger$ t where t.baseobject=:1 and t.obj#=o.obj# and o.owner#=u.user# order by o.obj# 2003-SEP-30 08:57:26 0 SELECT 10 1 10 10 0 15696 896 6540 CHOOSE 7924B3CC analyzed  
SYS 3 0.00 0.00 0 0 0 1 0 0 SELECT 0 FROM v$open_cursor WHERE 1=0 2003-SEP-30 12:15:17 0 SELECT 3 0 3 0 0 11246 576 712 CHOOSE 78E0DED0 analyzed  
SYS 18 0.00 0.02     0 1 0 1 BEGIN
/* NOP UNLESS A TABLE OBJECT */
IF dictionary_obj_type = 'TABLE' AND sys.dbms_cdc_publish.active > 0
THEN
sys.dbms_cdc_publish.change_table_trigger(dictionary_obj_owner,dictionary_obj_name,'LOCK');
END IF;
END;		 2003-SEP-30 12:00:54 0 PL/SQL 18 0 24 0 18 9923 500 260 CHOOSE 78FB77D8 not analyzed  
SYS 6 0.01 0.01 1 0 0 1 0 0 select user#,type# from user$ where name=:1 2003-SEP-30 08:57:16 0 SELECT 6 2 11 0 5 7448 648 1760 CHOOSE 7932B924 analyzed  
SYS 643 0.03 0.57 1 0 0 1 0 0 select q_name, state, delay, expiration, rowid, msgid, dequeue_msgid, chain_no, local_order_no, enq_time, enq_tid, step_no, priority, exception_qschema, exception_queue, retry_count, corrid, time_manager_info, sender_name, sender_address, sender_protocol from SYS.AQ_SRVNTFN_TABLE where time_manager_info <= :1 and state != :2 for update skip locked 2003-SEP-30 08:57:52 0 SELECT 643 4 829 0 0 16010 1808 8832 CHOOSE 791E44D4 analyzed  
SYS 3987 0.00 2.72 1 0 0 1 0 1 select count(*) from sys.job$ where (next_date > sysdate) and (next_date < (sysdate+5/86400)) 2003-SEP-30 08:57:27 0 SELECT 1 0 3987 0 3987 8042 568 1600 CHOOSE 793B2678 analyzed  
SYS 643 0.12 0.61 1 0 0 1 0 0 select q_name, state, delay, expiration, rowid, msgid, dequeue_msgid, chain_no, local_order_no, enq_time, enq_tid, step_no, priority, exception_qschema, exception_queue, retry_count, corrid, time_manager_info from SYS.AQ_EVENT_TABLE where time_manager_info <= :1 and state != :2 for update skip locked 2003-SEP-30 08:57:52 0 SELECT 643 17 888 0 0 15253 1628 6488 CHOOSE 791F54CC analyzed  
SYS 643 0.01 0.44 1 0 0 1 0 1 select 1 from sys.aq$_queue_table_affinities 2003-SEP-30 08:57:52 0 SELECT 643 1 646 0 643 6117 568 1052 CHOOSE 793C5A28 analyzed  
SYS 643 0.01 0.44 1 0 0 1 0 0 select 1 from aq$_schedules 2003-SEP-30 08:57:51 0 SELECT 643 1 646 0 0 6432 568 1184 CHOOSE 793C8104 analyzed  
SYS 0 0.00 0.00     0 0 0 0 INSERT INTO myTestTable (id, name) VALUES (3, '123456789012345678901234567890') 2003-SEP-30 12:01:19 0 INSERT 0 0 0 0 0 1496 0 0 NONE 78E80444 error ORA-00942: table or view does not exist
SYS 0 0.00 0.00     0 0 0 0 SELECT id, name FROM myTestTable ORDER BY id 2003-SEP-30 12:01:19 0 SELECT 0 0 0 0 0 1813 0 0 NONE 78E7EB5C error ORA-00942: table or view does not exist
SYS 0 0.00 0.00 2 1 0 0 0 0 select value$ from props$ where name='DEFAULT_TEMP_TABLESPACE' 2003-SEP-30 08:57:16 0 SELECT 0 0 0 0 0 1479 0 0 NONE 7932ACF4 analyzed  
SYS 1 0.00 0.00 0 0 0 0 1 0 select value from gv$parameter where name = 'undo_retention' and INST_ID <> :1 2003-SEP-30 08:57:23 0 SELECT 1 0 0 1 0 16356 596 2704 CHOOSE 7930AF5C analyzed  
SYS 1 0.00 0.00     0 0 0 0 commit 2003-SEP-30 08:57:32 0 OTHERS 1 0 0 0 0 3739 500 296 CHOOSE 792036A0 not analyzed  
SYS 3 0.00 0.00 0 0 0 0 0 0 SELECT 0 FROM v$session WHERE 1=0 2003-SEP-30 12:15:17 0 SELECT 3 0 0 0 0 45280 576 2532 NONE 78E210A4 analyzed  
SYS 18 0.00 0.00     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= '+02: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' 2003-SEP-30 08:57:32 0 ALTER SESSION 18 0 0 0 0 4956 500 296 CHOOSE 7920227C not analyzed  
SYS 0 0.00 0.00 2 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 2003-SEP-30 08:57:12 0 SELECT 0 0 0 0 0 1553 0 0 NONE 7937B81C analyzed  
MDSYS 6 0.00 0.00     0 0 0 1 declare
stmt varchar2(200);
BEGIN
if dictionary_obj_type = 'USER' THEN
stmt := 'DELETE FROM SDO_GEOM_METADATA_TABLE ' ||
' WHERE SDO_OWNER = ''' || dictionary_obj_name || ''' ';
EXECUTE IMMEDIATE stmt;
stmt := 'DELETE FROM SDO_MAPS_TABLE ' ||
' WHERE SDO_OWNER = ''' || dictionary_obj_name || ''' ';
EXECUTE IMMEDIATE stmt;
stmt := 'DELETE FROM SDO_STYLES_TABLE ' ||
' WHERE SDO_OWNER = ''' || dictionary_obj_name || ''' ';
EXECUTE IMMEDIATE stmt;
stmt := 'DELETE FROM SDO_THEMES_TABLE ' ||
' WHERE SDO_OWNER = ''' || dictionary_obj_name || ''' ';
EXECUTE IMMEDIATE stmt;
stmt := 'DELETE FROM SDO_LRS_METADATA_TABLE ' ||
' WHERE SDO_OWNER = ''' || dictionary_obj_name || ''' ';
EXECUTE IMMEDIATE stmt;
end if;
end;		 2003-SEP-30 12:01:18 0 PL/SQL 6 0 0 0 6 11352 500 260 CHOOSE 78EE7ED0 not analyzed  
SYS 0 0.00 0.00 1 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 2003-SEP-30 08:57:15 0 UPDATE 0 0 0 0 0 1565 0 0 NONE 79349928 analyzed  
SYS 0 0.00 0.00     0 0 0 0 INSERT INTO myTestTable (id, name) VALUES (1, 'test') 2003-SEP-30 12:00:55 0 INSERT 0 0 0 0 0 1470 0 0 NONE 78F2AF08 error ORA-00942: table or view does not exist
SYS 0 0.00 0.00 2 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) 2003-SEP-30 09:12:47 0 INSERT 84 0 0 0 0 15941 672 0 CHOOSE 791B3C1C analyzed  
SYS 0 0.00 0.00 3 1 0 0 0 0 select line#, sql_text from bootstrap$ where obj# != :1 2003-SEP-30 08:57:12 0 SELECT 0 0 0 0 0 1472 0 0 NONE 793AE04C analyzed  
SYS 0 0.00 0.00     0 0 0 0 INSERT INTO myTestTable (id, name) VALUES (2, 'test') 2003-SEP-30 12:01:19 0 INSERT 0 0 0 0 0 1470 0 0 NONE 78E80B68 error ORA-00942: table or view does not exist
SYS 0 0.00 0.00     0 0 0 0 alter database open 2003-SEP-30 08:57:02 0 ALTER DATABASE 0 0 0 0 0 1436 0 0 NONE 793B3C30 not analyzed  
SYS 1 0.00 0.00 0 0 0 0 0 1 select OPEN_MODE from v$database 2003-SEP-30 08:57:23 0 SELECT 1 0 0 0 1 46209 576 4808 CHOOSE 79304CE0 analyzed  
SYS 1 0.00 0.00 0 0 0 0 4 9 SELECT s.username,
LENGTH(s.username),
s.sid,
LENGTH(s.sid),
s.serial#,
LENGTH(s.serial#),
s.status,
s.osuser,
s.machine,
s.terminal,
s.program,
TO_CHAR(s.logon_time, 'DD-MON-YYYY HH24:MI:SS'),
s.schemaname,
a.sql_text
FROM v$session s,
v$sqlarea a
WHERE s.sql_address = a.address (+)
ORDER BY s.sid
 2003-SEP-30 11:09:36 0 SELECT 1 0 0 4 9 88890 1368 13108 CHOOSE 79102CB4 analyzed  
SYS 6 0.00 0.00 0 0 0 0 5 1 SELECT sql_text FROM v$sqlarea WHERE address In (SELECT address FROM v$open_cursor WHERE sid = :sid) ORDER BY sql_text 2003-SEP-30 12:15:51 0 SELECT 6 0 0 30 6 52562 608 10464 CHOOSE 78DC92A4 analyzed  
SYS 0 0.00 0.00 2 0 0 0 0 0 select ctime, mtime, stime from obj$ where obj# = :1 2003-SEP-30 08:57:12 0 SELECT 0 0 0 0 0 1469 0 0 NONE 79375B60 analyzed  
SYS 1 0.00 0.00 0 0 0 0 4 9 SELECT s.username,
LENGTH(s.username),
s.sid,
LENGTH(s.sid),
s.serial#,
s.status,
s.osuser,
s.machine,
s.terminal,
s.program,
TO_CHAR(s.logon_time, 'DD-MON-YYYY HH24:MI:SS'),
s.schemaname,
a.sql_text
FROM v$session s,
v$sqlarea a
WHERE s.sql_address = a.address (+)
ORDER BY s.sid
 2003-SEP-30 11:09:24 0 SELECT 1 0 0 4 9 88572 1308 12988 CHOOSE 79118738 analyzed  
SYS 1 0.00 0.00 0 0 0 0 4 9 SELECT s.username,
LENGTH(s.username),
s.sid,
LENGTH(s.sid),
s.serial#,
LENGTH(s.serial#),
s.status,
LENGTH(s.status),
s.osuser,
LENGTH(s.osuser),
s.machine,
LENGTH(s.machine),
s.terminal,
LENGTH(s.terminal),
s.program,
LENGTH(s.program),
TO_CHAR(s.logon_time, 'DD-MON-YYYY HH24:MI:SS'),
s.schemaname,
LENGTH(s.schemaname),
a.sql_text,
LENGTH(a.sql_text)
FROM v$session s,
v$sqlarea a
WHERE s.sql_address = a.address (+)
ORDER BY s.sid
 2003-SEP-30 11:10:45 0 SELECT 1 0 0 4 9 92191 1788 13712 CHOOSE 790EBFCC analyzed  
SYS 1 0.00 0.00 0 0 0 0 4 9 SELECT s.username,
LENGTH(s.username),
s.sid,
s.serial#,
s.status,
s.osuser,
s.machine,
s.terminal,
s.program,
TO_CHAR(s.logon_time, 'DD-MON-YYYY HH24:MI:SS'),
s.schemaname,
a.sql_text
FROM v$session s,
v$sqlarea a
WHERE s.sql_address = a.address (+)
ORDER BY s.sid
 2003-SEP-30 11:09:14 0 SELECT 1 0 0 4 9 88290 1248 12872 CHOOSE 7912E1BC analyzed  
SYS 0 0.00 0.00 1 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 2003-SEP-30 08:57:15 0 SELECT 0 0 0 0 0 1359 0 0 NONE 7934CBE8 analyzed  
SYS 0 0.00 0.00 2 0 0 0 0 0 select charsetid, charsetform from col$ where obj# = :1 and col# = :2 2003-SEP-30 08:57:12 0 SELECT 0 0 0 0 0 1487 0 0 NONE 7937895C analyzed  
SYS 0 0.00 0.00     0 0 0 0 alter database mount exclusive 2003-SEP-30 08:56:53 0 ALTER DATABASE 0 0 0 0 0 1448 0 0 NONE 793B433C not analyzed  
SYS 0 0.00 0.00 2 0 0 0 0 0 select rowcnt,blkcnt,empcnt,avgspc,chncnt,avgrln,nvl(degree,1), nvl(instances,1) from tab$ where obj# = :1 2003-SEP-30 08:57:12 0 SELECT 0 0 0 0 0 1691 0 0 NONE 7937E7F8 analyzed  
SYS 1 0.00 0.00 0 0 0 0 4 9 SELECT s.username,
s.sid,
s.serial#,
s.status,
s.osuser,
s.machine,
s.terminal,
s.program,
TO_CHAR(s.logon_time, 'DD-MON-YYYY HH24:MI:SS'),
s.schemaname,
a.sql_text
FROM v$session s,
v$sqlarea a
WHERE s.sql_address = a.address (+)
ORDER BY s.sid
 2003-SEP-30 11:08:59 0 SELECT 1 0 0 4 9 87703 1188 12804 CHOOSE 7914347C analyzed  
SYS 0 0.00 0.00     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' 2003-SEP-30 08:56:53 0 ALTER SESSION 0 0 0 0 0 1663 0 0 NONE 793B4EA8 not analyzed  
SYS 1 0.00 0.00 0 0 0 0 4 9 SELECT s.username,
LENGTH(s.username),
s.sid,
LENGTH(s.sid),
s.serial#,
LENGTH(s.serial#),
s.status,
LENGTH(s.status),
s.osuser,
LENGTH(s.osuser),
s.machine,
LENGTH(s.machine),
s.terminal,
LENGTH(s.terminal),
s.program,
LENGTH(s.program),
TO_CHAR(s.logon_time, 'DD-MON-YYYY HH24:MI:SS'),
LENGTH(TO_CHAR(s.logon_time, 'DD-MON-YYYY HH24:MI:SS')),
s.schemaname,
LENGTH(s.schemaname),
a.sql_text,
LENGTH(a.sql_text)
FROM v$session s,
v$sqlarea a
WHERE s.sql_address = a.address (+)
ORDER BY s.sid
 2003-SEP-30 11:11:17 0 SELECT 1 0 0 4 9 92275 1848 13840 CHOOSE 790D5B40 analyzed  
SYS 0 0.00 0.00 2 0 0 0 0 0 select null from obj$ where obj#=:1 and type#=:2 and obj# not in (select p_obj# from dependency$ where p_obj# = obj$.obj#) 2003-SEP-30 08:57:21 0 SELECT 1 0 0 0 0 16723 592 0 CHOOSE 79364F08 analyzed  
SYS 1 0.00 0.00 0 0 0 0 4 2 SELECT s.username, s.sid, s.serial#, s.status, s.osuser, s.machine, s.terminal, s.program, TO_CHAR(s.logon_time, 'DD-MON-YYYY HH24:MI:SS'), s.schemaname, a.sql_text
FROM v$session s,
v$sqlarea a
WHERE s.sql_address = a.address (+) AND username IS NOT NULL AND status != 'KILLED' ORDER BY s.sid		 2003-SEP-30 12:15:20 0 SELECT 1 0 0 4 2 88268 1188 12972 CHOOSE 78E0393C analyzed  
SYS 0 0.00 0.00     0 0 0 0 INSERT INTO myTestTable (id, name) VALUES (1, NULL) 2003-SEP-30 12:00:55 0 INSERT 0 0 0 0 0 1468 0 0 NONE 78F31270 error ORA-00942: table or view does not exist
SYS 51 0.00 0.00 0 0 0 0 1 248 SELECT n.class, s.statistic#, n.name, s.value FROM v$sesstat s, v$statname n WHERE s.sid = :sid AND s.statistic# = n.statistic# ORDER BY s.statistic# 2003-SEP-30 12:15:54 0 SELECT 51 0 0 51 12648 19027 792 2020 CHOOSE 78DBC7A4 analyzed  
SYS 2 0.00 0.00     0 0 0 0 alter session set nls_date_format = 'MM/DD/YYYY HH24:MI:SS'
 2003-SEP-30 10:42:21 0 ALTER SESSION 2 0 0 0 0 3781 500 296 CHOOSE 791A88D0 not analyzed  
SYS 67 0.00 0.00 0 0 0 0 4 9 SELECT s.username, s.sid, s.serial#, s.status, s.osuser, s.machine, s.terminal, s.program, TO_CHAR(s.logon_time, 'DD-MON-YYYY HH24:MI:SS'), s.schemaname, a.sql_text
FROM v$session s,
v$sqlarea a
WHERE s.sql_address = a.address (+) ORDER BY s.sid		 2003-SEP-30 12:15:25 0 SELECT 67 0 0 268 661 87300 1188 12804 CHOOSE 78DEE1EC analyzed  
Automatically generated Tue Sep 30 14:40:21 2003 with:
Top100 - The Oracle Shared Pool Profiler Version 2.0.3
Copyright (c) 1995-2003 by Material Dreams
All Rights Reserved.
WWW: www.materialdreams.com
EMail: info@materialdreams.com