Re: MMON slaves spinning
From: De DBA <dedba_at_tpg.com.au>
Date: Fri, 29 Nov 2013 13:15:30 +1000
Message-ID: <529806D2.8020203_at_tpg.com.au>
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..
Date: Fri, 29 Nov 2013 13:15:30 +1000
Message-ID: <529806D2.8020203_at_tpg.com.au>
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 <mailto: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 - 04:15:30 CET