Session in Remote database
Posted on 2010-09-22
I have one question, but have limited time to get answer.
There are two DB, say dev and Prod.
DB link is created in Dev pointing to Prod say schema S1 (Dev) to S2(Prod)
there are queries from Dev-S1 session like this
insert into table_1 select .... from table_1@to_prod where ...
insert into table_2 select .... from table_2@to_prod where ...
insert into table_400 select .... from table_400@to_prod where ...
assum there are 400 inserts.
Here is the question.
1. How many remote connection will be there at any given point in time in Prod.
2. How to find Prod session info when above query is running from Dev.