Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

memory of each connection

user88831Mar 18 2013 — edited Mar 23 2013

Hi Guys,

11.2.0.3
HP-UX

Currently my weblogic has 120 concurrent connections to the database.
There is a requirement to scale up the number of concurrent connections to 300.
We have did some study and quite be quite sure that the current sga and pga is required. (the additional connections will be firing the same sql which is very well tuned.
However any idea each additional connection to the database will take up additional memory just for the connection?
Will is be using the memory in the PGA? Or outside the PGA for the connection overhead?
We are not using MTS.

thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 20 2013

Added on Mar 18 2013

#general-database-discussions

19 comments

3,354 views