Page 1 of 1
Ora-04031 error occur,how to resolve.
Posted: Thu 12 May 2005 04:47
by huaya1127
My System occur Ora_04031 error when too many users use it.But when I Use Bde Components before,not see this error ever.How to resolve it.
Error Detail :
ORA-04031: unable to allocate 8192 bytes of shared memory
("shared pool"
Posted: Thu 12 May 2005 11:27
by Alex
The cause of your problem could be any server side routine (PL/SQL routines, huge SQL queries, big amount of cached SQLs), lost connections or something else, it's hard to determine the exact reason. I can suggest You to increase the amount of available shared memory by increasing the value of the INIT.ORA (server configuration file) parameters "shared_pool_size" and "shared_pool_reserved_size". The placement of this file usually is "YourOracleDir\admin\YourOracleSreverServiceName\pfile\INIT.ORA".
P.S. If it is possible pls. send us complete sample that demonstrate your problem and include script to
create server objects.