Re: Sequnce Cache Size in RAC

Hello,

You need to consider if particular sequence is ORDER or NOORDER. increasing cache size will only work for last one.

But to make sure you need to tune sequence cache size you need to have enq: SQ – contention among your Top10 events.

вт, 15 февр. 2022 г., 12:37 Lothar Flatz <l.flatz_at_bluewin.ch>:

> Hi Krishna,
>
> Increasing the cache size for RAC is a routine action. 50 is generally a
> bit low, value depends on activity.
> There is no technical issue with increasing the cache size.
> There can be an bussiness issue. It is possible that your numbering has
> gaps when a rollback happens.
>
> Thanks
>
> Lothar
>
> Am 15.02.2022 um 11:30 schrieb Krishnaprasad Yadav:
> > Hi Experts ,
> >
> > We are proactively trying to increase sequence cache size , currently
> > the database is in RAC .
> > I need to know if there is a RAC environment , increase in CACHE size
> > of sequence makes any difference . Currently the value is cache_size is 0
> > Does changing value from 0 to 50 of cache_size can cause any issue
> > w.r.t to application .
> >
> >
> > Regards,
> > Krishna
> >
> >
> >
> >
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l