Re: Process and sessions overhead
Date: Tue, 8 Mar 2011 09:56:43 -0800 (PST)
Message-ID: <88380.88331.qm_at_web38201.mail.mud.yahoo.com>
I used orastack to get the 1M down to 760K. This was on 9i and 10g
You might be able to get it lower but you need to test and I believe there is a recommendation not to go below 700K. BUT you have to test this to make sure you don't run into any connection issues with your application.
Add the switch /3GB to the line of starting of the operating system in the file boot.ini I also killed any sessions that were more than 2 days old.
We had an issue where the processes and sessions would stay out there for certain applications, so I had a job that identified these and killed them 3 times a day.
K
- On Tue, 3/8/11, K Gopalakrishnan <kaygopal_at_gmail.com> wrote:
From: K Gopalakrishnan <kaygopal_at_gmail.com>
Subject: Re: Process and sessions overhead
To: niall.litchfield_at_gmail.com
Cc: JC1706_at_att.com, oracle-l_at_freelists.org
Date: Tuesday, March 8, 2011, 11:14 AM
Jon/Niall,
Other than the usual minimal memory overheads, there is significant impact on
1. Log File Sync Wait times2. 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:56:43 CST