Re: Insert running long with Sequence
- From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 16 Apr 2020 23:12:16 -0400
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
