RE: How to see DDL executing

Try this query,

select a.xidusn "USN:RBS", c.name "RBS", a.start_time "START_TIME", b.sid "SID",b.username "USERNAME",b.osuser "OSUSERNAME", b.program "PROGRAM RUNNING",b.status "STATUS" from v$transaction a,v$session b,
v$rollname c where a.ses_addr=b.saddr and a.xidusn=c.usn

HTH WInnie

"Tirumala, Surendra HS" <surendra.tirumala_at_hs.utc.com>@fatcity.com on 10/13/2000 09:10:47 AM

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:

Subject: RE: How to see DDL executing

Venkat,
It is absolutely possible
Writing a query linking V$ROLLNAME,V$SESSION,V$LOCK should help you.

Surendra Tirumala
Oracle DBA
860-654-1322 (work)
860-298-9141 (home)

> -----Original Message-----
> From: Venkat_Kalepalli [SMTP:Venkat_Kalepalli_at_satyam.com]
> Sent: Friday, October 13, 2000 10:27 AM
> 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
>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tirumala, Surendra   HS
  INET: surendra.tirumala_at_hs.utc.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may