Re: ORA-01562

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Wed, 19 Jun 2002 12:32:40 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7024066B4@lnewton.leeds.lfs.co.uk>

Looks like you hit the maximum extents allowed (121).

To fix,

alter rollback segment RB0 storage (maxextents 2000);

Change the 2000 to sdomething more meaningful for your system.

DO NOT set a rollback segment to 'maxextents unlimited' because Oracle will crash oput when you exceed 32767 extents (or therabouts) on a rollback segment. I'm not sure which version of Oracle fixes this (if it is fixed). There'#s a note on Metalink somewhere about the problem with unlimited rollback segments.

If the rollback segs are in a Locally Managed Tablespace, Oracle limits them to 32765 (at 8.1.7.3.0 anyway) so it looks like you shouldn't set maxextents higher than 32765.

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: Christoph Kukulies [mailto:kuku_at_accms33.physik.rwth-aachen.de] Posted At: Wednesday, June 19, 2002 11:51 AM Posted To: server
Conversation: ORA-01562
Subject: Re: ORA-01562

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?

--
Chris Christoph P. U. Kukulies kukulies_at_rwth-aachen.de

Received on Wed Jun 19 2002 - 06:32:40 CDT