parse cpu and recursive cpu

From: The Human Fly <sjaffarhussain_at_gmail.com>
Date: Tue, 29 Mar 2005 16:24:57 +0300
Message-ID: <97b7fd2f050329052440fa0325@mail.gmail.com>

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

Received on Tue Mar 29 2005 - 08:28:49 CST