468,244 Members | 1,727 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,244 developers. It's quick & easy.

Using a lot of sequences

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
1 1290
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.

Similar topics

4 posts views Thread by temp | last post: by
reply views Thread by Francesc Guim Bernat | last post: by
10 posts views Thread by Vilson farias | last post: by
2 posts views Thread by Martin v. Lwis | last post: by
5 posts views Thread by nummertolv | last post: by
4 posts views Thread by JJ | last post: by
5 posts views Thread by lancer6238 | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.