Database Connections And Memory Usage

Can someone explain or provide links that will explain the relationship between number of connections and memory usage for Oracle 10.2
xoxomosAsked:
Who is Participating?
 
ee_reachCommented:
Here is a really good explanation using Oracle 11.
http://docs.oracle.com/cd/B28359_01/server.111/b28310/manproc002.htm
Start at the section called "Example of Memory Usage for Dedicated Server, Shared Server, and Database Resident Connection Pooling"

With that explanation, you can probably make the calculations for 10.2  using this document:
http://docs.oracle.com/cd/B19306_01/server.102/b14220/memory.htm


0
 
slightwv (䄆 Netminder) Commented:
The docs.

Like many of your recent questions, there really isn't any way to answer this.  There is no magic formula.

There is the SGA/PGA memory usage.  This varies on what the individual connection is doing.

Then there is the OS memory depending of 'what' is doing the connection.  Say sqlplus, there is program memory usage.
0
 
xoxomosAuthor Commented:
That's good but i am still not understanding memory usage on our machine.
It's Solaris with 16G memory and has lately been running at 95+ percent usage.
Now the total allocated to Oracle, SGA + PGA  is less than half that.  Oracle is the only thing running on the machine.   Even if we give 2GB for os I don't understand how the usage would ever get over 75%
0
 
slightwv (䄆 Netminder) Commented:
>> I don't understand how the usage would ever get over 75%

From your previous question I have asked and not seen you reply:

What is using the memory?  Your sys admins should be able to tell you.

If you have 2000 sqlplus connections, that will eat up a bunch of RAM outside the SGA and PGA.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.