Oracle shared memory is getting full very frequently

[Former Member]

Hello,

We have recently upgraded the Oracle database from 10.2.0.4 to 10.2.0.5 and also upgraded the SAP kernel patch from 94 to 137 in BI production system, since then the oracle shared memory is getting full every day and in SAP system logs (sm21) we are getting the error as below,

ORA-04031: unable to allocate 4064 bytes of shared memory

("shared pool","unknown object","sga heap(2,0)","kglsim heap

We have restarted the SAP and DB twice since Monday to flush the oracle shared memory. We have found two SAP notes 1478228 and 1557321,but not sure if these are applicable in our scenario, The current value of parameter sga_max_size is 10 GB and shared_pool_size is 1.5 GB.

Please help to identify the cause of this issue and how this can be resolved.Can it be bug in Oracle release 10.2.0.5.

Kindly Suggest.

Shivam Mittal

[former_member213250]

Hello Shivam

Please check all the prerequistes mentioned by Vincent according to given SAP Notes, and also make sure that you have applied latest SBP on to your system.

Reference SAP Note: 1431752 --> Oracle 10.2.0: Patches/Patch Collections for 10.2.0.5

With my personal experience I have noticed many customer with

'ORA-04031: unable to allocate 4064 bytes of shared memory ' errors which are fixed after applying

latest SBP.

Also make sure that

SGA_MAX_SIZE

SHARED_POOL_SIZE

Values are set to decent enough size.

Please keep the system monitored afterwards.

Hope it helps

Regards

Venkat

[vincentlim826]

Hi,

- See SAP note 869006 on typical rootcause of ORA-04031

- Suggest you run a check on paramater with SAP note 1171650, and see SAP note 830576 for standard setting.

- Check also the posibility increasing shared_pool_size

Regards,

Vincent