Re: Rollback Segment

From: Alex Filonov <afilonov_at_pro-ns.net>
Date: Wed, 08 Nov 2000 22:49:14 GMT
Message-ID: <8ucl96$f40$1@nnrp1.deja.com>

In article <8ubusd$pni$1_at_nnrp1.deja.com>, George Ye <qiangye_at_my-deja.com> wrote:
> Hi everybody,
>
> Q is how to check whether the Rollback Segment is full, or with
errors.
> If the Rollback Segment is full, what is the bad affection, and how to
> fix this problems.
>
> Thanks a million. Pls cc to qye_at_iname.com
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

To check status of all rollback segments:

select segment_name, status
from sys.dba_rollback_segs.

Rollback segment cannot be full. It can reach maximum of extents. But tablespace which holds rollback segments can get full. To check this condition:

select sum(blocks), max(blocks)
from sys.dba_free_space
where tablespace_name = 'RBS'

Replace RBS with you tablespace name. sum(blocks) gives you total free space in the tablespace, max(blocks) - maximum size of available extents.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 08 2000 - 16:49:14 CST