Re: MMON slaves spinning
From: Mark Burgess <mark_at_burgess-consulting.com.au>
Date: Fri, 29 Nov 2013 15:07:48 +1100
Message-Id: <E0868C9C-1878-4EBD-856B-2B26C3CBC594_at_burgess-consulting.com.au>
Hi Tony,
>> Gather stats job?
>>
>> On Nov 28, 2013 6:10 PM, "De DBA" <dedba_at_tpg.com.au> wrote:
>> G'day
>>
>> Oracle 11.2.0.3 with Oct13 CPU, on RHEL 6
>>
>> We have 2 servers: one runs just one instance - Production - with Memory_Target = 4G and Memory_Max_Target = 25G. The other server has 7 instances: an Active DG standby database (Memory_target = 2G, no Memory_Max_Target set) and 6 staging databases, each with Memory_Target = 4GB and Memory_Max_Target = 8GB. Both servers have 64GB of physical RAM installed, and 30G of swap available. Top shows that no swap is in use on either.
>>
> ...<snip>...
Date: Fri, 29 Nov 2013 15:07:48 +1100
Message-Id: <E0868C9C-1878-4EBD-856B-2B26C3CBC594_at_burgess-consulting.com.au>
Hi Tony,
what do the memory resize ops stats look like?
Regards,
Mark
On 29 Nov 2013, at 2:15 pm, De DBA <dedba_at_tpg.com.au> wrote:
> Possible, but the production database sees way more inserts/updates and there it is not a problem. You'd think the gather stats job has more to do in production... Also, I think that the gather stats job runs inside the management window, and the spinning starts just after that is closed.. > > On 29/11/13 13:01, Rich wrote:
>> Gather stats job?
>>
>> On Nov 28, 2013 6:10 PM, "De DBA" <dedba_at_tpg.com.au> wrote:
>> G'day
>>
>> Oracle 11.2.0.3 with Oct13 CPU, on RHEL 6
>>
>> We have 2 servers: one runs just one instance - Production - with Memory_Target = 4G and Memory_Max_Target = 25G. The other server has 7 instances: an Active DG standby database (Memory_target = 2G, no Memory_Max_Target set) and 6 staging databases, each with Memory_Target = 4GB and Memory_Max_Target = 8GB. Both servers have 64GB of physical RAM installed, and 30G of swap available. Top shows that no swap is in use on either.
>>
> ...<snip>...
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Nov 29 2013 - 05:07:48 CET