Re: v$sqlarea question

From: Patrick Hamou <patrick_hamou_at_hotmail.com>
Date: Thu, 05 Aug 1999 23:39:38 GMT
Message-ID: <_gpq3.47841$ga.73712@news21.bellglobal.com>

try this :

select a.osuser, a.sid, a.serial#, c.sql_text from v$session a, v$sqlarea c
where a.sql_address = c.address (+)
order by 1;

it will give you the SQL_TEXT related to the session ....

Patrick Hamou
Oracle DBA

Arun Abraham wrote in message <7od1k7$ui$1_at_nnrp1.deja.com>...
>I have a application that in a series of steps create many temporary
>tables while running a report. All of them being 'CREATE TABLE ... AS
>..'. For long reports I would like to know at what step in the
>reporting process is Oracle currently at. The v$session tells me that
>there is an ACTIVE query of command 'CREATE TABLE'. I cannot find the
>corresponding SQL in the v$sqlarea. Where can I find it.
>
>Thanks.
>
>
>Arun
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Thu Aug 05 1999 - 18:39:38 CDT