We are running Oracle Applications 11.0.3 on 8.0.6. The following is the error from the log for a request submitted. We know that our Shared pool size is fine. Right now 95% is being used.
ERROR at line 1:
ORA-04031: unable to allocate 12 bytes of shared memory ("shared pool","SELECT "
REQUISITION_NUMBER",...","sql area","logdef :
ORA-02063: preceding line from EPROD1_LINK
ORA-06512: at line 104
ORA-06512: at line 188
ORA-06512: at line 2048
SQL> select * from v$sga;
Fixed Size 48656
Variable Size 990380032
Database Buffers 819200000
Redo Buffers 12599296
What could we do? Thanks.
02-07-2001, 03:43 AM
According to the Oracle error message more shared memory is needed than was allocated in shared pool:
The documeted error text states:
If the shared pool is out of memory, either use DBMS_SHARED_POOL package to pin large packages, reduce your use of shared memory or increase the amount of shared memory by increasing the value of the initialisation parameters SHARED_POOL_RESERVED_SIZE and SHARED_POOL_SIZE.
If the large pool is out of memory, increase the initialisation parameter LARGE_POOL_SIZE.
02-07-2001, 03:51 AM
I'm into oracle application for the last 2.5 years. what request are you trying to run? requisition import? is this comeing from the "view log" of the request?