On 10.8.2012 18:20, Ann Harrison wrote:

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