G
George Potemkin
Guest
Regarding the sequence block access being a bottleneck... I used to suggest for the application developers to implement an "advanced" usage of the sequences: set a sequence's increment, let's say, to 100. Then when a session will get the next-value(sequence) then the session can use 100 values (up to the new sequence's value) for the records the session is going to create. Such technique will eliminate a bottleneck on sequence block.
Continue reading...
Continue reading...