Re: Process and sessions overhead
From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Tue, 8 Mar 2011 17:56:49 +0000
Message-ID: <AANLkTimF8emxGLbVoHVEKs7hn9aN7WRDhoMFxsjXZVkK_at_mail.gmail.com>
Hi
Its a surprise to me that log file sync should be affected by the size of the process table, rather than the number of active processes (or private redo strands presumably?)
Date: Tue, 8 Mar 2011 17:56:49 +0000
Message-ID: <AANLkTimF8emxGLbVoHVEKs7hn9aN7WRDhoMFxsjXZVkK_at_mail.gmail.com>
Hi
Its a surprise to me that log file sync should be affected by the size of the process table, rather than the number of active processes (or private redo strands presumably?)
On 8 Mar 2011 17:14, "K Gopalakrishnan" <kaygopal_at_gmail.com> wrote:
Jon/Niall,
Other than the usual minimal memory overheads, there is significant impact on
- Log File Sync Wait times
- Calculated Value of MBRC
Starting from 10gR2, MBRC is auto tuned. The value of processes is taken in to consideration (along with buffer cache,etc) while calculating the MBRC. So I would exercise caution while playing with these parameters.
-Gopal
On Tue, Mar 8, 2011 at 11:07 AM, Niall Litchfield <
niall.litchfield_at_gmail.com> wrote:
>
> Or I c...
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 08 2011 - 11:56:49 CST