Hi All, Please suggest if there is any solution or workaround for below scenario: We have 15 pre-assigned Oracle Libraries created in Management Console which are used to connect to 15 different schema. These 15 schema are on single Oracle database. Now what I saw is when any user try to access any one of 15 Oracle libraries from SAS Enterprise Guide, there are like 15 connections gets created on that Oracle Database and goes to inactive state after 1 or 2 mins. Libraries are working as excepted, concern here is the no. of connections(15) created even if we do access one or some libraries. Even I tried to replicate this and when I opened EG session and tried to open a library(any one out of 15), then there were 15 sessions were created on that Database. If this will be the case then if multiple users does access any one library then multiple connections will get created and it will cross the session limit there by having an outage on that particular database. 1. Is there any way to have only one connection create for one Library instead of having 15 connections created? 2. Is there any way to identify from SAS end to see which all users are using which Oracle Libraries and their active/inactive state? As of now I am getting these session details from DBA team but I need to know if we can get details from SAS end? 3. Any setup need to done on SAS Management Console to add options to pre-assigned libraries to disconnect if they are in idle state for more than 1 day or any time frame? Note: All of the oracle libraries are pre-assigned, and also during library creation, i have set them to defer=yes, type of connection=Sharedread. These schema's are on a single database Any suggestions will be helpful. Thanks!
... View more
