Hey all,
does anyone know if it is in any way harmful to use a lot of sequences in
a database? Does it have any disadvantages? I already noticed that
sequences are hard to use with export/import. But are there any other
disadvantages?
The company I work for uses 40 sequences in the database, but these can be
easiliy brought down to 20.
Thanks in advance for any responses.
Jurgen.
-
Serge Rielau - 14 Oct 2004 12:17 GMT
I'm not aware of any scalability issues.
While a sequence does not perform any locking there are of course soem
short term latches. If you have an extreme(!) concurrent use of a
specific sequence it that latch could, theoretically, run hot.
That woudl be a case in point not to reduce the number of sequences.
But again.. that's extreme. I doubt there is an app out there
experiencing such issues in reality.
Cheers
Serge