Re: parse cpu and recursive cpu

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