Re: MMON slaves spinning
- From: Mark Burgess <mark@xxxxxxxxxxxxxxxxxxxxxxxxx>
- To: De DBA <dedba@xxxxxxxxxx>
- Date: Fri, 29 Nov 2013 15:07:48 +1100
Hi Tony,
what do the memory resize ops stats look like?
Regards,
Mark
On 29 Nov 2013, at 2:15 pm, De DBA <dedba@xxxxxxxxxx> 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@xxxxxxxxxx> 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>...
Other related posts:
