How can I find out what's filling up my rollback segment?

Hi stan,

these are the extents in the tablespace.

select * from
(SELECT file_id, block_id, blocks, owner, substr(segment_name,1,30), extent_id
FROM dba_extents WHERE tablespace_name = 'RBS' union
select file#, block#, length, 'noOne', 'free', 0 from sys.fet$
where file# = (select file_id from dba_data_files where tablespace_name = 'RBS')
)
order by 1,2

I don't know, if and how you can get the objects, whose extents are those rollback-extents.

Gerd Kock
www.bits-on-the.net

-----Ursprüngliche Nachricht-----
Von: stanb_at_panix.com (Stan Brown) [mailto:stanb_at_panix.com] Bereitgestellt: Montag, 3. Dezember 2001 14:56 Bereitgestellt in: server
Unterhaltung: How can I find out what's filling up my rollback segment? Betreff: How can I find out what's filling up my rollback segment?

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