RE: How to see DDL executing

From: Mohammad Rafiq <rafiq9857_at_hotmail.com>
Date: Fri, 13 Oct 2000 12:03:55 EDT
Message-Id: <10648.119207@fatcity.com>

Venkat,

Use below script which will give you much more than you want....

select substr(a.os_user_name,1,8) "OS User"

, substr(b.object_name,1,30) "Object Name"
, substr(b.object_type,1,8) "Type"
, substr(c.segment_name,1,10) "RBS"
, e.process "PROCESS"
, substr(d.used_urec,1,8) "# of Records"

from v$locked_object a

, dba_objects b
, dba_rollback_segs c
, v$transaction d
, v$session e

where a.object_id = b.object_id

and a.xidusn = c.segment_id
and a.xidusn = d.xidusn
and a.xidslot = d.xidslot
and d.addr = e.taddr

/

Regards
Rafiq

From: Venkat_Kalepalli <Venkat_Kalepalli_at_satyam.com> Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Subject: RE: How to see DDL executing
Date: Fri, 13 Oct 2000 06:26:30 -0800

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
>

---

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at Received on Fri Oct 13 2000 - 11:03:55 CDT