| Init.ora parameter [message #60560] |
Sun, 15 February 2004 23:57  |
Alpesh Kothari
Messages: 7
Registered: April 2002
|
Junior Member |
|
|
Hi All,
My company, we r using oracle 8.1.7.0 and in this version one bug called memory leak problem. so I have set parameter _db_handles_cached = 0 in the init.ora file.
So can anybody give me a hidden implication of this parameter
Thanks
Alpesh Kothari
|
|
|
|
| Re: Init.ora parameter [message #60561 is a reply to message #60560] |
Mon, 16 February 2004 01:47  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
always set the hiddent parameters with the advise of OSS.
specifically _db_handles_cached is known for peformance bugs.
To my known knowledge _db_handles_cached = 0 set to avoid an ora-04031( which is a generic bug). And this is only a workaround solution.
the right solution would be to apply a higher patchset of atleast 8.1.7.4.
If remember correctly, the bug is fixed in 8.1.7.2 itself.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
