How much Oracle Sessions yellowfin maintains?

Pratap Singh shared this question 8 months ago
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

Comments (5)

photo
1

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

photo
1

Hi Mark,

Thanks for the revert,

there are few connections(approx 15) with configuration DB which never closes. if I will not use yellowfin for a day or two it still remains open. what can be the problem?

regards

pratap

photo
1

Hi Pratap,

This is correct... When YF starts it creates a pool of connections and increases if it needs more (only till Max is reached). Those connections are for yellowfin and never close off. This shouldn't cause any problems whilst using YF.

Regards,

Mark

photo
1

Hi Mark,

Thanks for the clarification.

Regards

Pratap

photo
1

Hi Pratap,

No problem, I am pleased I've answered the questions you had... Please feel free to filling our "Satisfaction Survey"

Regards,

Mark

photo