Venkat.
Here is a short quick and dirty SQL statement You can use it to monitor what
SQL is running and what rollback segment it is using. Hope this is helpful..
select b.username, b.sid, b.serial#, b.audsid,
b.status, d.name rollback_segment, c.sql_text
from v$transaction a,
v$session b,
v$sqlarea c,
v$rollname d
where a.ses_addr = b.saddr and
b.sql_address = c.address and
a.xidusn = d.usn;
Tom Tyson
Oracle DBA
Exodus Communications, Inc.
- Venkat_Kalepalli <Venkat_Kalepalli_at_satyam.com> wrote:
> 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
> >
>
Do You Yahoo!?
Get Yahoo! Mail - Free email you can access from anywhere!
Received on Fri Oct 13 2000 - 10:18:37 CDT
