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"
Ora-04031 error occur,how to resolve.
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.
P.S. If it is possible pls. send us complete sample that demonstrate your problem and include script to
create server objects.