| ora-04031=unable to allocate 664bytes of shared memory(shard pool.) [message #65344] |
Thu, 12 August 2004 06:28  |
James
Messages: 120
Registered: June 2000
|
Senior Member |
|
|
Hello
I have installed oracle9i server under a sun solaris 8
and everything is ok (i can connect to the database with sqlplus qnd i create a new user)
but when i restart my system, i restart my database with the dbstart command then i have those errors:
ora-00604=error occured at recursive sql level
ora-04031=unable to allocate 664bytes of shared memory(shard pool........)
can you help me please because i am newbie
thanks
|
|
|
|
| Re: ora-04031=unable to allocate 664bytes of shared memory(shard pool.) [message #65350 is a reply to message #65344] |
Sun, 15 August 2004 22:48  |
Adrian Billington
Messages: 139
Registered: December 2002
|
Senior Member |
|
|
It means that Oracle hasn't enough contiguous memory in the shared pool to parse your query and store it with its execution plan. This is most commonly a symptom of a lack of bind variables, where the shared pool is flooded with similar queries where a literal value has been "hard-coded" to the where clause. Search asktom.oracle.com for "using bind variables" for some guidance.
Regards
Adrian
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
