Re: Rollback Segment Errors

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Mon, 02 Nov 1998 14:15:03 GMT
Message-ID: <3640be12.3275219@192.86.155.100>

A copy of this was sent to townselk_at_my-dejanews.com (if that email address didn't require changing) On Mon, 02 Nov 1998 10:19:47 GMT, you wrote:

>To all;
>
>For two weeks now, on a particular day and time, I have received the following
>errors in my Alert Log:
>
>ORA-1595 and ORA-1551 - The text is as follows respectively, Cause: Some
>error occurred while freeing inactive rollback segment extents.
>
>*Action: Investigate the accompanying error. (The accompanying error is ORA-
>1551). It reads, *Cause: Doing recursive extent of rollback segment, trapped
>internally by the system. *Action: None.
>
>I've run a statement to determine if I'm having rollback contention and
>according to guide, DBA Administration (Student Guide) pg 8-23, I'm not. SQL
>statement looks at gets and waits from v$rollname and v$rollstat tables.
>
>Can anyone help me??
>

The error means the rollback segment the transaction has attached does not have any space left to do a recursive transaction. It is possible that Oracle will try this operation quite a few times before failing with ORA-1551. Since this is not a user error, there is not much one can do about this. The following are some suggestions to avoid it.

Make the rollback segments bigger.
Since most of the recursive transaction involves the system tablespace objects, it might be useful to make the system tablespace bigger.
Make sure all the rollback segments (except system) are in a separate tablespace other than system

>Thanks
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA

--
http://govt.us.oracle.com/ -- downloadable utilities

Opinions are mine and do not necessarily reflect those of Oracle Corporation

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Mon Nov 02 1998 - 08:15:03 CST