Re: Oracle connections and memory usage

From: Hans-Dieter Kutz (hdkutz_at_HDKUTZ.DE)
Date: 11/10/05

  • Next message: Tom Wood: "Re: wtmp filling up" 
    Date:         Thu, 10 Nov 2005 15:26:41 +0100
To: aix-l@Princeton.EDU

    On Thu, Nov 10, 2005 at 09:12:47AM -0500, Vincent D'Antonio wrote:
    >
    > 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.
    Look at
    http://www.redbooks.ibm.com
    for
    SG24-5511-00 Database Performance on AIX in DB2 UDB and Oracle Environments

    It might be helpful to tune your System. There also tuning tips for Oracle.
    Cheers,
    ku 

    -- 
Darth Vader:
	There is no escape. Don't make me destroy you.
	pauses Luke, you do not yet realize your importance.
	You have only begun to discover your power. Join me,
	and I will complete your training. With our combined
	strength, we can end this destructive conflict and
	bring order to the galaxy.
Luke Skywalker:
	I'll never join you!
Darth Vader:
	If you only knew the *power* of the dark side. Obi-wan
	never told you what happened to your father.
Luke Skywalker:
	He told me enough! He told me *you* killed him.
Darth Vader:
	No. *I* am your father.
  • Next message: Tom Wood: "Re: wtmp filling up"

    Relevant Pages

    • Re: Huge data
      ... >> connect everytime to the database to get a record or a group of records ... >> take more time than retreiving all the data and work with it offline, ... > underlying database connection each time - connection pooling takes ... > memory at a time, unless you're updating every row in the table. ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: Selecting from Datasets
      ... SQL provider manage Connection pooling which mean whatever sqlConnection ... instance you call it's just one virtual connection with the database managed ... > If I then have a datagrid and I only want it to display Field 1 and field ... > is no longer displayed on the page, so there shouldn't be a memory ...
      (microsoft.public.dotnet.languages.csharp)
    • Re: Memory issue
      ... Can you post a complete example of your call to the database. ... Are you releasing connections back into the pool or is ... > I have a problem with memory when I use a connection to a database. ... > I have a problem with memory using SQLserver on a server running WIN2K ...
      (comp.lang.java)
    • Re: Huge data
      ... > I haven't much used dataReaders. ... > It's an Oracle 9i DataBase. ... underlying database connection each time - connection pooling takes ... If you can't fit the whole of the data into memory, ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: ADO Connection Timeout
      ... so what happens when a connection failure forces one station to revert ... to a local database? ... Further, you *will* have contention issues, Jet does not support record ... to the central server, but you are willing to live with periods where it ...
      (microsoft.public.data.ado)