Re: parse cpu and recursive cpu
- From: Jared Still <jkstill@xxxxxxxxx>
- To: jametong@xxxxxxxxx
- Date: Tue, 29 Mar 2005 18:52:29 +0000
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@xxxxxxxxx
<jametong@xxxxxxxxx> 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."
> >--
> >//www.freelists.org/webpage/oracle-l
>
> = = = = = = = = = = = = = = = = = = = =
>
> jametong
> jametong@xxxxxxxxxx
> 2005-03-29
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
//www.freelists.org/webpage/oracle-l
Other related posts:
