On 10.8.2012 18:20, Ann Harrison wrote: > > On Fri, Aug 10, 2012 at 5:32 AM, Sofija Blazevski < > [email protected] > <mailto:sofija.blazevski%40grappologroup.com>> wrote: > > > > > This affected entire database (all generators actively in use), mostly > > generators are used for Integer columns, some are used for varchar > > columns in case like document number that has string prefix, the prefix > > can vary within a table. > > > > I'm not sure how could type of column produce a problem like this? > > > > > Values for generators are stored densely on a page - depending on the page > size, somewhere between a lot and a whole lot fit on a page (4 bytes per > generator, 4-16K bytes per page, less page overhead). Generator pages are > written out when a transaction that changed them commits, so they > should be > written often. It's vaguely possible there's something going on with your > disk... > Thank you for this information.
> > Good luck > > [Non-text portions of this message have been removed] > > [Non-text portions of this message have been removed]
