| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: How to see DDL executing
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_01C03511.5A0423A0
Content-Type: text/plain
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_01C03511.5A0423A0
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>
<P><FONT COLOR=3D"#800080" SIZE=3D2 FACE=3D"Arial">Hi friends,</FONT>
</P>
<P><FONT COLOR=3D"#800080" SIZE=3D2 FACE=3D"Arial">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..</FONT></P>
<P><FONT COLOR=3D"#800080" SIZE=3D2 FACE=3D"Arial">Regards,</FONT>
<BR><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> =
<FONT SIZE=3D1 FACE=3D"MS Sans Serif">Walter =
K[SMTP:alden14004_at_yahoo.com]</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"MS Sans Serif">Reply To:</FONT></B> =
<FONT SIZE=3D1 FACE=3D"MS Sans =
Serif">ORACLE-L_at_fatcity.com</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"MS Sans Serif">Sent:</FONT></B> =
<FONT SIZE=3D1 FACE=3D"MS Sans Serif">Friday, October 13, 2000 6:20 =
PM</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"MS Sans Serif">To:</FONT></B> =
<FONT SIZE=3D1 FACE=3D"MS Sans Serif">Multiple =
recipients of list ORACLE-L</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"MS Sans Serif">Subject:</FONT></B> =
<FONT SIZE=3D1 FACE=3D"MS Sans =
Serif">How to see DDL executing</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">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.</FONT></P>
<P><FONT FACE=3D"Arial">=A0</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Any suggestions and/or scripts would =
be MUCH appreciated.</FONT>
<BR><FONT FACE=3D"Arial">=A0</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">-w</FONT>
Received on Fri Oct 13 2000 - 07:30:33 CDT
 |
 |