Re: How can I tell how much memory a database is using?

From: Sandra Becker <sbecker6925_at_gmail.com>
Date: Thu, 15 Jan 2015 13:04:24 -0700
Message-ID: <CAJzM94DKPr_ki5YpNmWhbty-q7avFQnuBCSDP7WfdDMOh-Z84Q_at_mail.gmail.com>

Not downsizing, just got bigger, better servers so we're consolidating, simplifying, saving money, whatever the execs are calling it these days. Turns out I had calculated the memory requirements correctly, but the SEs did not configure the swap correctly. Glad it wasn't me this time. :-)

Checking sga+pga suggestion was very helpful. Thanks everyone.

Sandy

On Thu, Jan 15, 2015 at 12:27 PM, David Barbour <david.barbour1_at_gmail.com> wrote:

> It depends on whether you're using AMM (11g and up) or ASMM (9i - sort of
> - and up). Read about what the PGA is and does here:
> http://docs.oracle.com/cd/E11882_01/server.112/e40540/memory.htm#CNCPT007
>
> Read about AMM here:
> http://www.oracle.com/technetwork/articles/sql/11g-manage-101028.html
>
>
>
> On Thu, Jan 15, 2015 at 1:17 PM, David Barbour <david.barbour1_at_gmail.com>
> wrote:
>
>> Downsize?
>>
>> On Thu, Jan 15, 2015 at 12:51 PM, Sandra Becker <sbecker6925_at_gmail.com>
>> wrote:
>>
>>> Sorry, yes, same OS. Nex question: what parameters do I change to
>>> reduce the pga?
>>>
>>> Sandy
>>>
>>> On Thu, Jan 15, 2015 at 11:50 AM, David Barbour <
>>> david.barbour1_at_gmail.com> wrote:
>>>
>>>> SGA +PGA?
>>>>
>>>> On Thu, Jan 15, 2015 at 12:44 PM, Mark J. Bobak <mark_at_bobak.net> wrote:
>>>>
>>>>> What OS is current system? Target OS is the same?
>>>>> On Jan 15, 2015 1:35 PM, "Sandra Becker" <sbecker6925_at_gmail.com>
>>>>> wrote:
>>>>>
>>>>>> We're moving all of our databases to new servers. SEs are wanting to
>>>>>> know how much memory each of the new servers will need to host the
>>>>>> databases. We're moving from a set of 5 down to a set of 3. Mix of
>>>>>> releases from 9.2.0.4 to 11.2.0.4.
>>>>>>
>>>>>> --
>>>>>> Sandy
>>>>>> GHX
>>>>>>
>>>>>
>>>>
>>>
>>>
>>> --
>>> Sandy
>>> GHX
>>>
>>
>>
>

-- 
Sandy
GHX

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

Received on Thu Jan 15 2015 - 21:04:24 CET