How can you find cpu usuage?

From: KnighThing <knighthing_at_hotmail.com>
Date: Wed, 13 Jun 2001 16:56:10 -0500
Message-ID: <58ofitkgefhl5jc8r0b2m3hrhdg0cu6ijb@4ax.com>

I would like to do the following:

Find the cpu time being used by each session.

So that I could then sort that by CPU time and find out which sessions are using the most CPU times.

I tried the following, but didn't get the results I'd expect.

i.e. all but 3 sessions had 0 CPU time.

select

	   s.sid,
	   s.username,
	   s.status,
	   s.schemaname,
	   s.osuser,
	   s.machine,
	   s.terminal,
	   s.program,
	   s.module,
	   decode(ss.statistic#,12,ss.value,0) SessionCPU,
   	   decode(ss.statistic#,8,ss.value,0) RecursiveCPU,
   	   decode(ss.statistic#,169,ss.value,0) ParseTimeCPU
from
	v$SesStat ss,
	v$StatName sn,
	v$session s
where
	 ss.sid = s.sid
and	 ss.statistic# = sn.statistic#

order by SessionCPU desc Received on Wed Jun 13 2001 - 16:56:10 CDT