Oracle-L: RE: Any way to see the currently running SQL in one session.

From: ora ak <ora_magic_at_yahoo.com>
Date: Wed, 16 Oct 2002 08:04:10 -0800
Message-ID: <F001.004EAA12.20021016080410@fatcity.com>

there is a x$ table which can give u this info I am not able to recall that at the moment . oramagic
Paulo Gomes <PGomes_at_datinfor.pt> wrote:u could use top sessions

-----Original Message-----
Sent: quarta-feira, 16 de Outubro de 2002 2:28 To: Multiple recipients of list ORACLE-L

Dear ALL,

Is there any way to see the currently running SQL in one session? I used v$open_cursor, but there might be many SQL statements, I don't know which one is currently running. And more, if I execute a stored procedure, which SQL statements could be seen in v$open_cursor?

Any clues would be much appreciated.

TIA Chuan
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Paulo Gomes
INET: PGomes_at_Datinfor.pt

Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos, & more faith.yahoo.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: ora ak
INET: ora_magic_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------