Number of Sessions Opened in Remote Database when Executing Query with Oracle Database Link
0
votes
1
answer
182
views
I have a query on an Oracle database that involves accessing a remote database through a database link. Here's the query:
SELECT t1.col1 , t2.col2
FROM Table1 t1
LEFT JOIN Table2@dblink t2 ON (t1.id=t2.id)
When executing this query, I understand that it will open one session in the local database. However, I'm uncertain about the number of sessions that will be opened in the remote database query and will be executed from java application.
For instance, if I have approximately 100,000 records to retrieve, how many sessions will be opened in the remote database during the execution of this query?
I appreciate any insights or explanations regarding the session management behavior in this scenario.
Asked by Mustafa zuhair
(1 rep)
Apr 4, 2024, 11:01 PM
Last activity: Jun 30, 2025, 12:02 AM
Last activity: Jun 30, 2025, 12:02 AM