Re: Sequence Number Loss

From: <nettmaster_at_my-dejanews.com>
Date: Fri, 08 Jan 1999 15:36:15 GMT
Message-ID: <7758lf$6us$1@nnrp1.dejanews.com>

Hi there-

Try creating the sequence with the "nocache" option. By default, when you create a sequence (in Oracle8) 20 values from the sequence are preallocated and kept in memory. When you shut down the database, these sequence values are trashed. When the database is started up, the next 20 values are selected from the sequence and kept in memory.

...jeff

In article <369593FD.4831_at_visi.net>,
  zhang_at_visi.net wrote:
> Hi, Everyone,
>
> I have a problem with Oracle Sequence number:
>
> Enviroment: Oracle 8 in Sun E3000 server with Solaries2.6.
> Problem: When Oracle is shutdown ( "shutdowm immediate")
> for a cold backup, Oracle sequences seem lose some
> number( advace some number), sometimes OK, and
> other times very bad. Our users are not happy about some
> numeric sequence numbers( like account#) because they are
> not consecutive.
> Suggestions sought: we want to use Sequence as our primary key
> source because they are guranteed to be unique and
> have good perfomance, but we also want the number to
> be consecutive( at least most of the time). Any suggestions
> and advices are highly appreciated.
>
> from: Sean Zhang
> <zhang_at_visi.net>
>

--

---

jeff grant, it manager, nettwerk productions http://www.nettwerk.com http://www.nettweb.com mailto:nettmaster_at_my-dejanews.com

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Jan 08 1999 - 09:36:15 CST