Oracle shared memory error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Oracle shared memory error

  1. #1
    Join Date
    Jan 2003
    Posts
    38

    Oracle shared memory error

    Hello all,

    I am running oracle 817 on RH Linux 7.2 and running iPlanet webserver for applications. I keep getting the following errors around once a week or even at a greater frequency

    ORA-04031: unable to allocate 2560 bytes of shared memory ("large poo
    l","unknown object","session heap","First curdef allocation")

    I have tried increasing the large pool size in the init.ora file, increased the max cursors as well but still the error persists. I also get thsi errors on RH 6.2 . I have tried increasing the shmmax parameter as well but to no success :(

    Is there a way to determine how much size should be put for large pool and other parameters ? or is this related to any system patches for linux ? because on solaris everything works fine.. I tried to search on google but most of the results show increase in pool size which I have already tried ...

    Any help is highly appreciated.

    Thanks
    K

  2. #2
    Join Date
    Nov 2000
    Posts
    101
    Hi,
    Increase shared_pool_size and shared_pool_reserved_size in init.ora.


    bye
    gandhi

  3. #3
    Join Date
    Feb 2003
    Posts
    40
    Hi,
    Lots of parsing causes fragmentation on sharedpool which has to be avoided.If parsing is more,adding shared pool size, might worsen the situation as it has to scan more memory than before for similar SQL statements.

    Frequently used packages could be KEPT in the shared pool using dbms_shared_pool.keep procedure.

    For more information can check
    Docid 62143.1 in Metalink.
    K.Chithra
    Oracle DBA

  4. #4
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Chithra,

    Code:
    ORA-04031: unable to allocate 2560 bytes of shared memory ("large poo
    l","unknown object","session heap","First curdef allocation")

    It is large pool.. not shared pool.
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  5. #5
    Join Date
    Jan 2003
    Posts
    38
    Thanks everyone for the prompt responses

    but as i had already mentioned in my mail, i hv tried increasing both shared_pool_size & large_pool_size but it did not help.. I have read on some of the pages that came up on a google search that there is some bug in the version 8.1.7.0.0 , is it so ? is so is anyone aware of some patch available for this ?

    Thanks
    K

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