* at 16/07 15:51 +0100 Dave Cross said: > On Tue, Jul 16, 2002 at 03:56:23PM +0100, Alex McLintock ([EMAIL PROTECTED]) wrote: > > > > For the record I hit this sort of problem doing some perl web stuff with > > Oracle. > > It seemed that because Oracle was multiprocessor each oracle process would > > grab for itself the next 20 ids. if you stopped and started the server > > there would be a gap of 19 between consecutive requests.... > > Sybase has a similar feature - except each process grabs about a million > ids. This leads to some very confusing numbers.
I've been told that the number they grab is editable but the DBA who told me did imply that it was a bad thing to at any time other than creating the database. Or so I recall as the next thing he said was "here, use this stored procedure and table thing instead". s