"Kock, Gerd" <GKock_at_pdv-Online.de> wrote in message news:<90333AAED533D411950600104B45E019040F56A7_at_pdv-exchng.pdv-online.de>...
> 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?
Stan, you did not specify the exact Oracle error message so the best
place for you to start may be with v$rollstat, which will show you all
the rollback segments, how many extents they are in, and how large
they are amount other things. It may just be time to clean up the
segments.
Received on Tue Dec 04 2001 - 11:27:58 CST
