v$sqlarea question

From: Arun Abraham <aa_at_triad.com>
Date: Thu, 05 Aug 1999 22:01:49 GMT
Message-ID: <7od1k7$ui$1@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 - 17:01:49 CDT