RE: How to see DDL executing

From: Venkat_Kalepalli <Venkat_Kalepalli_at_satyam.com>
Date: Tue, 17 Oct 2000 18:37:34 +0530
Message-Id: <10652.119450@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C0383B.28C92030
Content-Type: text/plain

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.
>
> -w
>
>

------_=_NextPart_001_01C0383B.28C92030
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =

charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12">

<TITLE>RE: How to see DDL executing</TITLE>
</HEAD>
<BODY>

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

<P><FONT COLOR=3D"#800080" SIZE=3D2 FACE=3D"Arial">Venkat.</FONT>
</P>
<UL>
<P><FONT SIZE=3D1 FACE=3D"MS Sans Serif">----------</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"MS Sans Serif">From:</FONT></B> &nbsp; =
<FONT SIZE=3D1 FACE=3D"MS Sans =

Serif">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.=A0=A0 First of all is it possible or not?=A0 Any = suggestion is invited..

Regards, 
 Venkat.

---------- From: =A0 Walter = K[SMTP:alden14004_at_yahoo.com] Reply To: =A0=A0=A0=A0=A0 ORACLE-L_at_fatcity.com Sent: =A0 <FONT SIZE=3D1 FACE=3D"MS Sans =

Serif">Friday, October 13, 2000 6:20 PM</FONT><FONT FACE=3D"Arial"> =
</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"MS Sans Serif">To:</FONT></B><FONT =

FACE=3D"Arial"> =A0=A0=A0 <FONT SIZE=3D1 FACE=3D"MS Sans =

Serif">Multiple recipients of list ORACLE-L</FONT><FONT FACE=3D"Arial"> =
</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"MS Sans Serif">Subject:</FONT></B><FONT =

FACE=3D"Arial"> =A0=A0=A0=A0=A0=A0 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=A0or = v$sqltext. I have a need to monitor the progress.

<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT FACE=3D"Arial">=A0 =
</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Any suggestions and/or scripts would =

be MUCH appreciated. =A0 
 -w = Received on Tue Oct 17 2000 - 08:07:34 CDT