Re: Sequence problem

Frederic,

I've just finished an Oracle class where the instructor talked about how sequence numbers are "cached" (ie. N sequence numbers are generated at once to save on processing overhead). Then, when the database is shut down, any numbers remaining in the cache are lost. It sounds like your cache size must be 20. Look at your sequence generator and try reducing it.

> I have a bizarre sequence problem...sometimes, the sequence increment by
> 1, wich is what I want, but sometimes, the sequence increment by 20, 19,
> 15, or else...I mostly saw jumps of 19 and 20...
>
> And what's more bizarre, it's that most of the time, jumps occurs during
> the 1st entry of the day...
>
 

-- 
Bryan J. Polyak
Senior Programmer Analyst
Hughes/STX - EROS Data Center
Sioux Falls, SD  57198
mailto:polyak_at_edcsns1.cr.usgs.gov
Voice:  (605)594-2578
Fax:    (605)594-6940
WWW:    http://edcwww.cr.usgs.gov/