| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: How can I find out what's filling up my rollback segment?
Maybe something like this would help you out:
select * from dba_dml_locks
where session_id in
(select sid from v$session s, v$transaction t
where s.saddr = t.ses_addr
and t.xidusn = &usn);
Before running this query, you should run the Oracle-supplied script catblock.sql, which is found in $ORACLE_HOME/rdbms/admin.
Hope this helps!
Chris
"Stan Brown" <stanb_at_panix.com> wrote in message
news:9ug09g$b6v$1_at_panix2.panix.com...
> I was running a long runing task on my 7.3.4.5 instance when it died due
to
> lack of space in the rollback segment. Now what's interesting is that this
> task used to work, and as far as I know it was the only thing acessing the
> instance at the time. So I took a look at the usage in the tablespcae.
here
> is what I found:
>
> TSPACE TOT_MB ORA_BLKS TOT_USED PCT_USED
> --------------- ---------- ---------- ---------- ----------
> RBS 500 64000 40400 63.13
>
> So, what query can I run to figure out what objects exist in the rollback
> tablespcae?
>
> --
> "They that would give up essential liberty for temporary safety deserve
> neither liberty nor safety."
> -- Benjamin Franklin
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
 |
 |