Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Thousands of sequences OK?

Re: Thousands of sequences OK?

From: Connor McDonald <mcdonald.connor.cs_at_bhp.com.au>
Date: Wed, 20 Jan 1999 16:59:59 +0800
Message-ID: <36A59B0F.4521@bhp.com.au>


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...?
--



Connor McDonald
BHP Information Technology
Perth, Western Australia
"The difference between me and a madman is that I am not mad" Received on Wed Jan 20 1999 - 02:59:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US