Memory Leak Problem
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: Memory Leak Problem

Hybrid View

  1. #1
    Join Date
    May 2001
    Location
    London
    Posts
    149
    HI,

    We are getting memory leak problem while running some online processes.
    Platform :Oracle 8.1.7.2/ Solaris.
    Somebody told me that it is bug of Oracle 8.1.7.
    Is there any solution for this.

    Thanks in advance

    Paresh

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    8.1.7.4
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    May 2001
    Location
    London
    Posts
    149
    Thanks Mariast for ur reply.

    That means I need to install patch on my server.
    Where will I get it? What is the procedure to install?


    Thanks

    Paresh

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    You get the patches from metalink. There is a readme that will outline the install...
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    May 2001
    Location
    London
    Posts
    149
    Thanks Jeff,

    I have one more question for u, that is we will get this memory leak problem for which oracle versions ?

    Cheers

    Paresh

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    I know you get it on 8.1.7.2, that's why I'm upgrading. I don't know about other versions...
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  7. #7
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by marist89
    I know you get it on 8.1.7.2, that's why I'm upgrading. I don't know about other versions...
    There are harmless memory leaks on 8.1.7.3 But Oracle suggested that I "fix" them with event="10262 trace name context forever, level 10000"
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  8. #8
    Join Date
    Aug 2000
    Location
    Singapore
    Posts
    323
    Originally posted by julian
    Originally posted by marist89
    I know you get it on 8.1.7.2, that's why I'm upgrading. I don't know about other versions...
    There are harmless memory leaks on 8.1.7.3 But Oracle suggested that I "fix" them with event="10262 trace name context forever, level 10000"
    I believe it is not enough, we need to set _db_handles_cached=0

    Right!

    Nagesh

  9. #9
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    For me it was enough.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  10. #10
    Join Date
    Aug 2000
    Location
    Singapore
    Posts
    323
    I keep _db_handles_cached=0

    Is there any harm? Please correct me.

    Nagesh

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