select in a view with a remote connection need a commit? Does this leaves open connections?
Hi experts.
I have a view in a database that connects to a remote database. Does the select * from this view each time, leaves open transactions or does not release undo segments if I don't use a commit or close the db link?
This I question because I read the following document:
http://docs.oracle.com/cd/B28359_01/server.111/b28310/ds_appdev002.htm
Controlling Connections Established by Database Links
When a global object name is referenced in a SQL statement or remote procedure call, database links establish a connection to a session in the remote database on behalf of the local user. The remote connection and session are only created if the connection has not already been established previously for the local user session.
I have a view in a database that connects to a remote database. Does the select * from this view each time, leaves open transactions or does not release undo segments if I don't use a commit or close the db link?
This I question because I read the following document:
http://docs.oracle.com/cd/B28359_01/server.111/b28310/ds_appdev002.htm
Controlling Connections Established by Database Links
When a global object name is referenced in a SQL statement or remote procedure call, database links establish a connection to a session in the remote database on behalf of the local user. The remote connection and session are only created if the connection has not already been established previously for the local user session.
2