| shared pool error [message #57517] |
Fri, 20 June 2003 02:22  |
ramesh
Messages: 123
Registered: August 2000
|
Senior Member |
|
|
hi all,
i am facing some problem with shared pool. When performing operations, i am getting the error "unable to allocate 4200 bytes of shared pool memory(shared pool,TRIGGERS,SGA Heap,..).But from the sgastat, there is plenty of memory available. I even flushed the shared pool, but the problem was not solved. Can anybody, give me a solution,the reason behind this one. What r the things to be taken care of in this situation. All the replies are most welcome.
|
|
|
|
| Re: shared pool error [message #57520 is a reply to message #57517] |
Fri, 20 June 2003 04:58  |
Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland
|
Senior Member |
|
|
Hi ramesh,
seems like you're using 8.1.7.0 ??? We are planning to migrate to 8.1.7.4 because that memory heap is a known bug in lower than 8.1.7.2
rgds
Uwe
|
|
|
|
| Re: shared pool error [message #57525 is a reply to message #57517] |
Fri, 20 June 2003 05:53 |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
as Uwe has said,
applying a patchset of atleast 8.1.7.2 or better 8.1.7.4 will solve this bug.
there is something_else_also you can do.
set the following parameter in your inti< sid >.ora
and bounce the database.
_db_handles_cached = 0
NOTE: We have tried this in some of our legacy systems and IT worked in many cases.
I am personally intrested in exploring more about this parameter. In fact im tryin to reproduce the error, but in vain. if this works out for u, can u please post ur Initsid.ora?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
