Re: problem in creating a new sequence(oracle 8i web db)

I know exactly what his problem is...

When you create a sequence, make sure that you use the 'NOCACHE' option. Otherwise, 20 values will be cached (default value is 20 I think). Anytime the database is shutdown (nightly, for backups, I assume), you will "lose" the cached values.

In any event, the performance hit of using 'NOCACHE' is not very significant for a small to medium OLTP.

Also, if your application is dependent on the sequence being truly sequential... You may want to review your data model! :)

JP

ed.prochak_at_alltel.com (Ed prochak) wrote in message news:<e51b160.0203050626.c21889d_at_posting.google.com>...
> imseema_at_rediffmail.com (sima) wrote in message news:<ba679cdf.0203032332.1092d911_at_posting.google.com>...
> > hello! i am developing an application using oracle 8i web db. the day
> > the create a sequence ,it works fine. but next day the 'start value'
> > of sequence increases by itself(it becomes 21).what is the reason? how
> > can i get rid of this problem?
> > u can reply me at imseema_at_rediffmail.com
>
> Please provide more detail. I really cannot understand what you think
> the problem is. (I have some ideas of what is happening, but I do not
> want to answer the wrong question.) Examples would be very helpful.
> The more information you provide, the easier it is for you to get
> help.
>
> Ed
Received on Tue Mar 05 2002 - 23:10:14 CET