Re: Sequnce Cache Size in RAC

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