Home » RDBMS Server » Performance Tuning » ora-04031=unable to allocate 664bytes of shared memory(shard pool.)
ora-04031=unable to allocate 664bytes of shared memory(shard pool.) [message #65344] Thu, 12 August 2004 06:28 Go to next message
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 Go to previous message
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
Previous Topic: Can PeopleToos 8.16 and 8.18 run at same time on same machine
Next Topic: Historical cost of 8i Tuning Pack licence
Goto Forum:
  


Current Time: Thu Mar 28 20:02:09 CDT 2024