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.