Last Updated:

mon.sh topstat


 06/01/98 09:16:36 sql statements with highes buffer reads
 hash value  buffer reads text
-2.104E+09           6 select length from fet$ where file#=:1 and block#=:2 and ts#
-1.963E+09          15 delete from fet$ where file#=:1 and block#=:2 and ts#=:3
-1.250E+09         446 SELECT HASH_VALUE,BUFFER_GETS   FROM V$SQLAREA  WHERE BUFFER
-1.178E+09           6 insert into fet$ (file#,block#,ts#,length) values (:1,:2,:3,
-583320995          25 delete from seg$ where file#=:1 and block#=:2
-522066518          12 update ts$ set inc#=:2 where ts#=:1
-196225006         895        select  a.hash_value,value,sql_text text           fr
-157803240           9 select type,ts#,blocks,extents,minexts,maxexts,extsize,extpc
 413688205          15 insert into seg$ (file#,block#,type,ts#,blocks,extents,minex
 802034323           9 insert into uet$ (segfile#,segblock#,ext#,ts#,file#,block#,l
1323697663           9 select ts#,file#,block#,length from uet$ where segfile#=:1 a
1390969089          18 delete from uet$ where segfile#=:1 and segblock#=:2 and ext#
1877596782         446 begin topsql.collect; end;


Questions or comments ? Send a note to oraperf@yahoo.comom