Re: top CPU utilizing sessions

Hello The Human Fly,

I think this query can give you some hint.:-)

select b.username,b.sid,b.serial#,b.osuser,b.machine,b.program,c.name,a.value from v$sesstat a,v$session b,v$statname c where a.sid = b.sid and a.statistic# = c.statistic# and a.statistic# = 12
order by value desc;

Best regards,   

• At 2005-03-29, 17:27:03 you wrote: =======

>Hello list,
>
>Can any one give me the script from which I can find out of my all
>current users top session by CPU TIME like the one which we get in OEM
>CONSOLE sessionS.
>
>Jaffar
>----------------------------------------------------------------------------------------
>"It is your atittude, not your aptitude that determins your altitude."
>--
>http://www.freelists.org/webpage/oracle-l

• = = = = = = = = = = = = = = = = = = =

jametong
jametong_at_gmaill.com
2005-03-29

--
http://www.freelists.org/webpage/oracle-l