On Fri, Aug 10, 2012 at 5:32 AM, Sofija Blazevski <
sofija.blazevski@...> 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...

Good luck


[Non-text portions of this message have been removed]