Originally posted by gnagesh I keep _db_handles_cached=0
Is there any harm? Please correct me.
I think yes, because with _db_handles_cached =0 you are actually setting off the buffer handles, i.e, you have no handles cached per process. Thus your performance my suffer.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g
email: ocp_9i@yahoo.com
I think yes, because with _db_handles_cached =0 you are actually setting off the buffer handles, i.e, you have no handles cached per process. Thus your performance my suffer.
[/B]
Very good input. So you mean to say that "event="10262 trace name context forever, level 10000" solves the memory leak problem. Why I am asking this, I had this problem, and I set both the parameters. It is Ok now. Since _db_handles_cached=0 hurts the performance, no meaning to set this parameter. Some times exploring too many documents also creates problems? am I correct?
Yes, you are right. 10000 means that you will not get error messages for leaks less than 10000 bytes. They are usually at most 5000. But I was told by Oracle that (was it) 0 would neglect all leaks.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g
email: ocp_9i@yahoo.com
Bookmarks