Commit key active after dblink query.

[sqldoctor]

Why does the commit key become active as if there is a pending transaction after I select from a remote table via a database link?

 

[Bernhard S]

Whenever you query via database link Oracle DB automatically opens a transaction!
Check out the explanation here:http://www.jlcomp.demon.co.uk/faq/dblink_commit.html

 

[sqldoctor]

Thanks!