Help with Error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Help with Error

  1. #1
    Join Date
    Jan 2001
    Posts
    138
    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 :
    kkobrfio")
    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;

    NAME VALUE
    -------------------- ----------
    Fixed Size 48656
    Variable Size 990380032
    Database Buffers 819200000
    Redo Buffers 12599296

    What could we do? Thanks.


  2. #2
    Join Date
    Feb 2000
    Posts
    175
    Hi,

    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.

    Regards

    Moff.

  3. #3
    Join Date
    Jul 2000
    Posts
    243
    hi pcotten

    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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width