global cache CR requests and _fairness_threshold parameter

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Wed, 26 Mar 2003 09:53:45 -0800
Message-ID: <F001.0057367D.20030326095345@fatcity.com>

In one of our test, we say lots of waits on "global cache cr request" ... I haven't been able to find much except that in certain cases setting "_fairness_threashold" can be set to 1, default is 4.

In our test db, this (setting the value to 1) seems to help, but I don't know the downside of setting this parameter to a value of 1. Does anyone know some more details, advantages, disadvantages ...

BTW how do you try to tune a process, used by multiple users on both nodes
(on RAC) simultaneously, working on same set of data. I believe this is
major cause of the "global cache cr requests", but business logic requires the processing and we are running shot on ideas to minimize the global cache waits.

Any ideas are greatly appreciated.
Raj

---

Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  INET: Rajendra.Jamadagni_at_espn.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).



text/plain attachment: ESPN_Disclaimer.txt

Received on Wed Mar 26 2003 - 11:53:45 CST