Kevin Stanton wrote:

>
> I just took a quick look at the stats and below is what I found. My
> customer is complaining of slowness but that could be 1 of a couple
> offending reports I need to analyze.
>
> I know the main concern is oldest active transaction - is the gap between
> oldest active and next transaction large enough to be concerned about? I do
> a backup/sweep every night off hours.
>

...

> Oldest transaction 111981
> Oldest active 111982
> Oldest snapshot 111970
> Next transaction 120437

It could be. When it's convenient, run gstat -a -r against
the database before you do a sweep or backup. That will
report on the number of old record versions in each table,
and give you an idea of the number of index duplicates. I
think you're using an ODS that's old enough that index
duplicates are a problem.


Cheers,

Ann