Re: Oracle connections and memory usage

• Previous message: Hunter, Mark: "Re: Oracle connections and memory usage"
• In reply to: Hunter, Mark: "Re: Oracle connections and memory usage"
• Next in thread: Hunter, Mark: "Re: Oracle connections and memory usage"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Date:         Thu, 10 Nov 2005 10:08:13 -0500
To: aix-l@Princeton.EDU

Here is the requested info:
 minperm = 388872
maxperm = 777747
maxclient% = 10
 SGA is set to 16GB, there are no other appl. running on this system just
oracle.
out put of svmon -U is hugh but here is the beginning of the output:

===============================================================================
User Inuse Pin Pgsp Virtual LPageCap
oracle8 5695786 89342 68764 5751820 -

...............................................................................
SYSTEM segments Inuse Pin Pgsp Virtual
65554 65541 1 65555

Vsid Esid Type Description LPage Inuse Pin Pgsp Virtual
0 0 work kernel segment (lgpg_vsid=0) Y 65536 65536 0 65536
12b8a4 - work - 11 3 1 12
2739cf - work - 7 2 0 7

...............................................................................
EXCLUSIVE segments Inuse Pin Pgsp Virtual
5621614 22340 68628 5677608

Numbers don't lie and I agree with you that I should be able to get my 1500
connections no problem but the system seems to disagree with me on this,
maybe I am missing a process that is using more memory than being reported
but I couldn't find anything.

Thanks again for you suggestions,

Vince

 On 11/10/05, Hunter, Mark <Mark.Hunter@anheuser-busch.com> wrote:
>
> More information please.
> What are your vmo minperm%, maxperm%, and maxclient%? Hopefully you have
> tuned these already.
> How big is the oracle SGA? Most oracle DBA like to set these really large.
> What other application run on the box?
> What does svmon -U using your RAM?
> Based upon your numbers, 7MB * 1500 connection = 10.5GB of RAM, so you
> should have plenty.
>

  *Mark Hunter*
> Anheuser-Busch Cos.
> MIS Consultant, ES&SO Server Planning and Integration
> (Office: (314) 632-6663
> ÊFax: (314) 632-6901
> ?Pager: (314) 841-4026
> *Email: Mark.Hunter@Anheuser-Busch.com
>
> The information transmitted (including attachments) is covered by the
> Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, is intended
> only for the person(s) or entity/entities to which it is addressed and may
> contain confidential and/or privileged material. Any review, retransmission,
> dissemination or other use of, or taking of any action in reliance upon,
> this information by persons or entities other than the intended recipient(s)
> is prohibited. If you received this in error, please contact the sender and
> delete the material from any computer.
>
>
> ------------------------------
> *From:* IBM AIX Discussion List [mailto:aix-l@Princeton.EDU] *On Behalf Of
> *Vincent D'Antonio
> *Sent:* Thursday, November 10, 2005 8:13 AM
> *To:* aix-l@Princeton.EDU
> *Subject:* Oracle connections and memory usage
>
> AIXer's,
> I have a P570 8way with 32GB of memory running oracle 10G. Per my DBA each
> connection to the database is sucking up 7MB of memory which after a while
> we start to swap, this is about 800 connections and need we to support a lot
> more than this (1500).
> Is there anything that I can tune to improve memory usage or is there
> anything within oracle that can be tuned? I have AIX 5.3 ML2 no lpars just
> a full system.
> Any info to help this would be great.
> Thanks in advance for your comments and suggestions,
> Vince
>

• Previous message: Hunter, Mark: "Re: Oracle connections and memory usage"
• In reply to: Hunter, Mark: "Re: Oracle connections and memory usage"
• Next in thread: Hunter, Mark: "Re: Oracle connections and memory usage"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]