Re: Insert running long with Sequence
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Thu, 16 Apr 2020 23:12:16 -0400
Message-ID: <306b5257-8e01-eb5a-b984-e51214837d67_at_gmail.com>
Date: Thu, 16 Apr 2020 23:12:16 -0400
Message-ID: <306b5257-8e01-eb5a-b984-e51214837d67_at_gmail.com>
On 4/15/20 11:24 AM, Bhavani Dhulipalla wrote:
> hi Sayan abd Lothar
>
> Thank you - I don't know why it is set as 0?
You've just noticed the drawback. It's much slower. The "cache" doesn't actually cache the sequence but defines when will Oracle run synchronization routines. You can see the details in Jonathan's book.
>
> Can you please let me know what is the drawback of setting to 0 ? if I
> increase to lets say 20 , does oracle pre create these 20 numbers at once?
>
> Any drawback if I set to 500?
Yes. You should set it to 512. That's a nice round number.
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 -- http://www.freelists.org/webpage/oracle-lReceived on Fri Apr 17 2020 - 05:12:16 CEST