Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> How to see DDL executing (retry)

How to see DDL executing (retry)

From: Walter K <alden14004_at_yahoo.com>
Date: Mon, 16 Oct 2000 12:36:04 -0500
Message-Id: <10651.119357@fatcity.com>


This is a multi-part message in MIME format.

------=_NextPart_000_09C8_01C0376D.A5F0D280 Content-Type: text/plain;

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

Is there a place where I can see the SQL of DDL statements executing? I = cannot see the SQL in v$sqlarea or v$sqltext.

Any suggestions and/or scripts would be MUCH appreciated.

-w

------=_NextPart_000_09C8_01C0376D.A5F0D280 Content-Type: text/html;

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4207.2601" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2></FONT><BR></DIV>
<DIV><FONT face=3DArial size=3D2>Is there a place where I can see the =
SQL of DDL=20
statements executing? I cannot see the SQL in v$sqlarea&nbsp;or=20 v$sqltext.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Any suggestions and/or scripts would be =
MUCH=20
appreciated.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>-w</FONT></DIV></BODY></HTML>

------=_NextPart_000_09C8_01C0376D.A5F0D280-- Received on Mon Oct 16 2000 - 12:36:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US