Re: ORA-01595

From: Alkos <azerty_at_nospam.org>
Date: Mon, 1 Dec 2003 10:24:13 +0100
Message-ID: <bqf1bu$p721@news.rd.francetelecom.fr>

Hi Ofer,

"Ofer" <oferr_at_realcommerce.co.il> a écrit dans le message news: bqev0e$kfp$1_at_news2.netvision.net.il...
> I have a non-active DB (8.1.7), and every day I get the following error:

Really non-active ?!?

>
> ORA-01595: error freeing extent (1) of rollback segment (19))
> ORA-01594: attempt to wrap into rollback segment (19) extent (1) which is
> being freed

> Any idea how to resolve it?

Increasing the size of the extents of your RBS for the same optimal size to reduce the number of extents allocated
per RBS.

Cheers,
Alkos Received on Mon Dec 01 2003 - 03:24:13 CST