How to troubleshoot heavy RAM consumption

From: Neil Kodner <nkodner_at_gmail.com>
Date: Wed, 10 Mar 2010 10:14:12 -0700
Message-ID: <ae2c46ba1003100914j3362a1f8y7e88847af9a15d25_at_mail.gmail.com>

Our 32gb solaris 9 server running two instances of 10gr2

One small db to support OID (sga max size 288M, pga aggregate 32M) and one of our production dbs(6gb pga aggregate target, 12gb sga_max_size).

According to top, before the workday starts, we are sitting at 10-12gb available physical memory. Once our users get working, that number drops to 500-600mb available. Top reports 29G swap in use, 11G swap free. OEM says that we're performing heavy swapping and I'm not sure how to resolve this.

We typically have 1500-1700 connections. My gut tells me that pga might be too small and that sga is too large, but i'm not really able to tell.

My v$pgastat and v$sgastat can be viewed at http://spreadsheets.google.com/ccc?key=0ArUTHdqN0J--dFZBNE0wU0JpUW1Na1hVYlBfeFVYOEE&hl=en

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Mar 10 2010 - 11:14:12 CST