I have oracle database with shared server connections enabled with dispatchers. Now I want to know is there an easy configuration in SQL developer to create connection as a Dedicated server connection. Following are the additional details to consider.
- I need to provide this Dedicated connection establishment details to some of the developers as they connect via SQL developer and their shared server connection which will impact on consume connection pool in longer durations as per the nature of their queries.
- I connected SQL developer as a Dedicated connection using TNS file and it is successful. But this is bit complicated to provide as instruction to configure SQL developer to all developers.
- I found that advanced tab in connection parameter and have a doubt whether it can be any help to this scenario.(Tried few ways but no any success)
- Oracle version is 19c and can use any SQL developer releases within latest releases.
As a summary, How to connect to shared server enabled oracle database , via SQL developer as a Dedicated server connection.
Thank you.