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 -> Re: rollback segment too old

Re: rollback segment too old

From: Knut Talman <knut.talman_at_mytoys.de>
Date: Fri, 21 Jun 2002 12:48:08 +0200
Message-ID: <3D130468.826B5A8A@mytoys.de> 





Pinto wrote:



> if you can see, the wraps have more than doubled. and as expected i am still

> getting ora-1555




Not only the size of a rollback segment can become a bottleneck also the number
of rbs is important. Every transaction has to use the header of the rbs to enter
its information. If there are no slots left (in the header) you'll get
ORA-01555, even if there are a lot of free rollback segment blocks.



Regards,



Knut
Received on Fri Jun 21 2002 - 05:48:08 CDT












Original text of this message













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