Skip to Main Content

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 Requirements per Connection

882291Apr 27 2012 — edited Apr 30 2012
I've done some web research and I've learned that each Database Connection requires a certain amount of memory (2Mb + sort area + hash area). My question is: Is this memory dynamic or static? When the database comes up, does it set aside memory for X number of connections? Or does it only take the space when the connection is made, and then 'drop' it when the requirement no longer exists?

Forgive me if I've asked this question poorly - I am still quite new.

Thanks!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 28 2012
Added on Apr 27 2012
4 comments
993 views