Page 1 of 1

Connection setting to SHARED or DEDICATED

Posted: Wed 23 Sep 2015 12:31
by glennn
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

Re: Connection setting to SHARED or DEDICATED

Posted: Thu 24 Sep 2015 15:14
by Pinturiccio
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.