ORA-04031:

ORA-04031:

Postby Dexon » Wed 26 Dec 2007 21:20

I have a problem with the use of oradirect initially showed a message of processes exceeded, it modified the number of processes and now shows me a message
ORA - 04031: unable to allocate 35336 bytes of shared memory ( "shared pool "(...) I do not know if I commit any mistake using the connections, all are opened and closed by dropping the result, I have changed the shared memory and pool increased to 1000 connections and processes in 1000, though my application just opens 12 threads and I even introduced the same mistake, any suggestion is a windows application.
Dexon
 
Posts: 4
Joined: Thu 20 Dec 2007 14:49

Postby Alexey.mdr » Thu 27 Dec 2007 10:43

This issue is tracked with Oracle bug 3150705.
The cause of the first error is obvious: the memory allocated to the shared pool is insufficient for answering the user request. There are different ways to solve the problem, depending on the settings of the database and your connection string. I found this link quite helpful:
http://www.oracle.com/technology/pub/ar ... 0gdba.html
Additionally you may read Oracle9i Database Server Patch Set Notes
Find “ORA – 04031” and read the corresponding paragraph here:
http://www.oracle.com/technology/suppor ... l#BABGHJAJ
Alexey.mdr
 
Posts: 729
Joined: Thu 13 Dec 2007 10:24


Return to dotConnect for Oracle