Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Rollback Segment Errors

Rollback Segment Errors

From: <townselk_at_my-dejanews.com>
Date: Mon, 02 Nov 1998 10:19:47 GMT
Message-ID: <71k102$2ls$1@nnrp1.dejanews.com>


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??

Thanks

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Nov 02 1998 - 04:19:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US