Re: why frequent commits are not good?

> Distributed SELECTS do start a local transaction.
> If you NEVER commit, and stay connected
> indefinitely, you will stop your rollback segment
> from being .....

Hi!

I dont speak these lock-flags fluidly, so I wonder; what exactly is locked (see
NetComrade's posting) when doing this query?

select empno,ename from emp_at_remotedb;

And does this raises a lock locally so that no other session on the local datababase
can query the same remote table until commit/rollback?

Frank Received on Sat Mar 17 2001 - 08:28:48 CST