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 08:34:42 -0600
To: aix-l@Princeton.EDU

    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

    • Re: Oracle connections and memory usage
      ... Oracle connections and memory usage ... leaves less than 8GB for your 10.5GB worth of connections. ... and especially with Oracle, you don't need a large disk cache. ... Behalf Of Vincent D'Antonio ...
      (AIX-L)
    • Re: Effect of listener on existing connections?
      ... Oracle support is not giving us satisfactory results. ... and attempts to create new connections are ... We also see these messages appearing with regularity in our listener ... how does a blocked listener explain the fact that apps with existing ...
      (comp.databases.oracle.server)
    • Re: Multiple Oracle clients in same code - no usernames needed
      ... You might get away with this with an 9 client and if memory serves me ... In all cases the connections have to 'external' - No name or password ... The mechanism changed to the Oracle wallet in 10 for external ... the 2 oracle client libs will export a lot of the same ...
      (perl.dbi.users)
    • Re: Multiple Oracle clients in same code - no usernames needed
      ... You might get away with this with an 9 client and if memory serves me correctly it can connect both wallet and the old 8 way ... In all cases the connections have to 'external' - No name or password ... The mechanism changed to the Oracle wallet in 10 for external ... the 2 oracle client libs will export a lot of the same ...
      (perl.dbi.users)
    • Re: Effect of listener on existing connections?
      ... Solaris 10 inside a ZFS zone (our previous system was Oracle ... and attempts to create new connections are ... issue of the listener locking up if you're not using ONS. ... how does a blocked listener explain the fact that apps with existing ...
      (comp.databases.oracle.server)
    • Quantcast