> Hi All,
>
> With the GAP value for the sweep of a database, is there a value
> or range that this Gap Value can be that is considered normal, as
> i type this email the calculated GAP is 40000, twice that of the
> sweep setting, is this normal ??? what should the GAP range be,
> also what is considered a SHORT transaction? milliseconds -
> seconds range??
>
> Craig

I've never thought of a short transaction as being measured in time. It has
more to do with some kind of index of intervening transactions from the
start to finish of the said transaction. If, from the start of a
transaction, many other transactions are started before the said trans is
committed then this is a long trans. If a trans is started on a single user
system running one trans at a time, then the trans by nature is "short" even
though it may last 30 minutes or longer.
Alan