Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> HELP: Get ORA-1555 rollback too small

HELP: Get ORA-1555 rollback too small

From: A. Dischner <dischner_at_klch.med.uni-muenchen.de>
Date: Mon, 02 Dec 2002 15:33:11 +0100
Message-ID: <dischner-CE4085.15331002122002@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

-- 
Posen fuer Anfaenger: http://www.w-klch.med.uni-muenchen.de/dischner
Received on Mon Dec 02 2002 - 08:33:11 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US