Skip to Content
0
Former Member
Feb 04, 2009 at 06:30 AM

error in UpdateStats job

57 Views

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