Re: Sequnce Cache Size in RAC

Dear Experts,

Thanks for the details !!.

It helped me in better understanding the working of sequence.

Regards,
Krishna

On Wed, 16 Feb 2022 at 14:48, Jonathan Lewis <jlewisoracle_at_gmail.com> wrote:

>
>
> https://www.red-gate.com/simple-talk/databases/oracle-databases/oracle-sequences-rac/
>
> Regards
> Jonathan Lewis
>
>
> On Wed, 16 Feb 2022 at 04:55, Krishnaprasad Yadav <chrishna0007_at_gmail.com>
> wrote:
>
>> Hi Experts,
>> Intention to raise this question was , some of my
>> colleagues suggested that increase in cache size from 0 to bigger number
>> can cause difference in cache value from both node .
>>
>> like in my case , cache size is 0 , and this is RAC environment , so in
>> this case , certain numbers are cached in node 1 and a separate set will be
>> cached for node 2 .
>>
>> so any maily insert using this sequence can cause issue of difference in
>> number
>>
>> Please share some light on this .
>>
>> Regards,
>> Krishna
>>
>>
>> On Tue, 15 Feb 2022 at 16:45, Laurentiu Oprea <
>> laurentiu.oprea06_at_gmail.com> wrote:
>>
>>> Hello Krishna,
>>>
>>> Your question is really incomplete, thus the answers you are getting are
>>> in consequence.
>>>
>>> You might need to provide details on:
>>> -> why the cache was initially set to 0
>>> -> what drives the motivation to increase the cache and what kind of
>>> investigations was undertaken to conclude that the issues will be solved by
>>> this
>>> -> what version your database is running
>>>
>>> You might want to read these articles by Jonathan Lewis:
>>> https://jonathanlewis.wordpress.com/2022/02/07/sequence-catalogue/
>>> and also this article maybe:
>>> https://oracle-base.com/articles/18c/scalable-sequences-18c
>>>
>>> Thanks.
>>>
>>> PS: to answer your specific question: increasing cache size for
>>> sequences in your environment may or may not create issues.
>>>
>>> În mar., 15 feb. 2022 la 12:31, Krishnaprasad Yadav <
>>> chrishna0007_at_gmail.com> a scris:
>>>
>>>> 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