[2008-07-29 20:48:06:101] Oracle SPY, built at Jul 29 2008 20:07:18 -- Dennis Yurichev http://blogs.conus.info [2008-07-29 20:48:10:413] [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:48:10:429] [ORACLE.EXE (SHAD)] rpisplu: ======================================== select node,owner,name from syn$ where obj#=:1 ======================================== [2008-07-29 20:48:10:476] [ORACLE.EXE (SHAD)] rpisplu: ======================================== select order#,columns,types from access$ where d_obj#=:1 ======================================== [2008-07-29 20:48:10:632] [ORACLE.EXE (SHAD)] rpisplu: ======================================== select cols,audit$,textlength,intcols,property,flags,rowid from view$ where obj#=:1 ======================================== [2008-07-29 20:48:10:695] [ORACLE.EXE (SHAD)] rpisplu: ======================================== select order#,columns,types from access$ where d_obj#=:1 ======================================== [2008-07-29 20:48:10:695] [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:48:10:726] [ORACLE.EXE (SHAD)] rpisplu: ======================================== select text from view$ where rowid=:1 ======================================== [2008-07-29 20:48:10:742] [ORACLE.EXE (SHAD)] kprbprs: ======================================== select timestamp, flags from fixed_obj$ where obj#=:1 ======================================== [2008-07-29 20:48:10:773] [ORACLE.EXE (SHAD)] rpisplu: ======================================== select BANNER from GV$VERSION where inst_id = USERENV('Instance') ======================================== [2008-07-29 20:48:10:820] [ORACLE.EXE (SHAD)] kprbprs: ======================================== select timestamp, flags from fixed_obj$ where obj#=:1 ======================================== [2008-07-29 20:48:10:851] [ORACLE.EXE (SHAD)] kprbprs: ======================================== select timestamp, flags from fixed_obj$ where obj#=:1 ======================================== [2008-07-29 20:48:10:851] [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:48:10:882] [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:48:10:882] [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:48:10:898] [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:48:10:898] [ORACLE.EXE (SHAD)] rpisplu: ======================================== select col#,intcol#,ntab# from ntab$ where obj#=:1 order by intcol# asc ======================================== [2008-07-29 20:48:10:913] [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:48:10:913] [ORACLE.EXE (SHAD)] rpisplu: ======================================== select col#,intcol#,reftyp,stabid,expctoid from refcon$ where obj#=:1 order by intcol# asc ======================================== [2008-07-29 20:48:10:913] [ORACLE.EXE (SHAD)] rpisplu: ======================================== select col#,intcol#,charsetid,charsetform from col$ where obj#=:1 order by intcol# asc ======================================== [2008-07-29 20:48:10:913] [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:48:10:929] [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:48:12:788] [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 ========================================