SELECT * FROM v$sql; SQL_TEXT SHARABLE_M PERSISTENT RUNTIME_ME SORTS LOADED_VER OPEN_VERSI USERS_OPEN EXECUTIONS USERS_EXEC LOADS FIRST_LOAD_TIME INVALIDATI PARSE_CALL DISK_READS BUFFER_GET ROWS_PROCE COMMAND_TY OPTIMIZER_ OPTIMIZER_ PARSING_US PARSING_SC KEPT_VERSI ADDRESS TYPE_CHK HASH_VALUE CHILD_NUMB MODULE MODULE_HAS ACTION ACTION_HAS SERIALIZAB OUTLINE_CATEGORY -------------------------------------------------------------------------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ------------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- -------- -------- ---------- ---------- ---------------------------------------------------------------- ---------- ---------------------------------------------------------------- ---------- ---------- ---------------------------------------------------------------- select order#,columns,types from access$ where d_obj#=:1 5565 604 1644 0 1 0 0 34 0 1 2000-07-20/21:12:44 0 34 46 195 32 3 CHOOSE 0 0 0 0 04B8DBFC 00 4049165760 0 0 0 0 update undo$ set name=:2,file#=:3,block#=:4,status$=:5,user#=:6,undosqn=:7,xacts 1334 0 0 0 0 0 0 30 0 1 2000-07-20/21:12:09 0 0 0 0 0 6 NONE 0 0 0 04BF78E4 00 88555323 0 0 0 0 select * from v$reserved_words 8431 544 564 0 1 0 0 1 0 1 2000-07-20/22:03:46 0 1 7 38 639 3 CHOOSE 0 5 5 0 04A828BC 00 403211495 0 0 0 0 select i.obj#, i.flags, u.name, o.name from sys.ind$ i, sys.obj$ o, sys.user 10568 644 3952 0 1 0 0 1 0 1 2000-07-20/21:12:14 0 1 3562 42032 0 3 CHOOSE 0 0 0 0 04BC2DA8 00 3359911567 0 0 0 0 select * from v$process 20948 960 1760 0 1 0 0 1 0 1 2000-07-20/22:03:12 0 1 5 42 8 3 CHOOSE 0 5 5 0 04A830EC 00 1237095514 0 0 0 0 update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,order$=:6,cache= 8032 608 3212 0 1 0 0 2 0 1 2000-07-20/21:12:40 0 2 14 53 2 6 CHOOSE 0 0 0 0 04C33C48 00 1425443843 0 0 0 0 insert into seg$ (file#,block#,type#,ts#,blocks,extents,minexts,maxexts,extsize, 12115 796 2272 0 1 0 0 1 0 1 2000-07-20/21:58:25 0 1 5 102 1 2 CHOOSE 0 0 0 0 04AE5AC4 00 4003880563 0 0 0 0 select migrated from MIGRATE$ 3622 480 1032 0 1 0 0 1 0 1 2000-07-20/21:12:12 0 1 6 18 1 3 CHOOSE 0 0 0 0 04BF7600 00 571419723 0 0 0 0 select * from v$log 28772 912 6392 2 1 0 0 1 0 1 2000-07-20/22:01:56 0 1 2 38 4 3 CHOOSE 0 5 5 0 04A98350 00 642842103 0 0 0 0 select * from v$sess_io 13808 752 1132 0 1 0 0 1 0 1 2000-07-20/22:06:08 0 1 5 38 7 3 CHOOSE 0 5 5 0 04A34000 00 1318995164 0 0 0 0 select * from v$sort_usage 56219 1076 4248 2 1 0 0 1 0 1 2000-07-20/22:06:58 0 1 3 38 0 3 CHOOSE 0 5 5 0 04A293BC 00 2907312366 0 0 0 0 select ctime, mtime, stime from obj$ where obj# = :1 897 0 0 0 0 0 0 52 0 1 2000-07-20/21:12:08 0 0 0 0 0 3 NONE 0 0 0 04BF92FC 00 2185648096 0 0 0 0 SELECT USER FROM DUAL 3879 480 1000 0 1 0 0 1 0 1 2000-07-20/21:12:41 0 1 39 113 1 3 CHOOSE 0 5 5 0 04BA2E34 00 3441224864 0 0 0 0 select distinct i.obj# from sys.idl_ub1$ i where i.obj#>=:1 and i.obj# not in (s 6919 504 2304 1 1 0 0 1 0 1 2000-07-20/21:12:11 0 1 45 801 0 3 CHOOSE 0 0 0 0 04BE50E4 00 657604649 0 0 0 0 select /*+ index(idl_sb4$ i_idl_sb41) +*/ max(version) from idl_sb4$ where obj 7083 520 1740 1 1 0 0 8 0 1 2000-07-20/21:12:44 0 8 13 72 8 3 CHOOSE 2 0 0 0 04B89E34 00 181436173 0 0 0 0 select null from obj$ where obj#=:1 and type#=:2 and obj# not in (select p_obj# 12538 504 0 0 1 0 0 0 0 1 2000-07-20/21:12:13 0 1 0 0 0 3 CHOOSE 0 0 0 0 04BC9BA0 04BC8ABC 1306010597 0 0 0 0 select owner#,name,namespace,remoteowner,linkname,p_timestamp,p_obj#, d_owner#, 10141 920 3532 1 1 0 0 34 0 1 2000-07-20/21:12:44 0 34 44 223 37 3 CHOOSE 0 0 0 0 04B8EB5C 00 1737259834 0 0 0 0 select con#,obj#,rcon#,enabled,nvl(defer,0) from cdef$ where robj#=:1 7222 708 1660 0 1 0 0 5 0 2 2000-07-20/21:12:09 0 3 3 5 0 3 CHOOSE 0 0 0 0 04BF4E24 00 114078687 0 0 0 0 select increment$,minvalue,maxvalue,cycle#,order$,cache,highwater,audit$ from se 6857 864 1804 0 1 0 0 2 0 1 2000-07-20/21:12:12 0 2 10 24 2 3 CHOOSE 0 0 0 0 04BD5A94 00 3865197965 0 0 0 0 select o.owner#,o.obj#,decode(o.linkname,null,u.name,o.remoteowner),o.name,o.lin 11771 768 4056 0 1 0 0 1 0 1 2000-07-20/21:12:13 0 1 427 511 0 3 CHOOSE 0 0 0 0 04BCA358 00 32929334 0 0 0 0 select name,value from v$parameter 19191 548 2760 1 1 0 0 2 0 1 2000-07-20/21:20:35 0 2 12 39 390 3 CHOOSE 0 5 5 0 04B1CFF0 00 1203196177 0 0 0 0 select line#, sql_text from bootstrap$ where obj# != :1 900 0 0 0 0 0 0 1 0 1 2000-07-20/21:12:07 0 0 0 0 0 3 NONE 0 0 0 04C2C57C 00 1830513739 0 0 0 0 delete from seg$ where ts#=:1 and file#=:2 and block#=:3 6137 488 3236 0 1 0 0 1 0 1 2000-07-20/21:58:25 0 1 1 11 1 7 CHOOSE 0 0 0 0 04ACD7B8 00 2363676478 0 0 0 0 select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts,NVL(lis 10011 1216 2844 0 1 0 0 30 0 2 2000-07-20/21:12:09 0 30 37 96 29 3 CHOOSE 0 0 0 0 04BF5424 00 4059714361 0 0 0 0 select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oid$ from obj$ where o 12180 1076 2696 0 1 0 0 133 0 2 2000-07-20/21:12:09 0 39 95 499 99 3 CHOOSE 0 0 0 0 04BE538C 00 3559516504 0 0 0 0 select col#, grantee#, privilege#,max(nvl(option$,0)) from objauth$ where obj#=: 7731 656 2012 1 1 0 0 31 0 1 2000-07-20/21:12:42 0 31 18 112 0 3 CHOOSE 0 0 0 0 04B97E90 00 4261939565 0 0 0 0 select * from v$open_cursor 12884 752 988 0 1 0 0 1 0 1 2000-07-20/22:02:50 0 1 1 38 1 3 CHOOSE 0 5 5 0 04A83C70 00 3111621964 0 0 0 0 select * from v$rowcache 24321 1324 2108 0 1 0 0 1 0 1 2000-07-20/22:04:37 0 1 3 39 23 3 CHOOSE 0 5 5 0 04A74730 00 2976789901 0 0 0 0 select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#,length,piece from idl_ub1$ wher 7361 644 1736 0 1 0 0 8 0 1 2000-07-20/21:12:45 0 8 22 52 7 3 CHOOSE 3 0 0 0 04B57F8C 00 3111103299 0 0 0 0 select user#,type# from user$ where name=:1 5828 552 1372 0 1 0 0 2 0 2 2000-07-20/21:12:09 0 2 4 4 2 3 CHOOSE 0 0 0 0 04BE5FF8 00 2454029093 0 0 0 0 select /*+ index(idl_sb4$ i_idl_sb41) +*/ piece#,length,piece from idl_sb4$ wher 7065 644 1736 0 1 0 0 8 0 1 2000-07-20/21:12:45 0 8 12 58 11 3 CHOOSE 3 0 0 0 04B83B4C 00 3218356218 0 0 0 0 select TOTAL from SYS.ID_GENS$ 3595 480 1032 0 1 0 0 1 0 1 2000-07-20/21:12:12 0 1 6 18 1 3 CHOOSE 0 0 0 0 04BFC0C0 00 108017046 0 0 0 0 select * from v$locks_with_collisions 23158 500 2236 3 1 0 0 1 0 1 2000-07-20/22:01:39 0 1 3 38 0 3 CHOOSE 0 5 5 0 04AA3490 00 817515201 0 0 0 0 select file#, block#, ts# from seg$ where type# = 3 4960 584 1264 0 1 0 0 1 0 1 2000-07-20/21:12:12 0 1 65 68 0 3 CHOOSE 0 0 0 0 04BD19D8 00 731738013 0 0 0 0 select * from v$sql 48472 2156 6980 0 1 1 1 1 1 1 2000-07-20/22:07:13 0 1 4 40 20 3 CHOOSE 0 5 5 0 04A119F0 00 4108428236 0 0 0 0 select distinct(-privilege#),nvl(option$,0) from sysauth$ where grantee#=:1 and 6597 552 1724 1 1 0 0 7 0 1 2000-07-20/21:12:41 0 7 1 61 186 3 CHOOSE 0 0 0 0 04BA7868 00 2407357363 0 0 0 0 select f.file#, f.block#, f.ts#, f.length from fet$ f, ts$ t where t.ts#=f.ts# a 7836 640 2000 0 1 0 0 10 0 1 2000-07-20/21:18:11 0 10 14 490 130 3 CHOOSE 0 0 0 0 04B21DEC 00 1714733582 0 0 0 0 select * from v$librarycache 25945 1168 2132 0 1 0 0 1 0 1 2000-07-20/21:59:42 0 1 3 39 8 3 CHOOSE 0 5 5 0 04AC9974 00 3438792944 0 0 0 0 select con#,type#,condlength,intcols,robj#,rcon#,match#,refact,nvl(enabled,0),ro 9165 1124 2412 0 1 0 0 5 0 2 2000-07-20/21:12:09 0 3 10 56 40 3 CHOOSE 0 0 0 0 04BF466C 00 1639440790 0 0 0 0 alter database open 864 0 0 0 0 0 0 1 0 1 2000-07-20/21:12:05 0 0 0 0 0 35 NONE 0 0 0 04C32064 00 1855335687 0 0 0 0 delete from fet$ where file#=:1 and block#=:2 and ts#=:3 5997 488 2964 0 1 0 0 5 0 1 2000-07-20/21:58:25 0 5 0 27 5 7 CHOOSE 0 0 0 0 04AE1208 00 1877781575 0 0 0 0 insert into uet$ (segfile#,segblock#,ext#,ts#,file#,block#,length)values (:1, :2 7738 576 1668 0 1 0 0 4 0 1 2000-07-20/21:58:25 0 4 0 54 4 2 CHOOSE 0 0 0 0 04ADEC1C 00 3687396716 0 0 0 0 select * from v$buffer_pool 13880 856 940 0 1 0 0 4 0 1 2000-07-20/21:15:57 0 4 40 65 16 3 CHOOSE 0 5 5 0 04B2EF50 00 37152082 0 0 0 0 select blevel, leafcnt, distkey, lblkkey, dblkkey, clufac, nvl(degree,1), 981 0 0 0 0 0 0 29 0 1 2000-07-20/21:12:08 0 0 0 0 0 3 NONE 0 0 0 04BFF70C 00 1464828376 0 0 0 0 select ts#,file#,block#,nvl(bobj#,0),nvl(tab#,0),intcols,nvl(clucols,0),audit$,f 15475 2164 6212 0 1 0 0 22 0 2 2000-07-20/21:12:10 0 7 33 67 22 3 CHOOSE 0 0 0 0 04BE3FD0 00 2216582187 0 0 0 0 select cols,audit$,textlength,intcols,property,flags,rowid from view$ where obj# 6524 812 1672 0 1 0 0 30 0 1 2000-07-20/21:15:57 0 30 38 117 30 3 CHOOSE 0 0 0 0 04B2635C 00 365454555 0 0 0 0 select node,owner,name from syn$ where obj#=:1 5407 604 1632 0 1 0 0 31 0 1 2000-07-20/21:12:42 0 31 22 120 31 3 CHOOSE 0 0 0 0 04B9CFA8 00 2918884618 0 0 0 0 select pos#,intcol#,col#,spare1 from icol$ where obj#=:1 6185 656 1496 0 1 0 0 20 0 1 2000-07-20/21:12:10 0 7 18 128 44 3 CHOOSE 0 0 0 0 04BE8030 00 4195740643 0 0 0 0 select length from fet$ where file#=:1 and block#=:2 and ts#=:3 6064 540 1572 0 1 0 0 22 0 1 2000-07-20/21:18:11 0 22 1 52 1 3 CHOOSE 0 0 0 0 04B2AB9C 00 2913840444 0 0 0 0 update seg$ set type#=:4,blocks=:5,extents=:6,minexts=:7,maxexts=:8,extsize=:9,e 14172 828 5172 0 1 0 0 3 0 1 2000-07-20/21:58:25 0 3 0 23 3 6 CHOOSE 0 0 0 0 04AD1D40 00 2249281901 0 0 0 0 select audit$,options from procedure$ where obj#=:1 5460 552 1348 0 1 0 0 4 0 1 2000-07-20/21:12:43 0 4 25 40 4 3 CHOOSE 0 0 0 0 04BA1770 00 3348238861 0 0 0 0 select * from v$sga 8360 544 476 0 1 0 0 1 0 1 2000-07-20/22:06:20 0 1 1 39 4 3 CHOOSE 0 5 5 0 04A322E0 00 2917698161 0 0 0 0 select * from v$sgastat 15824 604 1156 0 1 0 0 1 0 1 2000-07-20/22:06:31 0 1 3 39 40 3 CHOOSE 0 5 5 0 04A29E7C 00 4191870745 0 0 0 0 select * from v$mts 10996 648 792 0 1 0 0 1 0 1 2000-07-20/22:02:12 0 1 5 38 1 3 CHOOSE 0 5 5 0 04A94E98 00 1374013167 0 0 0 0 select text from view$ where rowid=:1 4602 500 580 0 1 0 0 30 0 1 2000-07-20/21:15:57 0 30 0 60 30 3 CHOOSE 0 0 0 0 04B256E4 00 1966425544 0 0 0 0 select * from v$locked_object 19146 916 2828 4 1 0 0 1 0 1 2000-07-20/22:01:15 0 1 3 38 0 3 CHOOSE 0 5 5 0 04AAB570 00 2917842745 0 0 0 0 select rowcnt,blkcnt,empcnt,avgspc,chncnt,avgrln,nvl(degree,1), nvl(instances,1) 951 0 0 0 0 0 0 18 0 1 2000-07-20/21:12:08 0 0 0 0 0 3 NONE 0 0 0 04C023FC 00 3558590804 0 0 0 0 select * from v$rollname 7821 540 1556 0 1 0 0 1 0 1 2000-07-20/22:04:14 0 1 6 77 16 3 CHOOSE 0 5 5 0 04A7933C 00 2362318646 0 0 0 0 select charsetid, charsetform from col$ where obj# = :1 and col# = :2 915 0 0 0 0 0 0 45 0 1 2000-07-20/21:12:08 0 0 0 0 0 3 NONE 0 0 0 04BFCCC4 00 3095957662 0 0 0 0 select name,password,datats#,tempts#,type#,defrole,resource$, ptime, exptime, lt 8850 1124 2388 0 1 0 0 9 0 1 2000-07-20/21:12:40 0 9 3 18 9 3 CHOOSE 0 0 0 0 04BB9C8C 00 2896599675 0 0 0 0 select name,intcol#,segcol#,type#,length,nvl(precision#,0),decode(type#,2,nvl(sc 11519 1384 3224 1 1 0 0 52 0 2 2000-07-20/21:12:10 0 36 34 160 484 3 CHOOSE 0 0 0 0 04BDD9BC 00 906438690 0 0 0 0 insert into fet$ (file#,block#,ts#,length) values (:1,:2,:3,:4) 5872 516 1520 0 1 0 0 5 0 1 2000-07-20/21:58:24 0 5 7 39 5 2 CHOOSE 0 0 0 0 04AF12BC 00 3230982141 0 0 0 0 select * from v$lock 51525 996 4696 0 1 0 0 1 0 1 2000-07-20/22:00:24 0 1 4 39 6 3 CHOOSE 7 5 5 0 04ABC368 00 4096703100 0 0 0 0 select * from v$controlfile 9904 544 2172 0 1 0 0 1 0 1 2000-07-20/21:56:49 0 1 3 40 2 3 CHOOSE 0 5 5 0 04B13B30 00 2255300421 0 0 0 0 select * from v$mystat 11987 600 1304 1 1 0 0 1 0 1 2000-07-20/22:02:31 0 1 2 38 196 3 CHOOSE 0 5 5 0 04A87004 00 1693537999 0 0 0 0 ALTER SESSION SET NLS_LANGUAGE= 'AMERICAN' NLS_TERRITORY= 'AMERICA' NLS_CURRENCY 3275 420 220 0 1 0 0 36 0 2 2000-07-20/21:11:58 0 36 0 0 0 42 CHOOSE 0 5 5 0 04C32E4C 00 3537154326 0 0 0 0 select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags, i.property,i.pct 24714 2192 9068 3 1 0 0 22 0 2 2000-07-20/21:12:10 0 7 32 120 20 3 CHOOSE 0 0 0 0 04BDBFA8 00 199702406 0 0 0 0 select * from v$session 69096 2728 6848 0 1 0 0 1 0 1 2000-07-20/22:04:57 0 1 3 40 7 3 CHOOSE 0 5 5 0 04A655CC 00 1426729873 0 0 0 0 select metadata from kopm$ where name='DB_FDO' 5160 480 1744 0 1 0 0 1 0 1 2000-07-20/21:12:12 0 1 5 22 1 3 CHOOSE 0 0 0 0 04BCF964 00 1158616671 0 0 0 0 select file# from file$ where ts#=:1 5501 500 1280 0 1 0 0 4 0 1 2000-07-20/21:58:24 0 4 2 12 4 3 CHOOSE 0 0 0 0 04AEDC98 00 1705880752 0 0 0 0 select * from v$instance 26801 1120 2336 0 1 0 0 1 0 1 2000-07-20/21:58:59 0 1 3 40 1 3 CHOOSE 0 5 5 0 04ACBE34 00 1451656631 0 0 0 0 select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#,length,piece from idl_ub2$ wher 7033 644 1736 0 1 0 0 8 0 1 2000-07-20/21:12:46 0 8 118 218 21 3 CHOOSE 3 0 0 0 04B522DC 00 1428100621 0 0 0 0 select u.name, o.name, trigger$.sys_evts, trigger$.type# from obj$ o, user$ u, 9972 644 4088 1 1 0 0 1 0 1 2000-07-20/21:12:13 0 1 8 38 0 3 CHOOSE 0 0 0 0 04BC2978 00 2860469381 0 0 0 0 select i.obj# from ind$ i, obj$ o where i.obj# = o.obj# and i.bo# = :1 and o. 9606 524 2604 0 1 0 0 5 0 1 2000-07-20/21:12:45 0 5 3 30 5 3 CHOOSE 0 0 0 0 04B85564 00 1668540021 0 0 0 0 select privilege#,level from sysauth$ connect by grantee#=prior privilege# and p 8344 556 3080 0 1 0 0 36 0 1 2000-07-20/21:12:41 0 36 17 1434 396 3 CHOOSE 0 0 0 0 04BA9EB4 00 3013728279 0 0 0 0 update fet$ set length=:4 where file#=:1 and block#=:2 and ts# = :3 6368 508 3116 0 1 0 0 1 0 1 2000-07-20/21:58:25 0 1 0 6 1 6 CHOOSE 0 0 0 0 04AEBCE4 00 2860308056 0 0 0 0 ALTER SESSION SET NLS_LANGUAGE= 'AMERICAN' NLS_TERRITORY= 'AMERICA' NLS_CURRENCY 5031 420 260 0 1 0 0 1 0 1 2000-07-20/21:12:41 0 1 0 0 0 42 CHOOSE 0 0 0 0 04BA54E4 00 2372012154 0 0 0 0 select i.obj#, i.flags, u.name, o.name from sys.indpart$ i, sys.obj$ o, sys. 12160 648 4912 0 1 0 0 1 0 1 2000-07-20/21:13:02 0 1 869 2224 0 3 CHOOSE 0 0 0 0 04B3F090 00 4279157786 0 0 0 0 select file#,block#,length from uet$ where ts#=:1 and segfile#=:2 and segblock#= 6935 664 1948 0 1 0 0 4 0 1 2000-07-20/21:58:25 0 4 2 11 0 3 CHOOSE 0 0 0 0 04AE85C4 00 1839874543 0 0 0 0 BEGIN DBMS_OUTPUT.DISABLE; END; 10088 420 148 0 1 0 0 1 0 1 2000-07-20/21:12:43 0 1 292 620 1 47 CHOOSE 0 5 5 0 04B99FA8 00 607327990 0 0 0 0 select * from v$datafile 49141 1592 13112 4 1 0 0 1 0 1 2000-07-20/21:58:04 0 1 9 39 5 3 CHOOSE 0 5 5 0 04B0DE48 00 1614337686 0 0 0 0 select * from v$session_wait 25657 1224 2848 1 1 0 0 1 0 1 2000-07-20/22:05:30 0 1 6 38 7 3 CHOOSE 0 5 5 0 04A58E18 00 2895793545 0 0 0 0 select value$ from sys.props$ where name = :1 890 0 0 0 0 0 0 18 0 1 2000-07-20/21:12:09 0 0 0 0 0 3 NONE 0 0 0 04BF32A0 00 2077477810 0 0 0 0 select grantee#,privilege#,nvl(col#,0),max(nvl(option$,0)) from objauth$ where o 7626 656 2044 1 1 0 0 32 0 1 2000-07-20/21:12:42 0 32 8 109 44 3 CHOOSE 0 0 0 0 04B976D8 00 1004464078 0 0 0 0 select * from v$sesstat 11896 600 1304 1 1 0 0 1 0 1 2000-07-20/22:05:55 0 1 0 38 1372 3 CHOOSE 0 5 5 0 04A3E5DC 00 2630319514 0 0 0 0 select * from v$lock_activity 16250 648 1132 0 1 0 0 1 0 1 2000-07-20/22:00:54 0 1 12 38 0 3 CHOOSE 0 5 5 0 04AB6EB0 00 1357350217 0 0 0 0 select * from v$filestat 20105 1068 3892 2 1 0 0 1 0 1 2000-07-20/21:58:24 0 1 28 431 5 3 CHOOSE 0 5 5 0 04B104EC 00 3663816533 0 0 0 0 select limit# from profile$ where profile#=:1 and resource#=:2 and type#=:3 6164 540 1380 0 1 0 0 17 0 1 2000-07-20/21:12:40 0 1 14 61 17 3 CHOOSE 0 0 0 0 04BAEB9C 00 123567310 0 0 0 0 select name,online$,contents$,undofile#,undoblock#,blocksize,dflmaxext,dflinit,d 13184 1696 3388 0 1 0 0 2 0 1 2000-07-20/21:13:04 0 2 2 4 2 3 CHOOSE 0 0 0 0 04B32E54 00 570441826 0 0 0 0 select o.name from obj$ o where o.name like 'ORA_TEMP_1_%' and o.owner# = 0 and 6979 480 1872 0 1 0 0 1 0 1 2000-07-20/21:12:13 0 1 1 3 0 3 CHOOSE 0 0 0 0 04BC47C0 00 252991768 0 0 0 0 select location_name from loc$ 4171 480 1496 0 1 0 0 1 0 1 2000-07-20/21:12:13 0 1 2 17 0 3 CHOOSE 0 0 0 0 04BCCA54 00 505350413 0 0 0 0 select /*+ index(idl_char$ i_idl_char1) +*/ piece#,length,piece from idl_char$ w 7056 644 1736 0 1 0 0 8 0 1 2000-07-20/21:12:45 0 8 30 72 4 3 CHOOSE 3 0 0 0 04B57834 00 957616262 0 0 0 0 select distinct d.p_obj#,d.p_timestamp from sys.dependency$ d, obj$ o where d.p_ 8101 556 2700 1 1 0 0 1 0 1 2000-07-20/21:12:10 0 1 191 2358 367 3 CHOOSE 0 0 0 0 04C2B430 00 690085868 0 0 0 0 select name,file#,block#,status$,user#,undosqn,xactsqn,scnbas,scnwrp,DECODE(inst 968 0 0 0 0 0 0 26 0 1 2000-07-20/21:12:08 0 0 0 0 0 3 NONE 0 0 0 04C0199C 00 3172683996 0 0 0 0 select intcol#,nvl(pos#,0),col# from ccol$ where con#=:1 6289 604 1488 0 1 0 0 40 0 2 2000-07-20/21:12:09 0 3 7 160 40 3 CHOOSE 0 0 0 0 04BF1470 00 2085632044 0 0 0 0 select local_tran_id, global_tran_fmt, global_oracle_id, global_foreign_id, 9311 1104 2208 0 1 0 0 2 0 1 2000-07-20/21:13:01 0 2 19 36 0 3 CHOOSE 0 0 0 0 04B435F0 00 3625995331 0 0 0 0 select * from v$rollstat 26693 1324 2360 0 1 0 0 1 0 1 2000-07-20/22:04:25 0 1 0 54 16 3 CHOOSE 0 5 5 0 04A714BC 00 3514189410 0 0 0 0 select * from v$session_object_cache 23601 1220 2012 0 1 0 0 1 0 1 2000-07-20/22:05:16 0 1 2 38 1 3 CHOOSE 0 5 5 0 04A4EB94 00 3035851572 0 0 0 0 select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.dataobj# 7457 864 2060 0 1 0 0 22 0 1 2000-07-20/21:12:11 0 9 16 66 22 3 CHOOSE 0 0 0 0 04BD4E04 00 189272129 0 0 0 0 select file#,block#,length from fet$ where length>=:1 and ts#=:2 and file 6545 644 1644 0 1 0 0 4 0 1 2000-07-20/21:58:24 0 4 0 12 4 3 CHOOSE 0 0 0 0 04AEC514 00 904892542 0 0 0 0 delete from uet$ where ts#=:1 and segfile#=:2 and segblock#=:3 and ext#=:4 6415 508 3224 0 1 0 0 4 0 1 2000-07-20/21:58:25 0 4 0 26 4 7 CHOOSE 0 0 0 0 04ACAF70 00 528349613 0 0 0 0 select u.name, o.name, trigger$.sys_evts, trigger$.type# from obj$ o, user$ u, 10947 664 4268 1 1 0 0 1 0 1 2000-07-20/21:12:41 0 1 1 1 0 3 CHOOSE 0 0 0 0 04BA20F4 00 2564072224 0 0 0 0 ALTER DATABASE MOUNT EXCLUSIVE 875 0 0 0 0 0 0 1 0 1 2000-07-20/21:11:59 0 0 0 0 0 35 NONE 0 0 0 04C32758 00 3831314764 0 0 0 0 select * from v$database 43325 1376 5836 0 1 0 0 1 0 1 2000-07-20/21:57:48 0 1 8 39 1 3 CHOOSE 0 5 5 0 04B16404 00 1983454399 0 0 0 0