DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: Memory Leak Problem

  1. #11
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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

  2. #12
    Join Date
    Aug 2000
    Location
    Singapore
    Posts
    323
    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

  3. #13
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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
  •  


Click Here to Expand Forum to Full Width