Thousands of sequences OK?

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 Received on Tue Jan 19 1999 - 19:13:08 CST