RE: How to see DDL executing

From: Tirumala, Surendra HS <surendra.tirumala_at_hs.utc.com>
Date: Fri, 13 Oct 2000 11:02:06 -0400
Message-Id: <10648.119189@fatcity.com>

Venkat,
It is absolutely possible
Writing a query linking V$ROLLNAME,V$SESSION,V$LOCK should help you.

Surendra Tirumala
Oracle DBA
860-654-1322 (work)
860-298-9141 (home)

> -----Original Message-----
> From: Venkat_Kalepalli [SMTP:Venkat_Kalepalli_at_satyam.com]
> Sent: Friday, October 13, 2000 10:27 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: How to see DDL executing
>
> Hi friends,
>
> Is it possible to monitor which user is using which rollback segement
> currently thru any Dictionary table/view. First of all is it possible or
> not? Any suggestion is invited..
>
> Regards,
> Venkat.
>
> ----------
> From: Walter K[SMTP:alden14004_at_yahoo.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Friday, October 13, 2000 6:20 PM
> To: Multiple recipients of list ORACLE-L
> Subject: How to see DDL executing
>
> Is there a place where I can see the SQL of DDL statements
> executing? For example, if I execute a statement such as CREATE TABLE..AS
> SELECT.. I cannot see the SQL in v$sqlarea or v$sqltext. I have a need to
> monitor the progress.
>
>
> Any suggestions and/or scripts would be MUCH appreciated.
Received on Fri Oct 13 2000 - 10:02:06 CDT