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: Millions of sequence in a database to record the counter for millions of products?

Re: Millions of sequence in a database to record the counter for millions of products?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 20 Jul 2002 10:48:05 +0200
Message-ID: <qs8ijuo2rq98vm03ao033fgkg3ai10007c@4ax.com>


On 20 Jul 2002 07:17:43 GMT, chao_ping <chao_ping_at_163.com> wrote:

>Norman Dunbar wrote:
> > Chao,
> > are you aware that sequences can and do 'lose' values and should not be
> > relied upon to produce an unbroken sequence of numbers? The following is
> > an example :
>
>
>hi, In fact, loose number can be easily solved by nocache option while
>you create the sequence:). You can do a simple test, no matter how you
>flush it, bouce the instance, it will not get lost. And even if it is
>not cached, it will be rather fast to get a count add.
>
> What i care the if i have that much sequence, the system tablespace
> will be unacceptablly large, and never heard of any one using that
> much sequence. Only with 100K sequence, my system table: SEQ$, has
> grown to 13M,not knowing other system tables.
>SQL> select count(*) from dba_sequences where sequence_owner='SYSTEM';
>
> COUNT(*)
> ----------
> 100020
>

I don't think anyone is using 100k sequences as sequences are not bound to a table

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sat Jul 20 2002 - 03:48:05 CDT

Original text of this message

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