Connection setting to SHARED or DEDICATED

Connection setting to SHARED or DEDICATED

Postby glennn » Wed 23 Sep 2015 12:31

Using: Devart.Data.Oracle, Version=

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,
Posts: 3
Joined: Thu 13 Nov 2014 20:12

Re: Connection setting to SHARED or DEDICATED

Postby 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.
Devart Team
Posts: 1955
Joined: Wed 02 Nov 2011 09:44

Return to dotConnect for Oracle