Oracle 11g - memory issue.

[former_member199694]

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

[former_member213250]

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

[former_member199694]

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

Thanks,

rajS

[former_member199694]

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

Thanks to all for the response.

Thanks,

rajS

[Former Member]

Better you should have updated from 10.2.0.2 to 11.2.0.2

[Former Member]

Hi Raj,

Refer the Notes 1472386 and 1181978

Regards,

Ram

[Former Member]

Did you apply all the required patches for oracle 11.2.0.1?

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