Category
Data Sources
Product Version
7.3
How much Oracle Sessions yellowfin maintains?
Answered
Hi,
I have few queries on Oracle Database Sessions with Yellowfin configuration DB and Application Database,
-As I can see we can define Max Connections in Datasource, for example, I have 3 data source and each with Max Connections 5, in total it can have max 15 sessions?
- How many connections are defined for Configuration Database and what is default timeout, as there is 15 connection with configuration database which never closes?
- please share any other information available on Oracle Sessions with yellowfin.
Regards
Pratap
The same question
Hi Pratap,
I hope all is well,
Question 1
As I can see we can define Max Connections in Datasource, for example, I have 3 data source and each with Max Connections 5, in total it can have max 15 sessions?
There will be a maximum of 15 connections to 3 datasources. However this is not related to the number of user sessions, as the datasource connection pool will share the same connections between sessions. Yellowfin will start with the minimum number of connections and it will only create a new connection to the database if all existing connections are in use at the time.
Question 2
How many connections are defined for Configuration Database and what is default timeout, as there is 15 connection with configuration database which never closes?
The number of connections for the repository database is defined in the web.xml. By default the minimum is 2 and the maximum is 25.
I hope this helps Pratap.
Regards,
Mark
Hi Pratap,
I hope all is well,
Question 1
As I can see we can define Max Connections in Datasource, for example, I have 3 data source and each with Max Connections 5, in total it can have max 15 sessions?
There will be a maximum of 15 connections to 3 datasources. However this is not related to the number of user sessions, as the datasource connection pool will share the same connections between sessions. Yellowfin will start with the minimum number of connections and it will only create a new connection to the database if all existing connections are in use at the time.
Question 2
How many connections are defined for Configuration Database and what is default timeout, as there is 15 connection with configuration database which never closes?
The number of connections for the repository database is defined in the web.xml. By default the minimum is 2 and the maximum is 25.
I hope this helps Pratap.
Regards,
Mark
Replies have been locked on this page!