Oracle connections and memory usage

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

  • Next message: Page, Jennifer (RBC Dain): "Re: Lawson" 
    Date:         Thu, 10 Nov 2005 09:12:47 -0500
To: aix-l@Princeton.EDU

    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: Page, Jennifer (RBC Dain): "Re: Lawson"

    Relevant Pages

    • Re: Strange sudden shutdown issue with CF app
      ... Phone devices are notoriously low on virtual memory right out of the box because the OEMs decide to put every little thing into its own DLL and then have 25 processes launched at boot. ... Chris Tacke, Embedded MVP ... We have created an app that basically connects to a web service gets data, then stores it locally on the device, and when a record needs to be modified/added the system first tries to connect the web server sees if its availible, if not then it stores in locally on the device until the connection comes back, now I noticed that if the device does not mess around with the data connection then the application sits nicely as long as its open, and never gets shut down. ... But again most of the time I get no exception at all but just simply disappears. ...
      (microsoft.public.dotnet.framework.compactframework)
    • Re: Strange sudden shutdown issue with CF app
      ... Phone devices are notoriously low on virtual memory right out of the box because the OEMs decide to put every little thing into its own DLL and then have 25 processes launched at boot. ... Chris Tacke, Embedded MVP ... We have created an app that basically connects to a web service gets data, then stores it locally on the device, and when a record needs to be modified/added the system first tries to connect the web server sees if its availible, if not then it stores in locally on the device until the connection comes back, now I noticed that if the device does not mess around with the data connection then the application sits nicely as long as its open, and never gets shut down. ... But again most of the time I get no exception at all but just simply disappears. ...
      (microsoft.public.dotnet.framework.compactframework)
    • Re: Huge memory comsumption of ADODB Connection object
      ... Why I said the Connection ... to nothing, the memory used by my app doesn't decrease, only when I close the ... I take the same opinion as you do, if the cursor doesn't return ... resultset to client, no impact will be imposed to client. ...
      (microsoft.public.data.ado)
    • Re: Socket BeginSend and disconnections
      ... It does depend somewhat on how the connection is broken and where. ... available memory before the network layer can detect the broken ... Is setting the socket buffer to 0 a non-default setting (right now we do not ... sense to catch all exceptions and try to continue gracefully if possible. ...
      (microsoft.public.dotnet.languages.csharp)
    • Re: Not enough storage space
      ... I've tried to close the data source and the session, ... When I close the connection, the code I use is this: ... This will actually release the memory or, as I experienced it, ... oledb Application ...
      (microsoft.public.sqlserver.ce)
    • Quantcast