Re: Oracle connections and memory usage

• Previous message: Green, Simon: "Re: Migrating to AIX 5.2"
• Maybe in reply to: Vincent D'Antonio: "Oracle connections and memory usage"
• Next in thread: Vincent D'Antonio: "Re: Oracle connections and memory usage"
• Reply: Vincent D'Antonio: "Re: Oracle connections and memory usage"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Date:         Thu, 10 Nov 2005 09:47:21 -0600
To: aix-l@Princeton.EDU

Hmmm....
Looks like you have minperm%=5, maxperm%=10, and maxclient%=10. Probably should
be ok.
Are you using jfs or jfs2? jfs2 hard limits by default but jfs does not.
(strict_maxclient).
 
Oracle is using 22.5GB approx. How many connections is this? I doubt you can
get it, but what is the svmon for oracle just after the database comes up before
any connections (minimum usage)? Can you get an svmon during the 800
connections?
 
Try
svmon -U | awk '$1~"User"{print;getline;print}'
 
also
vmstat 5 5
 
Also, if you can grab a screenprint of a topas session, that might help.
 
 
 
 
  _____

From: IBM AIX Discussion List [mailto:aix-l@Princeton.EDU] On Behalf Of Vincent
D'Antonio
Sent: Thursday, November 10, 2005 9:08 AM
To: aix-l@Princeton.EDU
Subject: Re: Oracle connections and memory usage

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: Green, Simon: "Re: Migrating to AIX 5.2"
• Maybe in reply to: Vincent D'Antonio: "Oracle connections and memory usage"
• Next in thread: Vincent D'Antonio: "Re: Oracle connections and memory usage"
• Reply: Vincent D'Antonio: "Re: Oracle connections and memory usage"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]