[2008-07-29 20:47:23:570] 
Oracle SPY, built at Jul 29 2008 20:07:18
 -- Dennis Yurichev <dennis@conus.info> http://blogs.conus.info

[2008-07-29 20:47:26:601] [ORACLE.EXE (SHAD)] rpisplu:
========================================
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 is null and linkname is null and subname is null
========================================

[2008-07-29 20:47:26:617] [ORACLE.EXE (SHAD)] rpisplu:
========================================
select increment$,minvalue,maxvalue,cycle#,order$,cache,highwater,audit$,flags from seq$ where obj#=:1
========================================

[2008-07-29 20:47:26:648] [ORACLE.EXE (SHAD)] rpisplu:
========================================
update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,order$=:6,cache=:7,highwater=:8,audit$=:9,flags=:10 where obj#=:1
========================================

[2008-07-29 20:47:26:663] [ORACLE.EXE (SHAD)] opiprs:
========================================
update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,order$=:6,cache=:7,highwater=:8,audit$=:9,flags=:10 where obj#=:1
========================================

[2008-07-29 20:47:26:710] [ORACLE.EXE (SHAD)] opiprs:
========================================
update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,order$=:6,cache=:7,highwater=:8,audit$=:9,flags=:10 where obj#=:1
========================================

[2008-07-29 20:47:26:710] [ORACLE.EXE (SHAD)] kprbprs:
========================================
select option#,NVL(success,0),NVL(failure,0) from audit$ where user#=:client and proxy# is null
========================================

[2008-07-29 20:47:26:773] [ORACLE.EXE (SHAD)] opiprs:
========================================
select option#,NVL(success,0),NVL(failure,0) from audit$ where user#=:client and proxy# is null
========================================

[2008-07-29 20:47:26:820] [ORACLE.EXE (SHAD)] rpisplu:
========================================
select t.ts#,t.file#,t.block#,nvl(t.bobj#,0),nvl(t.tab#,0),t.intcols,nvl(t.clucols,0),t.audit$,t.flags,t.pctfree$,t.pctused$,t.initrans,t.maxtrans,t.rowcnt,t.blkcnt,t.empcnt,t.avgspc,t.chncnt,t.avgrln,t.analyzetime,t.samplesize,t.cols,t.property,nvl(t.degree,1),nvl(t.instances,1),t.avgspc_flb,t.flbcnt,t.kernelcols,nvl(t.trigflag, 0),nvl(t.spare1,0),nvl(t.spare2,0),t.spare4,t.spare6,ts.cachedblk,ts.cachehit,ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
========================================

[2008-07-29 20:47:26:835] [ORACLE.EXE (SHAD)] rpisplu:
========================================
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,i.spare2,i.spare6,decode(i.pctthres$,null,null,mod(trunc(i.pctthres$/256),256)),ist.cachedblk,ist.cachehit,ist.logicalread from ind$ i, ind_stats$ ist, (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.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
========================================

[2008-07-29 20:47:26:835] [ORACLE.EXE (SHAD)] rpisplu:
========================================
select pos#,intcol#,col#,spare1,bo#,spare2,spare3 from icol$ where obj#=:1
========================================

[2008-07-29 20:47:26:835] [ORACLE.EXE (SHAD)] rpisplu:
========================================
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#
========================================

[2008-07-29 20:47:26:851] [ORACLE.EXE (SHAD)] rpisplu:
========================================
select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname from obj$ o where o.obj#=:1
========================================

[2008-07-29 20:47:26:867] [ORACLE.EXE (SHAD)] opiprs:
========================================
select option#,NVL(success,0),NVL(failure,0) from audit$ where user#=:client and proxy# is null
========================================

[2008-07-29 20:47:26:867] [ORACLE.EXE (SHAD)] rpisplu:
========================================
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
========================================

[2008-07-29 20:47:26:898] [ORACLE.EXE (SHAD)] rpisplu:
========================================
select user#,password,datats#,tempts#,type#,defrole,resource$, ptime,exptime, ltime, astatus, lcount, decode(defschclass,NULL,'DEFAULT_CONSUMER_GROUP',defschclass),spare1,spare4,ext_username,spare2 from user$ where name=:1
========================================

[2008-07-29 20:47:27:023] [ORACLE.EXE (SHAD)] kprbprs:
========================================
select option#,NVL(success,0),NVL(failure,0) from audit$ where user#=:client and proxy# is null
========================================

[2008-07-29 20:47:27:038] [ORACLE.EXE (SHAD)] rpisplu:
========================================
select limit# from profile$ where profile#=:1 and resource#=:2 and type#=:3
========================================

[2008-07-29 20:47:27:070] [ORACLE.EXE (SHAD)] opiprs:
========================================
select limit# from profile$ where profile#=:1 and resource#=:2 and type#=:3
========================================

[2008-07-29 20:47:27:101] [ORACLE.EXE (SHAD)] opiprs:
========================================
select limit# from profile$ where profile#=:1 and resource#=:2 and type#=:3
========================================

[2008-07-29 20:47:27:101] [ORACLE.EXE (SHAD)] rpisplu:
========================================
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
========================================

[2008-07-29 20:47:27:132] [ORACLE.EXE (SHAD)] rpisplu:
========================================
select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
========================================

[2008-07-29 20:47:27:148] [ORACLE.EXE (SHAD)] opiprs:
========================================
select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
========================================

[2008-07-29 20:47:27:179] [ORACLE.EXE (SHAD)] opiprs:
========================================
select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
========================================

[2008-07-29 20:47:27:195] [ORACLE.EXE (SHAD)] rpisplu:
========================================
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
========================================

[2008-07-29 20:47:27:195] [ORACLE.EXE (SHAD)] opiprs:
========================================
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
========================================

[2008-07-29 20:47:27:195] [ORACLE.EXE (SHAD)] opiprs:
========================================
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
========================================

[2008-07-29 20:47:27:242] [ORACLE.EXE (SHAD)] rpisplu:
========================================
select name,password,datats#,tempts#,type#,defrole,resource$, ptime, exptime, ltime, astatus, lcount, decode(defschclass,NULL,'DEFAULT_CONSUMER_GROUP',defschclass),spare1,spare4,ext_username,spare2 from user$ where user#=:1
========================================

[2008-07-29 20:47:27:257] [ORACLE.EXE (SHAD)] rpisplu:
========================================
select user#,password,datats#,tempts#,type#,defrole,resource$, ptime,exptime, ltime, astatus, lcount, decode(defschclass,NULL,'DEFAULT_CONSUMER_GROUP',defschclass),spare1,spare4,ext_username,spare2 from user$ where name=:1
========================================

[2008-07-29 20:47:27:304] [ORACLE.EXE (SHAD)] rpisplu:
========================================
select privilege#,level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
========================================

[2008-07-29 20:47:27:320] [ORACLE.EXE (SHAD)] opiprs:
========================================
select privilege#,level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
========================================

[2008-07-29 20:47:27:351] [ORACLE.EXE (SHAD)] opiprs:
========================================
select privilege#,level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
========================================

[2008-07-29 20:47:27:367] [ORACLE.EXE (SHAD)] rpisplu:
========================================
select name,password,datats#,tempts#,type#,defrole,resource$, ptime, exptime, ltime, astatus, lcount, decode(defschclass,NULL,'DEFAULT_CONSUMER_GROUP',defschclass),spare1,spare4,ext_username,spare2 from user$ where user#=:1
========================================

[2008-07-29 20:47:27:367] [ORACLE.EXE (SHAD)] rpisplu:
========================================
select user#,password,datats#,tempts#,type#,defrole,resource$, ptime,exptime, ltime, astatus, lcount, decode(defschclass,NULL,'DEFAULT_CONSUMER_GROUP',defschclass),spare1,spare4,ext_username,spare2 from user$ where name=:1
========================================

[2008-07-29 20:47:27:367] [ORACLE.EXE (SHAD)] rpisplu:
========================================
select privilege#,level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
========================================

[2008-07-29 20:47:27:367] [ORACLE.EXE (SHAD)] rpisplu:
========================================
select distinct(-privilege#),nvl(option$,0) from sysauth$ where grantee#=:1 and privilege#<0
========================================

[2008-07-29 20:47:27:382] [ORACLE.EXE (SHAD)] rpisplu:
========================================
select distinct(-privilege#),nvl(option$,0) from sysauth$ where grantee#=:1 and privilege#<0
========================================

[2008-07-29 20:47:27:429] [ORACLE.EXE (SHAD)] rpisplu:
========================================
select distinct(-privilege#),nvl(option$,0) from sysauth$ where grantee#=:1 and privilege#<0
========================================

[2008-07-29 20:47:27:445] [ORACLE.EXE (SHAD)] rpisplu:
========================================
select distinct(-privilege#),nvl(option$,0) from sysauth$ where grantee#=:1 and privilege#<0
========================================

[2008-07-29 20:47:27:445] [ORACLE.EXE (SHAD)] rpisplu:
========================================
insert into sys.aud$( sessionid,entryid,statement,ntimestamp#, userid,userhost,terminal,action#,returncode, obj$creator,obj$name,auth$privileges,auth$grantee, new$owner,new$name,ses$actions,ses$tid,logoff$pread, logoff$lwrite,logoff$dead,comment$text,spare1,spare2,  priv$used,clientid,sessioncpu,proxy$sid,user$guid, instance#,process#,xid,scn,auditid,  sqlbind,sqltext,obj$edition,dbid)  values(:1,:2,:3,SYS_EXTRACT_UTC(SYSTIMESTAMP),     :4,:5,:6,:7,:8,     :9,:10,:11,:12,     :13,:14,:15,:16,:17,     :18,:19,:20,:21,:22,     :23,:24,:25,:26,:27,     :28,:29,:30,:31,:32,     :33,:34,:35,:36)
========================================

[2008-07-29 20:47:27:492] [ORACLE.EXE (SHAD)] opiprs:
========================================
insert into sys.aud$( sessionid,entryid,statement,ntimestamp#, userid,userhost,terminal,action#,returncode, obj$creator,obj$name,auth$privileges,auth$grantee, new$owner,new$name,ses$actions,ses$tid,logoff$pread, logoff$lwrite,logoff$dead,comment$text,spare1,spare2,  priv$used,clientid,sessioncpu,proxy$sid,user$guid, instance#,process#,xid,scn,auditid,  sqlbind,sqltext,obj$edition,dbid)  values(:1,:2,:3,SYS_EXTRACT_UTC(SYSTIMESTAMP),     :4,:5,:6,:7,:8,     :9,:10,:11,:12,     :13,:14,:15,:16,:17,     :18,:19,:20,:21,:22,     :23,:24,:25,:26,:27,     :28,:29,:30,:31,:32,     :33,:34,:35,:36)
========================================

[2008-07-29 20:47:27:585] [ORACLE.EXE (SHAD)] kprbprs:
========================================
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
========================================

[2008-07-29 20:47:27:632] [ORACLE.EXE (SHAD)] opiprs:
========================================
insert into sys.aud$( sessionid,entryid,statement,ntimestamp#, userid,userhost,terminal,action#,returncode, obj$creator,obj$name,auth$privileges,auth$grantee, new$owner,new$name,ses$actions,ses$tid,logoff$pread, logoff$lwrite,logoff$dead,comment$text,spare1,spare2,  priv$used,clientid,sessioncpu,proxy$sid,user$guid, instance#,process#,xid,scn,auditid,  sqlbind,sqltext,obj$edition,dbid)  values(:1,:2,:3,SYS_EXTRACT_UTC(SYSTIMESTAMP),     :4,:5,:6,:7,:8,     :9,:10,:11,:12,     :13,:14,:15,:16,:17,     :18,:19,:20,:21,:22,     :23,:24,:25,:26,:27,     :28,:29,:30,:31,:32,     :33,:34,:35,:36)
========================================

[2008-07-29 20:47:27:710] [ORACLE.EXE (SHAD)] rpisplu:
========================================
select value$ from props$ where name = 'GLOBAL_DB_NAME'
========================================

[2008-07-29 20:47:27:773] [ORACLE.EXE (SHAD)] kprbprs:
========================================
select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
========================================

[2008-07-29 20:47:27:835] [ORACLE.EXE (SHAD)] kprbprs:
========================================
select  decode(u.type#, 2, u.ext_username, u.name), o.name, trigger$.sys_evts, trigger$.type#  from obj$ o, user$ u, trigger$  where o.type# = 12 and bitand(trigger$.property,16) = 16   and trigger$.baseobject = :1 and trigger$.obj# = o.obj#   and o.owner# = u.user# order by o.obj#
========================================

[2008-07-29 20:47:27:882] [ORACLE.EXE (SHAD)] opiprs:
========================================
select  decode(u.type#, 2, u.ext_username, u.name), o.name, trigger$.sys_evts, trigger$.type#  from obj$ o, user$ u, trigger$  where o.type# = 12 and bitand(trigger$.property,16) = 16   and trigger$.baseobject = :1 and trigger$.obj# = o.obj#   and o.owner# = u.user# order by o.obj#
========================================

[2008-07-29 20:47:27:960] [ORACLE.EXE (SHAD)] rpisplu:
========================================
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 is null and linkname is null and subname is null
========================================

[2008-07-29 20:47:27:976] [ORACLE.EXE (SHAD)] rpisplu:
========================================
select node,owner,name from syn$ where obj#=:1
========================================

[2008-07-29 20:47:27:992] [ORACLE.EXE (SHAD)] rpisplu:
========================================
select order#,columns,types from access$ where d_obj#=:1
========================================

[2008-07-29 20:47:27:992] [ORACLE.EXE (SHAD)] rpisplu:
========================================
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#
========================================

[2008-07-29 20:47:28:007] [ORACLE.EXE (SHAD)] rpisplu:
========================================
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#
========================================

[2008-07-29 20:47:28:007] [ORACLE.EXE (SHAD)] rpisplu:
========================================
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 is null and linkname is null and subname is null
========================================

[2008-07-29 20:47:28:023] [ORACLE.EXE (SHAD)] rpisplu:
========================================
select node,owner,name from syn$ where obj#=:1
========================================

[2008-07-29 20:47:28:038] [ORACLE.EXE (SHAD)] rpisplu:
========================================
select order#,columns,types from access$ where d_obj#=:1
========================================

[2008-07-29 20:47:28:038] [ORACLE.EXE (SHAD)] kprbprs:
========================================
select audit$,options from procedure$ where obj#=:1
========================================

[2008-07-29 20:47:28:038] [ORACLE.EXE (SHAD)] rpisplu:
========================================
select order#,columns,types from access$ where d_obj#=:1
========================================

[2008-07-29 20:47:28:038] [ORACLE.EXE (SHAD)] rpisplu:
========================================
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#
========================================

[2008-07-29 20:47:28:038] [ORACLE.EXE (SHAD)] rpisplu:
========================================
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#
========================================

[2008-07-29 20:47:28:038] [ORACLE.EXE (SHAD)] rpisplu:
========================================
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#
========================================

[2008-07-29 20:47:28:054] [ORACLE.EXE (SHAD)] rpisplu:
========================================
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#
========================================

[2008-07-29 20:47:28:054] [ORACLE.EXE (SHAD)] rpisplu:
========================================
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#
========================================

[2008-07-29 20:47:28:070] [ORACLE.EXE (SHAD)] rpisplu:
========================================
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#
========================================

[2008-07-29 20:47:28:070] [ORACLE.EXE (SHAD)] rpisplu:
========================================
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#
========================================

[2008-07-29 20:47:28:085] [ORACLE.EXE (SHAD)] rpisplu:
========================================
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#
========================================

[2008-07-29 20:47:28:101] [ORACLE.EXE (SHAD)] rpisplu:
========================================
select privilege#,nvl(col#,0),max(mod(nvl(option$,0),2))from objauth$ where obj#=:1 and grantee#=:2 group by privilege#,nvl(col#,0)
========================================

[2008-07-29 20:47:28:101] [ORACLE.EXE (SHAD)] opiprs:
========================================
select privilege#,nvl(col#,0),max(mod(nvl(option$,0),2))from objauth$ where obj#=:1 and grantee#=:2 group by privilege#,nvl(col#,0)
========================================

[2008-07-29 20:47:28:101] [ORACLE.EXE (SHAD)] opiprs:
========================================
select privilege#,nvl(col#,0),max(mod(nvl(option$,0),2))from objauth$ where obj#=:1 and grantee#=:2 group by privilege#,nvl(col#,0)
========================================

[2008-07-29 20:47:28:132] [ORACLE.EXE (SHAD)] rpisplu:
========================================
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#
========================================

[2008-07-29 20:47:28:132] [ORACLE.EXE (SHAD)] rpisplu:
========================================
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#
========================================

[2008-07-29 20:47:28:132] [ORACLE.EXE (SHAD)] rpisplu:
========================================
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 is null and linkname is null and subname is null
========================================

[2008-07-29 20:47:28:148] [ORACLE.EXE (SHAD)] rpisplu:
========================================
select obj# from oid$ where user#=:1 and oid$=:2
========================================

[2008-07-29 20:47:28:148] [ORACLE.EXE (SHAD)] rpisplu:
========================================
select metadata from kopm$  where name='DB_FDO'
========================================

[2008-07-29 20:47:28:163] [ORACLE.EXE (SHAD)] rpisplu:
========================================
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#
========================================

[2008-07-29 20:47:28:210] [ORACLE.EXE (SHAD)] rpisplu:
========================================
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#
========================================

[2008-07-29 20:47:28:210] [ORACLE.EXE (SHAD)] kprbprs:
========================================
select audit$,options from procedure$ where obj#=:1
========================================

[2008-07-29 20:47:28:210] [ORACLE.EXE (SHAD)] rpisplu:
========================================
select order#,columns,types from access$ where d_obj#=:1
========================================

[2008-07-29 20:47:28:226] [ORACLE.EXE (SHAD)] rpisplu:
========================================
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#
========================================

[2008-07-29 20:47:28:226] [ORACLE.EXE (SHAD)] rpisplu:
========================================
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#
========================================

[2008-07-29 20:47:28:242] [ORACLE.EXE (SHAD)] rpisplu:
========================================
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#
========================================

[2008-07-29 20:47:28:242] [ORACLE.EXE (SHAD)] rpisplu:
========================================
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#
========================================

[2008-07-29 20:47:28:257] [ORACLE.EXE (SHAD)] rpisplu:
========================================
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 is null and linkname is null and subname is null
========================================

[2008-07-29 20:47:28:273] [ORACLE.EXE (SHAD)] rpisplu:
========================================
select cols,audit$,textlength,intcols,property,flags,rowid from view$ where obj#=:1
========================================

[2008-07-29 20:47:28:335] [ORACLE.EXE (SHAD)] rpisplu:
========================================
select order#,columns,types from access$ where d_obj#=:1
========================================

[2008-07-29 20:47:28:351] [ORACLE.EXE (SHAD)] rpisplu:
========================================
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#
========================================

[2008-07-29 20:47:28:367] [ORACLE.EXE (SHAD)] rpisplu:
========================================
select text from view$ where rowid=:1
========================================

[2008-07-29 20:47:28:382] [ORACLE.EXE (SHAD)] rpisplu:
========================================
select t.ts#,t.file#,t.block#,nvl(t.bobj#,0),nvl(t.tab#,0),t.intcols,nvl(t.clucols,0),t.audit$,t.flags,t.pctfree$,t.pctused$,t.initrans,t.maxtrans,t.rowcnt,t.blkcnt,t.empcnt,t.avgspc,t.chncnt,t.avgrln,t.analyzetime,t.samplesize,t.cols,t.property,nvl(t.degree,1),nvl(t.instances,1),t.avgspc_flb,t.flbcnt,t.kernelcols,nvl(t.trigflag, 0),nvl(t.spare1,0),nvl(t.spare2,0),t.spare4,t.spare6,ts.cachedblk,ts.cachehit,ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
========================================

[2008-07-29 20:47:28:429] [ORACLE.EXE (SHAD)] rpisplu:
========================================
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,i.spare2,i.spare6,decode(i.pctthres$,null,null,mod(trunc(i.pctthres$/256),256)),ist.cachedblk,ist.cachehit,ist.logicalread from ind$ i, ind_stats$ ist, (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.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
========================================

[2008-07-29 20:47:28:445] [ORACLE.EXE (SHAD)] rpisplu:
========================================
select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts,NVL(lists,65535),NVL(groups,65535),cachehint,hwmincr, NVL(spare1,0),NVL(scanhint,0),NVL(bitmapranges,0) from seg$ where ts#=:1 and file#=:2 and block#=:3
========================================

[2008-07-29 20:47:28:492] [ORACLE.EXE (SHAD)] rpisplu:
========================================
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#
========================================

[2008-07-29 20:47:28:538] [ORACLE.EXE (SHAD)] rpisplu:
========================================
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#
========================================

[2008-07-29 20:47:28:554] [ORACLE.EXE (SHAD)] rpisplu:
========================================
select col#,intcol#,toid,version#,packed,intcols,intcol#s,flags, synobj#, nvl(typidcol#, 0) from coltype$ where obj#=:1 order by intcol# desc
========================================

[2008-07-29 20:47:28:570] [ORACLE.EXE (SHAD)] rpisplu:
========================================
select intcol#, toid, version#, intcols, intcol#s, flags, synobj# from subcoltype$ where obj#=:1 order by intcol# asc
========================================

[2008-07-29 20:47:28:585] [ORACLE.EXE (SHAD)] rpisplu:
========================================
select col#,intcol#,ntab# from ntab$ where obj#=:1 order by intcol# asc
========================================

[2008-07-29 20:47:28:585] [ORACLE.EXE (SHAD)] kprbprs:
========================================
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
========================================

[2008-07-29 20:47:28:585] [ORACLE.EXE (SHAD)] rpisplu:
========================================
select col#,intcol#,reftyp,stabid,expctoid from refcon$ where obj#=:1 order by intcol# asc
========================================

[2008-07-29 20:47:28:585] [ORACLE.EXE (SHAD)] rpisplu:
========================================
select col#,intcol#,charsetid,charsetform from col$ where obj#=:1 order by intcol# asc
========================================

[2008-07-29 20:47:28:585] [ORACLE.EXE (SHAD)] rpisplu:
========================================
select intcol#,type,flags,lobcol,objcol,extracol,schemaoid,  elemnum from opqtype$ where obj# = :1 order by intcol# asc
========================================

[2008-07-29 20:47:28:601] [ORACLE.EXE (SHAD)] rpisplu:
========================================
select con#,obj#,rcon#,enabled,nvl(defer,0) from cdef$ where robj#=:1
========================================

[2008-07-29 20:47:28:601] [ORACLE.EXE (SHAD)] rpisplu:
========================================
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
========================================

[2008-07-29 20:47:28:632] [ORACLE.EXE (SHAD)] rpisplu:
========================================
select intcol#,nvl(pos#,0),col#,nvl(spare1,0) from ccol$ where con#=:1
========================================

[2008-07-29 20:47:28:648] [ORACLE.EXE (SHAD)] rpisplu:
========================================
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
========================================

[2008-07-29 20:47:28:710] [ORACLE.EXE (SHAD)] rpisplu:
========================================
select text from view$ where rowid=:1
========================================

[2008-07-29 20:47:28:726] [ORACLE.EXE (SHAD)] rpisplu:
========================================
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 is null and linkname is null and subname is null
========================================

[2008-07-29 20:47:28:726] [ORACLE.EXE (SHAD)] rpisplu:
========================================
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#
========================================

[2008-07-29 20:47:28:757] [ORACLE.EXE (SHAD)] rpisplu:
========================================
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#
========================================

[2008-07-29 20:47:28:788] [ORACLE.EXE (SHAD)] rpisplu:
========================================
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#
========================================

[2008-07-29 20:47:28:804] [ORACLE.EXE (SHAD)] rpisplu:
========================================
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#
========================================

[2008-07-29 20:47:28:804] [ORACLE.EXE (SHAD)] rpisplu:
========================================
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#
========================================

[2008-07-29 20:47:28:804] [ORACLE.EXE (SHAD)] rpisplu:
========================================
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#
========================================

[2008-07-29 20:47:28:820] [ORACLE.EXE (SHAD)] rpisplu:
========================================
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#
========================================

[2008-07-29 20:47:28:835] [ORACLE.EXE (SHAD)] rpisplu:
========================================
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#
========================================

[2008-07-29 20:47:28:851] [ORACLE.EXE (SHAD)] rpisplu:
========================================
select privilege#,nvl(col#,0),max(mod(nvl(option$,0),2))from objauth$ where obj#=:1 and grantee#=:2 group by privilege#,nvl(col#,0)
========================================

[2008-07-29 20:47:32:163] [ORACLE.EXE (SHAD)] rpisplu:
========================================
update sys.aud$ set action#=:2, returncode=:3, logoff$time=cast(SYS_EXTRACT_UTC(systimestamp) as date), logoff$pread=:4, logoff$lread=:5, logoff$lwrite=:6, logoff$dead=:7, sessioncpu=:8 where sessionid=:1 and entryid=1 and action#=100
========================================

[2008-07-29 20:47:32:195] [ORACLE.EXE (SHAD)] opiprs:
========================================
update sys.aud$ set action#=:2, returncode=:3, logoff$time=cast(SYS_EXTRACT_UTC(systimestamp) as date), logoff$pread=:4, logoff$lread=:5, logoff$lwrite=:6, logoff$dead=:7, sessioncpu=:8 where sessionid=:1 and entryid=1 and action#=100
========================================

[2008-07-29 20:47:32:226] [ORACLE.EXE (SHAD)] opiprs:
========================================
update sys.aud$ set action#=:2, returncode=:3, logoff$time=cast(SYS_EXTRACT_UTC(systimestamp) as date), logoff$pread=:4, logoff$lread=:5, logoff$lwrite=:6, logoff$dead=:7, sessioncpu=:8 where sessionid=:1 and entryid=1 and action#=100
========================================

[2008-07-29 20:47:32:226] [ORACLE.EXE (SHAD)] rpisplu:
========================================
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
========================================

[2008-07-29 20:47:32:226] [ORACLE.EXE (SHAD)] rpisplu:
========================================
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
========================================