Re: parse cpu and recursive cpu
- From: "jametong@xxxxxxxxx" <jametong@xxxxxxxxx>
- To: "sjaffarhussain@xxxxxxxxx" <sjaffarhussain@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 29 Mar 2005 22:04:15 +0800
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
Other related posts:
