Sean, > > > Oldest transaction 1 > > > Oldest active 2 > > > Oldest snapshot 2 > > > Next transaction 492
> > > Gstat was started right after the restore. Is it normal to have so > > > many active transactions right after the database restore? > > > > Yes. I suppose you used the -verbose switch, right? In this case each index > > is > > created in a separate transaction. > Even it that switch was used, why would the transactions appear to active? I could understand if you think that tx 2 is still active, but why do you think that tx 3, tx 4 ... tx 491 is also active ??? What make you think so ? Regards, Vlad
