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

From: David Barbour <david.barbour1_at_gmail.com>
Date: Thu, 15 Jan 2015 13:27:56 -0600
Message-ID: <CAFH+ifeuY5pN=GzJiQ86EvF2bakyrirRsbOAPtHZYGyjvAeDSQ_at_mail.gmail.com>

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
>>
>
>

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

Received on Thu Jan 15 2015 - 20:27:56 CET