Connection setting to SHARED or DEDICATED
Posted: Wed 23 Sep 2015 12:31
Hi
Using: Devart.Data.Oracle, Version=8.4.293.0
Here is our connection String
We are trying to ensure that it is using DEDICATED but whenever we check 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
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=TrueCode: Select all
SELECT server from v$session Thank you,
Glenn