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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.