Re: How to see DDL executing

v$backup, status should be active or v$datafile_header column fuzzy should be yes.

Joan

> Venkat_Kalepalli wrote:
>
> Hi friends,
>
> I have a doubt here. when hotback up is going on, Can we see from
> dictionary table/view which tablespace backup is going on.
>
> Thanks and regards
>
> Venkat.
>
> ----------
> From: Venkat_Kalepalli[SMTP:Venkat_Kalepalli_at_satyam.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Friday, October 13, 2000 7:56 PM
> 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 Tue Oct 17 2000 - 12:25:54 CDT