Re: ORA-01562

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Wed, 19 Jun 2002 13:05:55 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA702406B3C@lnewton.leeds.lfs.co.uk>

Unlimited extents on a rollback segment is not a good idea !

<QUOTE>:
8. Rollback segments have an internal maximum of 32767 extents.

       Attempting to extend a rollback segment beyond this may result in
       internal errors and corruption (See Bug:671491)

</QUOTE>

See Note:50380.1 on metalink dated 15-May-2002 so it is pretty recent.

Regards,
Norman.

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------

-----Original Message-----
From: Knut Talman [mailto:knut.talman_at_mytoys.de] Posted At: Wednesday, June 19, 2002 12:46 PM Posted To: server
Conversation: ORA-01562
Subject: Re: ORA-01562

Christoph Kukulies wrote:
>
> Telemachus <telemachus_at_ulysseswillreturn.net> wrote:
> > Was there another error message ?
>
> I asked my colleague:
> He told me:
>
> ORA-01562: Fehler beim Erweitern der Rollback-Segmentnummer 2.
> ORA-01628: Max. Anzahl von Extents (121) für Rollback-Segment RB0
erreicht
>
> RBS1ORCL.ORA is 12 MB.
>
> I had set max_rollback_segments in INITORLC.ORA to (astronomical 1000)
> out of sheer desparation.
>
> Isn't there a way to set something to 'unlimited' to overcome this
problem?

Of course there is:

ALTER ROLLBACK SEGMENT RBS1ORCL.ORA STORAGE (MAXEXTENTS UNLIMITED); BTW, http://technet.oracle.com is a good resource for looking up topics like
this one.

Regards,

Knut Received on Wed Jun 19 2002 - 07:05:55 CDT