top sessions ?

Hi yall,

How would you determine the top N sessions on an Oracle instance (using V$SESSTAT) Will looking at the consistent gets (statistic# 39) give an accurate picture?

for example,

select
  sid,
  value
from
  v$sesstat
where
  statistic#=39
order by value desc

Any ideas for a formula combining statistics from V$SESTAT that gives an accurate picture?

Read you,

Jan-Marten Spit Received on Tue Apr 06 1999 - 11:25:07 CDT