berniebialt wrote:

>Ann:
>
> Thanks for respond to me. I ran gstat and here are some of the
>details that I see:
>
>Flags 0
>Checksum 12345
>Page Size 4096
>ODS Version 10.1
>Oldest Transaction 434143
>Oldest Active 446334
>Oldest Snapshot 446334
>Next Transaction 446335
>
> Is the issue the difference between Oldest Transaction and Next
>Transaction? I noticed it is a differnce of over 12000. If this is
>the problem, what would cause this to occur? and how could I keep
>this from happening going forward.
>
>Thanks,
>
>Bernie
>
>
>

Bernie,

Don't let your transactions (even a select needs a transaction) to be
open for a long period.

And avoid using Commit Retaining, use "hard commit's"

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.6.6 - Release Date: 08/06/2005