Re: parse cpu and recursive cpu

It is best to not rely on the actual statistic numbers, as those can change between releases.

select n.name, n.statistic#, s.value
from v$statname n, v$mystat s
where lower(n.name) like '%cpu%'
and n.statistic# = s.statistic#
/

On Tue, 29 Mar 2005 22:04:15 +0800, jametong_at_gmail.com <jametong_at_gmail.com> wrote:
> Hello The Human Fly,
>
> just do the below query.:-)
>
> select * from v$mystat where statistic# in (8,233);
>
> Best regards,
>
> ======= At 2005-03-29, 21:24:57 you wrote: =======
>
> >Hello List,
> >
> >How do I get the parse cpu and recursive cpu of the current sessions?
> >I dont see anything related to this in the v$sql,v$sqltext or
> >v$sqlarea.
> >
> >Basically, I want the sql statement which produces top session output of OEM.
> >
> >--
> >Best Regards,
> >Jaffar, OCP DBA
> >Banque Saudi Fransi
> >Saudi Arabia
> >----------------------------------------------------------------------------------------
> >"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
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l