Re: Sequnce Cache Size in RAC

“It is possible that your numbering has gaps when a rollback happens.”
This is true regardless of cache size.

Test your application with the new cache size, make sure you’re getting it used on multiple nodes. Only that and knowledge of the code will tell you if there’s a problem. There shouldn’t be, but who knows what assumptions have been baked in.

There’s more than just one wait event that comes from incrementing the sequence. It doesn’t need to be a top 10 event for it to be a problem for a specific critical process.

Thanks,
Andy

On Tue, 15 Feb 2022 at 10:44, Oleksandr Denysenko <odenysenko_at_gmail.com> wrote:

> 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