Re: Rollback Segment Errors

From: <satar_at_my-dejanews.com>
Date: Tue, 03 Nov 1998 01:08:29 GMT
Message-ID: <71ll2d$af1$1@nnrp1.dejanews.com>

This is a bug that is fixed in 7.3.4. You can ignore the messages, it doesn't harm your database at all...However, you might want to search for SMON trace files that will take up space on your hard drive.

Satar

In article <71k102$2ls$1_at_nnrp1.dejanews.com>, townselk_at_my-dejanews.com 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??
>
> Thanks
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

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