Re: top CPU utilizing sessions
- From: "jametong@xxxxxxxxx" <jametong@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 29 Mar 2005 18:26:48 +0800
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."
>--
>//www.freelists.org/webpage/oracle-l
= = = = = = = = = = = = = = = = = = = =
jametong
jametong@xxxxxxxxxx
2005-03-29
--
//www.freelists.org/webpage/oracle-l
Other related posts:
