SELECT * FROM v$sqltext; ADDRESS HASH_VALUE COMMAND_TY PIECE SQL_TEXT -------- ---------- ---------- ---------- ---------------------------------------------------------------- 04B8DBFC 4049165760 3 0 select order#,columns,types from access$ where d_obj#=:1 04BF78E4 88555323 6 2 re us#=:1 04BF78E4 88555323 6 1 undosqn=:7,xactsqn=:8,scnbas=:9,scnwrp=:10,inst#=:11,ts#=:12 whe 04BF78E4 88555323 6 0 update undo$ set name=:2,file#=:3,block#=:4,status$=:5,user#=:6, 04A828BC 403211495 3 0 select * from v$reserved_words 04BC2DA8 3359911567 3 3 # = u.user# 04BC2DA8 3359911567 3 2 and(i.flags, 512) = 512) and o.obj#=i.obj# and o.owner 04BC2DA8 3359911567 3 1 obj$ o, sys.user$ u where (bitand(i.flags, 256) = 256 or bit 04BC2DA8 3359911567 3 0 select i.obj#, i.flags, u.name, o.name from sys.ind$ i, sys. 04A830EC 1237095514 3 0 select * from v$process 04C33C48 1425443843 6 1 order$=:6,cache=:7,highwater=:8,audit$=:9 where obj#=:1 04C33C48 1425443843 6 0 update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5, 04AE5AC4 4003880563 2 3 ,:8,:9,:10,:11,:12,:13,:14,:15,0,0,:16,DECODE(:17,0,NULL,:17)) 04AE5AC4 4003880563 2 2 apranges,scanhint, hwmincr, spare1) values (:1,:2,:3,:4,:5,:6,:7 04AE5AC4 4003880563 2 1 maxexts,extsize,extpct,user#,iniexts,lists,groups,cachehint,bitm 04AE5AC4 4003880563 2 0 insert into seg$ (file#,block#,type#,ts#,blocks,extents,minexts, 04BF7600 571419723 3 0 select migrated from MIGRATE$ 04A98350 642842103 3 0 select * from v$log 04A34000 1318995164 3 0 select * from v$sess_io 04A293BC 2907312366 3 0 select * from v$sort_usage 04BF92FC 2185648096 3 0 select ctime, mtime, stime from obj$ where obj# = :1 04BA2E34 3441224864 3 0 SELECT USER FROM DUAL 04BE50E4 657604649 3 1 i.obj# not in (select d.p_obj# from sys.dependency$ d) 04BE50E4 657604649 3 0 select distinct i.obj# from sys.idl_ub1$ i where i.obj#>=:1 and 04B89E34 181436173 3 2 d piece#=0 04B89E34 181436173 3 1 l_sb4$ where obj#=:1 and version<=:2 and (part=0 or part=2) an 04B89E34 181436173 3 0 select /*+ index(idl_sb4$ i_idl_sb41) +*/ max(version) from id 04BC9BA0 1306010597 3 1 (select p_obj# from dependency$) 04BC9BA0 1306010597 3 0 select null from obj$ where obj#=:1 and type#=:2 and obj# not in 04B8EB5C 1737259834 3 2 j#=:1 and p_obj#=obj#(+) order by order# 04B8EB5C 1737259834 3 1 obj#, d_owner#, nvl(property,0) from dependency$,obj$ where d_ob 04B8EB5C 1737259834 3 0 select owner#,name,namespace,remoteowner,linkname,p_timestamp,p_ 04BF4E24 114078687 3 1 j#=:1 04BF4E24 114078687 3 0 select con#,obj#,rcon#,enabled,nvl(defer,0) from cdef$ where rob 04BD5A94 3865197965 3 1 r,audit$ from seq$ where obj#=:1 04BD5A94 3865197965 3 0 select increment$,minvalue,maxvalue,cycle#,order$,cache,highwate 04BCA358 32929334 3 3 dependency$ where p_obj# = o.obj#) 04BCA358 32929334 3 2 wner#=u.user# and o.type#=:1 and not exists (select p_obj# from 04BCA358 32929334 3 1 er),o.name,o.linkname,o.namespace from user$ u, obj$ o where o.o 04BCA358 32929334 3 0 select o.owner#,o.obj#,decode(o.linkname,null,u.name,o.remoteown 04B1CFF0 1203196177 3 0 select name,value from v$parameter 04C2C57C 1830513739 3 0 select line#, sql_text from bootstrap$ where obj# != :1 04ACD7B8 2363676478 7 0 delete from seg$ where ts#=:1 and file#=:2 and block#=:3 04BF5424 4059714361 3 2 VL(spare1,0) from seg$ where ts#=:1 and file#=:2 and block#=:3 04BF5424 4059714361 3 1 ,iniexts,NVL(lists,65535),NVL(groups,65535),cachehint,hwmincr, N 04BF5424 4059714361 3 0 select type#,blocks,extents,minexts,maxexts,extsize,extpct,user# 04BE538C 3559516504 3 4 ull and :6 is null) 04BE538C 3559516504 3 3 r linkname is null and :5 is null)and(subname=:6 or subname is n 04BE538C 3559516504 3 2 owner=:4 or remoteowner is null and :4 is null)and(linkname=:5 o 04BE538C 3559516504 3 1 rom obj$ where owner#=:1 and name=:2 and namespace=:3 and(remote 04BE538C 3559516504 3 0 select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oid$ f 04B97E90 4261939565 3 2 , grantee# order by col#, grantee# 04B97E90 4261939565 3 1 th$ where obj#=:1 and col# is not null group by privilege#, col# 04B97E90 4261939565 3 0 select col#, grantee#, privilege#,max(nvl(option$,0)) from objau 04A83C70 3111621964 3 0 select * from v$open_cursor 04A74730 2976789901 3 0 select * from v$rowcache 049F2450 173365511 3 0 select * from v$sqlarea 04B57F8C 3111103299 3 2 ece# 04B57F8C 3111103299 3 1 om idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by pi 04B57F8C 3111103299 3 0 select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#,length,piece fr 04BE5FF8 2454029093 3 0 select user#,type# from user$ where name=:1 04B83B4C 3218356218 3 2 ece# 04B83B4C 3218356218 3 1 om idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by pi 04B83B4C 3218356218 3 0 select /*+ index(idl_sb4$ i_idl_sb41) +*/ piece#,length,piece fr 04BFC0C0 108017046 3 0 select TOTAL from SYS.ID_GENS$ 04AA3490 817515201 3 0 select * from v$locks_with_collisions 04BD19D8 731738013 3 0 select file#, block#, ts# from seg$ where type# = 3 04A119F0 4108428236 3 0 select * from v$sql 04BA7868 2407357363 3 1 grantee#=:1 and privilege#<0 04BA7868 2407357363 3 0 select distinct(-privilege#),nvl(option$,0) from sysauth$ where 04B21DEC 1714733582 3 1 re t.ts#=f.ts# and t.dflextpct!=0 and t.bitmapped=0 04B21DEC 1714733582 3 0 select f.file#, f.block#, f.ts#, f.length from fet$ f, ts$ t whe 04AC9974 3438792944 3 0 select * from v$librarycache 04BF466C 1639440790 3 2 #=:1 04BF466C 1639440790 3 1 vl(enabled,0),rowid,cols,nvl(defer,0),mtime from cdef$ where obj 04BF466C 1639440790 3 0 select con#,type#,condlength,intcols,robj#,rcon#,match#,refact,n 04C32064 1855335687 35 0 alter database open 04AE1208 1877781575 7 0 delete from fet$ where file#=:1 and block#=:2 and ts#=:3 04ADEC1C 3687396716 2 1 h)values (:1, :2, :3, :4, :5, :6, :7) 04ADEC1C 3687396716 2 0 insert into uet$ (segfile#,segblock#,ext#,ts#,file#,block#,lengt 04B2EF50 37152082 3 0 select * from v$buffer_pool 04BFF70C 1464828376 3 2 bj# = :2 04BFF70C 1464828376 3 1 nvl(degree,1), nvl(instances,1) from ind$ where bo# = :1 and o 04BFF70C 1464828376 3 0 select blevel, leafcnt, distkey, lblkkey, dblkkey, clufac, 04BE3FD0 2216582187 3 5 re3,0) from tab$ where obj#=:1 04BE3FD0 2216582187 3 4 cols,nvl(trigflag, 0),nvl(spare1,0),nvl(spare2,0),spare4,nvl(spa 04BE3FD0 2216582187 3 3 property,nvl(degree,1),nvl(instances,1),avgspc_flb,flbcnt,kernel 04BE3FD0 2216582187 3 2 blkcnt,empcnt,avgspc,chncnt,avgrln,analyzetime, samplesize,cols, 04BE3FD0 2216582187 3 1 cols,0),audit$,flags,pctfree$,pctused$,initrans,maxtrans,rowcnt, 04BE3FD0 2216582187 3 0 select ts#,file#,block#,nvl(bobj#,0),nvl(tab#,0),intcols,nvl(clu 04B2635C 365454555 3 1 view$ where obj#=:1 04B2635C 365454555 3 0 select cols,audit$,textlength,intcols,property,flags,rowid from 04B9CFA8 2918884618 3 0 select node,owner,name from syn$ where obj#=:1 04BE8030 4195740643 3 0 select pos#,intcol#,col#,spare1 from icol$ where obj#=:1 04B2AB9C 2913840444 3 0 select length from fet$ where file#=:1 and block#=:2 and ts#=:3 04AD1D40 2249281901 6 4 and file#=:2 and block#=:3 04AD1D40 2249281901 6 3 int=:15, hwmincr=:16, spare1=DECODE(:17,0,NULL,:17) where ts#=:1 04AD1D40 2249281901 6 2 , 65535, NULL, :13),groups=decode(:14, 65535, NULL, :14), cacheh 04AD1D40 2249281901 6 1 =:8,extsize=:9,extpct=:10,user#=:11,iniexts=:12,lists=decode(:13 04AD1D40 2249281901 6 0 update seg$ set type#=:4,blocks=:5,extents=:6,minexts=:7,maxexts 04BA1770 3348238861 3 0 select audit$,options from procedure$ where obj#=:1 04A322E0 2917698161 3 0 select * from v$sga 04A29E7C 4191870745 3 0 select * from v$sgastat 04A94E98 1374013167 3 0 select * from v$mts 04B256E4 1966425544 3 0 select text from view$ where rowid=:1 04AAB570 2917842745 3 0 select * from v$locked_object 04C023FC 3558590804 3 1 nvl(instances,1) from tab$ where obj# = :1 04C023FC 3558590804 3 0 select rowcnt,blkcnt,empcnt,avgspc,chncnt,avgrln,nvl(degree,1), 04A7933C 2362318646 3 0 select * from v$rollname 04BFCCC4 3095957662 3 1 # = :2 04BFCCC4 3095957662 3 0 select charsetid, charsetform from col$ where obj# = :1 and col 04BB9C8C 2896599675 3 2 EFAULT_CONSUMER_GROUP',defschclass) from user$ where user#=:1 04BB9C8C 2896599675 3 1 ime, exptime, ltime, astatus, lcount, decode(defschclass,NULL,'D 04BB9C8C 2896599675 3 0 select name,password,datats#,tempts#,type#,defrole,resource$, pt 04BDD9BC 906438690 3 3 orm,spare1,spare2 from col$ where obj#=:1 order by intcol# 04BDD9BC 906438690 3 2 vl(deflength,0),default$,rowid,col#,property, charsetid,charsetf 04BDD9BC 906438690 3 1 e(type#,2,nvl(scale,-127/*MAXSB1MINAL*/),0),null$,fixedstorage,n 04BDD9BC 906438690 3 0 select name,intcol#,segcol#,type#,length,nvl(precision#,0),decod 04AF12BC 3230982141 2 0 insert into fet$ (file#,block#,ts#,length) values (:1,:2,:3,:4) 04A1E5C8 2326777235 3 0 select * from v$sql_shared_memory 049E8D08 386683018 3 0 select * from v$sqltext 04A0E100 1685909591 3 0 select * from v$sql_cursor 04ABC368 4096703100 3 0 select * from v$lock 04B13B30 2255300421 3 0 select * from v$controlfile 04A87004 1693537999 3 0 select * from v$mystat 04C32E4C 3537154326 42 3 N-YY' NLS_DATE_LANGUAGE= 'AMERICAN' NLS_SORT= 'BINARY' 04C32E4C 3537154326 42 2 ARACTERS= '.,' NLS_CALENDAR= 'GREGORIAN' NLS_DATE_FORMAT= 'DD-MO 04C32E4C 3537154326 42 1 CA' NLS_CURRENCY= '$' NLS_ISO_CURRENCY= 'AMERICA' NLS_NUMERIC_CH 04C32E4C 3537154326 42 0 ALTER SESSION SET NLS_LANGUAGE= 'AMERICAN' NLS_TERRITORY= 'AMERI 04BDBFA8 199702406 3 10 led) c where i.obj#=c.enabled(+) and i.bo#=:1 04BDBFA8 199702406 3 9 )) valid# from cdef$ where obj#=:1 and enabled > 1 group by enab 04BDBFA8 199702406 3 8 ber(bitand(defer,1))) deferrable#, min(to_number(bitand(defer,4) 04BDBFA8 199702406 3 7 56)) from ind$ i, (select enabled, min(cols) unicols, min(to_num 04BDBFA8 199702406 3 6 pare2,decode(i.pctthres$,null,null, mod(trunc(i.pctthres$/256),2 04BDBFA8 199702406 3 5 vl(c.deferrable#+c.valid#,0), nvl(i.spare1,i.intcols),i.spare4,s 04BDBFA8 199702406 3 4 ,mod(i.pctthres$,256),i.indmethod#,i.trunccnt,nvl(c.unicols,0),n 04BDBFA8 199702406 3 3 mplesize,i.dataobj#, nvl(i.degree,1),nvl(i.instances,1),i.rowcnt 04BDBFA8 199702406 3 2 .distkey, i.lblkkey,i.dblkkey,i.clufac,i.cols,i.analyzetime,i.sa 04BDBFA8 199702406 3 1 i.property,i.pctfree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i 04BDBFA8 199702406 3 0 select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags, 04A655CC 1426729873 3 0 select * from v$session 04BCF964 1158616671 3 0 select metadata from kopm$ where name='DB_FDO' 04AEDC98 1705880752 3 0 select file# from file$ where ts#=:1 04ACBE34 1451656631 3 0 select * from v$instance 04B522DC 1428100621 3 2 ece# 04B522DC 1428100621 3 1 om idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by pi 04B522DC 1428100621 3 0 select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#,length,piece fr 04BC2978 2860469381 3 3 er# order by o.obj# 04BC2978 2860469381 3 2 r$.property < 16 and trigger$.obj# = o.obj# and o.owner# = u.us 04BC2978 2860469381 3 1 j$ o, user$ u, trigger$ where trigger$.property >= 8 and trigge 04BC2978 2860469381 3 0 select u.name, o.name, trigger$.sys_evts, trigger$.type# from ob 04B85564 1668540021 3 1 .bo# = :1 and o.name = :2 04B85564 1668540021 3 0 select i.obj# from ind$ i, obj$ o where i.obj# = o.obj# and i 04BA9EB4 3013728279 3 2 1) and privilege#>0 04BA9EB4 3013728279 3 1 privilege# and privilege#>0 start with (grantee#=:1 or grantee#= 04BA9EB4 3013728279 3 0 select privilege#,level from sysauth$ connect by grantee#=prior 04AEBCE4 2860308056 6 1 :3 04AEBCE4 2860308056 6 0 update fet$ set length=:4 where file#=:1 and block#=:2 and ts# = 04BA54E4 2372012154 42 7 'DD-MON-YY HH.MI.SSXFF AM TZH:TZM' 04BA54E4 2372012154 42 6 _TZ_FORMAT = 'HH.MI.SSXFF AM TZH:TZM' NLS_TIMESTAMP_TZ_FORMAT = 04BA54E4 2372012154 42 5 F AM' NLS_TIMESTAMP_FORMAT = 'DD-MON-YY HH.MI.SSXFF AM' NLS_TIME 04BA54E4 2372012154 42 4 E= '00:00' NLS_DUAL_CURRENCY = '$' NLS_TIME_FORMAT = 'HH.MI.SSXF 04BA54E4 2372012154 42 3 N-YY' NLS_DATE_LANGUAGE= 'AMERICAN' NLS_SORT= 'BINARY' TIME_ZON 04BA54E4 2372012154 42 2 ARACTERS= '.,' NLS_CALENDAR= 'GREGORIAN' NLS_DATE_FORMAT= 'DD-MO 04BA54E4 2372012154 42 1 CA' NLS_CURRENCY= '$' NLS_ISO_CURRENCY= 'AMERICA' NLS_NUMERIC_CH 04BA54E4 2372012154 42 0 ALTER SESSION SET NLS_LANGUAGE= 'AMERICAN' NLS_TERRITORY= 'AMERI 04B3F090 4279157786 3 3 idx.obj#=i.bo# 04B3F090 4279157786 3 2 = 512 and o.obj#=idx.obj# and o.owner# = u.user# and 04B3F090 4279157786 3 1 sys.obj$ o, sys.user$ u, ind$ idx where bitand(i.flags, 512) 04B3F090 4279157786 3 0 select i.obj#, i.flags, u.name, o.name from sys.indpart$ i, 04AE85C4 1839874543 3 1 2 and segblock#=:3 and ext#=:4 04AE85C4 1839874543 3 0 select file#,block#,length from uet$ where ts#=:1 and segfile#=: 04B99FA8 607327990 47 0 BEGIN DBMS_OUTPUT.DISABLE; END; 04B0DE48 1614337686 3 0 select * from v$datafile 04A58E18 2895793545 3 0 select * from v$session_wait 04BF32A0 2077477810 3 0 select value$ from sys.props$ where name = :1 04B976D8 1004464078 3 2 order by grantee# 04B976D8 1004464078 3 1 objauth$ where obj#=:1 group by grantee#,privilege#,nvl(col#,0) 04B976D8 1004464078 3 0 select grantee#,privilege#,nvl(col#,0),max(nvl(option$,0)) from 04A3E5DC 2630319514 3 0 select * from v$sesstat 04AB6EB0 1357350217 3 0 select * from v$lock_activity 04B104EC 3663816533 3 0 select * from v$filestat 04BAEB9C 123567310 3 1 nd type#=:3 04BAEB9C 123567310 3 0 select limit# from profile$ where profile#=:1 and resource#=:2 a 04B32E54 570441826 3 4 om ts$ where ts#=:1 04B32E54 570441826 3 3 bitmapped, inc#, flags, plugged, NVL(spare1,0), NVL(spare2,0) fr 04B32E54 570441826 3 2 nwrp,scnbas, NVL(pitrscnwrp, 0), NVL(pitrscnbas, 0), dflogging, 04B32E54 570441826 3 1 maxext,dflinit,dflincr,dflextpct,dflminext, dflminlen, owner#,sc 04B32E54 570441826 3 0 select name,online$,contents$,undofile#,undoblock#,blocksize,dfl 04BC47C0 252991768 3 1 .owner# = 0 and bitand(o.flags, 2) = 2 and o.type# = 2 04BC47C0 252991768 3 0 select o.name from obj$ o where o.name like 'ORA_TEMP_1_%' and o 04BCCA54 505350413 3 0 select location_name from loc$ 04B57834 957616262 3 2 piece# 04B57834 957616262 3 1 from idl_char$ where obj#=:1 and part=:2 and version=:3 order by 04B57834 957616262 3 0 select /*+ index(idl_char$ i_idl_char1) +*/ piece#,length,piece 04C2B430 690085868 3 1 bj$ o where d.p_obj#>=:1 and d.d_obj#=o.obj# and o.status!=5 04C2B430 690085868 3 0 select distinct d.p_obj#,d.p_timestamp from sys.dependency$ d, o 04C0199C 3172683996 3 1 nwrp,DECODE(inst#,0,NULL,inst#),ts# from undo$ where us#=:1 04C0199C 3172683996 3 0 select name,file#,block#,status$,user#,undosqn,xactsqn,scnbas,sc 04BF1470 2085632044 3 0 select intcol#,nvl(pos#,0),col# from ccol$ where con#=:1 04B435F0 3625995331 3 4 from pending_trans$ where session_vector != '00000000' 04B435F0 3625995331 3 3 4*(sysdate-nvl(heuristic_time,fail_time)), global_commit#, type# 04B435F0 3625995331 3 2 _vector, reco_vector, 3600*24*(sysdate-reco_time), 3600*2 04B435F0 3625995331 3 1 foreign_id, state, status, heuristic_dflt, session 04B435F0 3625995331 3 0 select local_tran_id, global_tran_fmt, global_oracle_id, global_ 04A714BC 3514189410 3 0 select * from v$rollstat 04A4EB94 3035851572 3 0 select * from v$session_object_cache 04BD4E04 189272129 3 1 bname,o.dataobj#,o.flags from obj$ o where o.obj#=:1 04BD4E04 189272129 3 0 select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.su 04AEC514 904892542 3 1 ts#=:2 and file#=:3 04AEC514 904892542 3 0 select file#,block#,length from fet$ where length>=:1 and 04ACAF70 528349613 7 1 nd ext#=:4 04ACAF70 528349613 7 0 delete from uet$ where ts#=:1 and segfile#=:2 and segblock#=:3 a 04BA20F4 2564072224 3 3 .user# order by o.obj# 04BA20F4 2564072224 3 2 er$.baseobject = :1 and trigger$.obj# = o.obj# and o.owner# = u 04BA20F4 2564072224 3 1 j$ o, user$ u, trigger$ where trigger$.property >= 16 and trigg 04BA20F4 2564072224 3 0 select u.name, o.name, trigger$.sys_evts, trigger$.type# from ob 04C32758 3831314764 35 0 ALTER DATABASE MOUNT EXCLUSIVE 04B16404 1983454399 3 0 select * from v$database