Re: How to troubleshoot heavy RAM consumption
Date: Wed, 10 Mar 2010 17:03:19 -0700
Message-ID: <ae2c46ba1003101603u7e1324b5kea9a21ef150e611a_at_mail.gmail.com>
Thanks Jared. I'm trying to figure out if we are in need of more tuning, or if its a case of outgrowing our hardware. I'm leaning 98% toward the latter. Without giving up too much information, the economic and employment situation has caused our db use to grow at a VERY large level. We built this server 5-6 years ago before. We used to sit at about 700-800 connections, we now push about 1700, all from internal and external facing applications.
On Wed, Mar 10, 2010 at 4:57 PM, Jared Still <jkstill_at_gmail.com> wrote:
>
> On Wed, Mar 10, 2010 at 2:09 PM, Neil Kodner <nkodner_at_gmail.com> wrote:
>
>> Thanks. As an aside, while we're having memory/paging issues, is there a
>> good way to tell if our SGA is in fact too large? One of the challenges
>> that we face is that one of the heavier-used applications does not use
>> prepared statements and that has the potential to pollute the shared pool.
>> We enable cursor-sharing at the session level for these users.
>>
>>
> In general I would think the SGA too large if there were more
> free memory available at peak periods than need be.
>
> select *
> from v$sgastat
> where name = 'free memory'
> order by upper(name)
> /
>
> The 'need be' is the hard part. I personally don't have to go
> through this kind of exercise very often.
>
> If I had allocated 12 gig for an SGA and consistently had 2 gig
> free I would certainly consider distributing some of that elsewhere.
>
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
> Oracle Blog: http://jkstill.blogspot.com
> Home Page: http://jaredstill.com
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 10 2010 - 18:03:19 CST