Re: HELP: Get ORA-1555 rollback too small

From: Ban Spam <ban-spam_at_operamail.com>
Date: Mon, 02 Dec 2002 14:37:34 GMT
Message-ID: <Xns92D8438ADF7DSunnySD@68.6.19.6>

"A. Dischner" <dischner_at_klch.med.uni-muenchen.de> wrote in news:dischner- CE4085.15331002122002_at_hydra1.fw.med.uni-muenchen.de:

> Hi,
>
> with Oracle 8.1.7.0.1 i get ORA-1555 which means Rollback-segment is
> too small.
>
> I have really big rollback segments: Tablespace 4gb, initial 4MB, next
> 4MB, optimal 16MB, max 4096, number of RBsegs: 4
>
> Tablespace usage is always < 1% as seen in Enterprise manager.
>
> There are no critical locks.
>
> any ideas? hints?
>
> Toni
>

ORA-01555 can also mean that the code is issuing COMMITs too frequently. Received on Mon Dec 02 2002 - 08:37:34 CST