Home -> Mailing Lists -> Oracle-L -> Re: Process and sessions overhead

Re: Process and sessions overhead

From: K Gopalakrishnan <kaygopal_at_gmail.com>
Date: Tue, 8 Mar 2011 11:14:15 -0600
Message-ID: <AANLkTik5e9x_c5bscd3CK9=yJeUZghhEDh2k1-EpCN5Z_at_mail.gmail.com> 





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_at_gmail.com> wrote:



> Or I could  read the question! The extra space allocated to the process

> table itself isn't worth caring about - the allocations as processes connect

> is

>

> On 8 Mar 2011 17:04, "Niall Litchfield" <niall.litchfield_at_gmail.com>

> wrote:

>

> On Windows 1000m! I don't have other o/s details in my brain. Also consider

> if hugepages is in use or not

>

>

>



--
http://www.freelists.org/webpage/oracle-l


Received on Tue Mar 08 2011 - 11:14:15 CST












Original text of this message