Re: Transaction not be cleared at DB_LINK envirement

In article <887015356.2043478029_at_dejanews.com>,   yywang_at_mail.vis.com.tw wrote:
>
> Whenever I issue a 'SELECT' SQL statement pass through DB_LINK,
> I can find a transaction at V$TRANSACTION until 'COMMIT' command.
> and this transaction will lock ROLLBACK_SEGMENT.Is it a normal situation?
> My databases been upgraded from 7.3.2.3 to 7.3.3.4 on DEC OSF,
> two versions have the same situation.
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet

ORACLE7 server distributed system, Volumn I said: when you issue a select of a table across a database link,you acquire a transaction lock and a slot in the transaction table for the rollback segment for the local database. The lock can be released only by a commit or rollback.

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet