Re: Oracle connections and memory usage

From: Vincent D'Antonio (dantoniov_at_GMAIL.COM)
Date: 11/10/05

  • Next message: Green, Simon: "Re: Migrating to AIX 5.2" 
    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
    >

  • Next message: Green, Simon: "Re: Migrating to AIX 5.2"

    Relevant Pages