By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,611 Members | 2,296 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,611 IT Pros & Developers. It's quick & easy.

Using a lot of sequences

P: n/a
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.

-
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.