Re: Process and sessions overhead
Date: Tue, 8 Mar 2011 17:56:49 +0000
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:
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.
On Tue, Mar 8, 2011 at 11:07 AM, Niall Litchfield <
> Or I c...