1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

ORA-04031: unable to allocate 760 bytes of shared memory ("shared pool","unknown obje

Discussion in 'General' started by jesthr@gmail.com, Jul 1, 2014.

  1. jesthr@gmail.com

    jesthr@gmail.com Active Member

    Messages:
    23
    Likes Received:
    0
    Trophy Points:
    80
    ORA-04031: unable to allocate 760 bytes of shared memory ("shared pool","unknown object","KKSSP^434","kglss")

    I have Oracle Release 11.2.0.3.0
    $ machinfo
    CPU info:
    4 Intel(R) Itanium 2 9100 series processors (1.59 GHz, 24 MB)
    8 logical processors (2 per socket)

    Memory: 32737 MB (31.97 GB)
    SQL> select * from v$sgainfo;
    NAME BYTES RES
    -------------------------------- ---------- ---
    Fixed SGA Size 2189720 No
    Redo Buffers 53223424 No
    Buffer Cache Size 5167382528 Yes
    Shared Pool Size 1.2080E+10 Yes
    Large Pool Size 67108864 Yes
    Java Pool Size 134217728 Yes
    Streams Pool Size 67108864 Yes
    Shared IO Pool Size 0 Yes
    Granule Size 67108864 No
    Maximum SGA Size 1.7571E+10 No
    Startup overhead in Shared Pool 159316648 No
    Free SGA Memory Available 0
    SQL>
    SQL> SELECT POOL,round(bytes/1024/1024,0) FREE_MB FROM v$sgastat WHERE name LIKE '%free memory%';
    POOL FREE_MB
    ------------ ----------
    shared pool 5179
    large pool 48
    java pool 106
    streams pool 61
    SQL> show parameter sga_max_size; sga_target;
    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    sga_max_size big integer 16832M

    How can I fix the ORA-04031: Unable to allocate 760 bytes of shared memory

    Regards!

    Hine Rosulnik
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Re: ORA-04031: unable to allocate 760 bytes of shared memory ("shared pool","unknown

    Get the sgastatx.sql script:


    http://blog.tanelpoder.com/files/scripts/sgastatx.sql


    Then run it against your database to see how many subpools you have in the SGA, if you have a subpool 0 (available free memory) and how much free memory is in each subpool. You should read here to understand what the script does and how to possibly address your situation:


    http://dfitzjarrell.wordpress.com/2010/12/11/if-memory-serves/