Re: Oracle connections and memory usage

From: Hunter, Mark (Mark.Hunter_at_ANHEUSER-BUSCH.COM)
Date: 11/10/05

  • Next message: Vincent D'Antonio: "Re: Oracle connections and memory usage" 
    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

  • Next message: Vincent D'Antonio: "Re: Oracle connections and memory usage"

    Relevant Pages