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