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

Thread: memory issue 10.2.0.4

  1. #1
    Join Date
    Aug 2008
    Posts
    123

    memory issue 10.2.0.4

    Oracle 10.2.0.4 (user or developer getting error for not able to allocate ora 04031

    I am trying to do alter system shared_pool_size = 250M but it says

    ORA-02097: parameter cannot be modified because specified value is invalid
    ORA-04033: Insufficient memory to grow pool

    I checked the show parameter sga_max_size = 376 M

    the set upin the init.ora for pools:

    ###########################################
    # Pools
    ###########################################
    java_pool_size=157286400
    large_pool_size=33554432
    shared_pool_size=157286400

    From show parameter sga;

    NAME TYPE VALUE
    ----------- lock_sga boolean FALSE
    pre_page_sga boolean FALSE
    sga_max_size big integer 376M
    sga_target big integer 0

    SQL> select * from V_$SGA_TARGET_ADVICE;

    no rows selected

    OS Linux.
    this was the message in alert.log;
    ORA-04031: unable to allocate 88 bytes of shared memory ("shared pool","select /*+ rule */ bucket_cn...","sql area","opn: qkexrInitOpn")



    what is the problem to increase the shared pool>> Please help quick

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    You can see other pools consuming memory in the SGA, so the obvious answer is to reduce how much is allocated for those other items, or make the SGA larger.
    Last edited by stecal; 06-09-2011 at 04:02 PM.

  3. #3
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Most people don't need 150MB of java_pool_size.
    You can probably shrink that to 48MB.
    You should then be able to grow the shared_pool_size.

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