Message-Id: <10648.119171@fatcity.com> From: Venkat_Kalepalli Date: Fri, 13 Oct 2000 18:00:33 +0530 Subject: 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@yahoo.com] > Reply To: ORACLE-L@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 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.