Re: Re: parse cpu and recursive cpu

Hello Jared Still,

Thanks Jered.

Best regards,   

• At 2005-03-30, 02:52:29 you wrote: =======

>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

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

jametong
jametong_at_gmail.com
2005-03-30

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