-
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,12c
email: ocp_9i@yahoo.com
-
Originally posted by julian
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?
Thanks In Advance.
Nagesh
-
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,12c
email: ocp_9i@yahoo.com
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|