Millions of sequence in a database to record the counter for mill ions of products?

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Fri, 19 Jul 2002 15:17:30 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7026507E9@lnewton.leeds.lfs.co.uk>

Hi Sybrand,

As you say, it is a problem (and documented). The nocache option does 'fix' it but is quite a performance hog.

Cheers,
Norman.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: postbus_at_sybrandb.demon.nl (Sybrand Bakker) [mailto:postbus_at_sybrandb.demon.nl]
Posted At: Friday, July 19, 2002 2:25 PM Posted To: server
Conversation: Millions of sequence in a database to record the counter for millions of products?
Subject: Re: Millions of sequence in a database to record the counter for mill ions of products?

This is known and documented behavior. The nocache option can be used to prevent most of it. Usually however it is completely unimportant there are 'holes' in a series.

Regards

Sybrand Bakker
Senior Oracle DBA Received on Fri Jul 19 2002 - 09:17:30 CDT