Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle RBS
Hi Jan,
Typically the first things you'd look at to resolve this would be:
1. Set a higher value for MINEXTENTS (2 is quite low) 2. Use larger extent sizes or 3. If you've set a value for OPTIMAL, increase it.
If you try things things in the order they're listed it might help you out..
Take care Jan,
Steve
"Jan Israelsson" <janisraelsson_at_hotmail.com> wrote in message
news:3B8214EE.5365069E_at_hotmail.com...
> Hi all,
> I need some advice on rollback segments, we are running Oracle8 and
> Baan4c4 (application) on an AIX box (50+ concurrent users) and we are
> having problems with ORA 1555 "snapshot to old, rollback segment XX to
> small". Here are some info about our setup:
> RBS tablespace 720mb
> 10 rbs segs (r01-r10) initial_extent 2048K, next_extent 2048K,
> min_extents 2, max_extents unlimited, optimal 4096K, pct_increase 0
> max_transactions_per_rollback_segment = 21
> Is this totally out of line or? My guess is that maybe the RBS
> tablespace is to small so it is not possible to allocate more extents on
> occassion, or can there be a problem with the # of rbs or the size of
> the extents? Any advice would be greatly appreciated.
>
> please advice.
> Regards Jan.
>
Received on Tue Aug 21 2001 - 07:07:00 CDT
![]() |
![]() |