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.
Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.
From the Oracle SQL Reference (http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm) we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
Cursors in Oracle:
A cursor is used to process individual rows returned by database system for a query.
In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.