Skip to Content
avatar image
Former Member

Oracle 11g - memory issue.

hi,

Recently we have upgraded to oracle 11.2.0.1 from 10.2.0.4. Below memory issues shows up and system crashes.

We included parameter MEMORYIMM_MODE_WITHOUT_AUTOSGA=FALSE in init file. Despite this happens.

ORA-04031: unable to allocate 264 bytes of shared memory ("shared pool","unknown object","CCUR^4e9657a","kglob")

Fri May 20 18:43:45 2011

Sweep [inc][64733]: completed

Sweep [inc][64732]: completed

We increased db_cache and shared_pool memory, does not help.

Would appreciate any feedback on this.

Thanks,

RajS

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    May 22, 2011 at 03:58 PM

    Did you apply all the required patches for oracle 11.2.0.1?

    There is a SAP note with a list of these patches.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 23, 2011 at 07:41 AM

    Hi Raj,

    Refer the Notes 1472386 and 1181978

    Regards,

    Ram

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 24, 2011 at 03:48 AM

    Better you should have updated from 10.2.0.2 to 11.2.0.2

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 25, 2011 at 07:41 PM

    Hi Raj

    with experience I noticed these memory issues (ORA-0403 ) issues with 11.2.0.1

    say some bugs, which aren't easy to fix.

    Better upgrade to 11.2.0.2.

    May be not the proper answer to your question Just a tip.

    BR

    Venkat

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      This was due to Automated Memory Mgmt.. I disabled the parameter. Now its okay.

      Thanks to all for the response.

      Thanks,

      rajS