Posted by
ErmanArslansOracleBlog on
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/R12-tp3336p3370.html
Hi lawrence,
As I explained my blog post; we can conclude that, cache give us benefits when there are few number of concurrent processes available. For the environments where we have several concurrent processes like 10 standard manager process or so, a general recommended setting can be "1" for it.
Please read that post carafully, and you will get the idea.
There is a formula there, use it to calculate the sleep time.
Cache size should be set to 1.
About caching -> read this to understand :
process 1 caches 30 requests (1-30) and start executing request 1
process 2 caches 30 requests (2-31) and start executing request 2, as request 1 is already run by Process 1
process 3 caches 30 requests (3-32) and start executing request 3, as request 2 is already run by Process 1
....
.....
process 30 caches 30 requests (30-59) and start executing request 3, as request 29 is already run by Process 1
...
suppose now process 1 finishes the executing of request 1;
process 1 checks request 2 and see it is locked, as it is executed by another process.
process 1 checks request 3 and see it is locked, as it is executed by another process.
process 1 checks request 4 and see it is locked, as it is executed by another process.
process 1 checks request 5 and see it is locked, as it is executed by another process.
....
process 1 checks request 30 (which is the last request in its cache) and see it is locked, as it is executed by another process.
What process 1 does than?
it caches again. It caches another 30 request. """""So where it the benefit of caching?"""
http://ermanarslan.blogspot.com.tr/2016/04/ebs-r12-concurrent-manager-facts-cache.html