Re: Get ORA-1555 rollback too small

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Tue, 3 Dec 2002 06:04:12 +1100
Message-ID: <40OG9.88860$g9.249503@newsfeeds.bigpond.com>

"A. Dischner" <dischner_at_klch.med.uni-muenchen.de> wrote in message 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

So what makes you think that a 16MB rollback segment is 'really big'?

(Hint: it isn't).

Your rollback segment needs to be as big as your biggest transaction. So what's the size of that then? Have a repeated look in v$transaction (USED_UBLK) to find out.

Regards
HJR
>
> Tablespace usage is always < 1% as seen in Enterprise manager.
>
> There are no critical locks.
>
> any ideas? hints?
>
> Toni
>
> --
> Posen fuer Anfaenger: http://www.w-klch.med.uni-muenchen.de/dischner
Received on Mon Dec 02 2002 - 13:04:12 CST