I have Link server between oracle and MSSQL with following versions,
Oracle – 10G
MSSQL – SQL Server 2008 R2
Link server provider=N'OraOLEDB.Oracle'
After created link server then without actually doing any queries or anything oracle side create 100 or 120 connections (sessions) from this SQL server to oracle server. Any idea on this?