Re: Process and sessions overhead
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: K Gopalakrishnan <kaygopal@xxxxxxxxx>
- Date: Tue, 8 Mar 2011 17:56:49 +0000
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@xxxxxxxxx> wrote:
Jon/Niall,
Other than the usual minimal memory overheads, there is significant impact
on
1. Log File Sync Wait times
2. 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@xxxxxxxxx> wrote:
>
> Or I c...
Other related posts:
