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 !!
********************************************************************This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*********************************************************************2
