error in UpdateStats job

[Former Member]

Dear All,

I have got this error in UpdateStats job.

BR0883I Table selected to collect statistics after check: SAPPRD.VBAP (102478/153942)
BR0280I BRCONNECT time stamp: 2009-02-04 01.21.11
BR0881I Collecting statistics for table SAPPRD.VBAP with method/sample E/P30 ...
BR0280I BRCONNECT time stamp: 2009-02-04 01.21.26
BR0301E SQL error -4031 at location stats_tab_collect-16
ORA-04031: unable to allocate 4160 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","state objects")
BR0886E Checking/collecting statistics failed for table SAPPRD.VBAP
BR0280I BRCONNECT time stamp: 2009-02-04 01.21.28

Plz suggest what i have to do. Is it a serious problem.

Ankit

[former_member227600 · Accepted solution]

Hi,

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

These problem seems related to shared memory. Please refer to Snote 690241. Click on below link ,you will get the solution of your problem.

[https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=690241]

[Former Member · Accepted solution]

Thanks Karan,

It is Ok in my system.

I have Oracle 9.2.0.4.0 & SHARED_POOL_SIZE= 771751936.

plz suggest, what should i do?

Ankit

[Former Member · Accepted solution]

Hai,

You have to follow the steps as mentioned in the SAP Note 690241.

1. Reduce the memory consumption or

2. Increase the size of the shared pool.

Regards,

Yoganand.V

[Former Member · Accepted solution]

Dear Yoganand,

How can i check memory consumption ?

How can i reduce memory consumption ?

Ankit