Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Thousands of sequences OK?
Jerry Brennock wrote:
>
> I have an application that is being migrated onto Oracle. It uses a
> table to generate unique ids, with all the associated performance and
> locking problems.
>
> The problem is that the app has been modified to give each primary user
> (web user, not actual oracle user entity) his/her own ids.
>
> I would like to replace the id table with sequences, but I could end up
> with roughly 10,000 people X 90 tables = 900,000 sequences. (There are
> also some options to get this down to about 40,000) My guess is that
> this would be politely referred to as a bad idea, but I would like to
> find out if anyone has created thousands of sequences in a database and
> what the result was. Or, if anyone knows some theoretical reason this
> would be bad.
>
> Thanks,
>
> Jerry
Only that putting 90,000 objects into the data dictionary means more overhead on the cache...
Given that sequences cannot be guaranteed to give you a contiguos set of
numbers anyway - why not just have 1 "mega" sequence that everyone
uses...?
--
![]() |
![]() |