Solved: connection pool against oracle sessions

Former Member · ‎02-17-2009

Hello,

I have a doubt about connection pool.

Is it true to consider that for each connection at connection pool it should create one session at Oracle database?

I mean, if I have 10 active connections at the Application server connection pool, so it should exists 10 active sessions at database.

Is it 1 to 1 relational?

Number of connections at Application server = number of Sessions at v$parameter

Is it true?

Thanks in advance,

Walde Requena

Former Member · ‎02-17-2009

Hai,

As far as I know it is one to one ratio.

You can have a look into the below link for more details.

Regards,

Yoganand.V

connection pool against oracle sessions