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