Connection setting to SHARED or DEDICATED

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
glennn
Posts: 3
Joined: Thu 13 Nov 2014 20:12

Connection setting to SHARED or DEDICATED

Post by glennn » Wed 23 Sep 2015 12:31

Hi
Using: Devart.Data.Oracle, Version=8.4.293.0

Here is our connection String

Code: Select all

User Id=APPL_ACCT;Password=********;Server=(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ORACLET) (Port = 1521))(CONNECT_DATA = (SID = ORACLET) (SERVER=[b]DEDICATED[/b])));Direct=True;Persist Security Info=True
We are trying to ensure that it is using DEDICATED but whenever we check

Code: Select all

SELECT server from v$session 
for that User Id, the server is is SHARED not DEDICATED. We are using the DIRECT mode (True) and are connecting successfully but we are trying to confirm we are using the DEDICATED connection because of some other issues we are having in one environment but not others.

Thank you,
Glenn

Pinturiccio
Devart Team
Posts: 2141
Joined: Wed 02 Nov 2011 09:44

Re: Connection setting to SHARED or DEDICATED

Post by Pinturiccio » Thu 24 Sep 2015 15:14

There is no possibility to specify which server process to use in the Direct mode. We will investigate the possibility to implement such feature, but we can't tell any timeframe at the moment.

Post Reply