We have added search box. Key in SAP issue keyword to search
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

[sap-basis] Checking/collecting statistics failed for table EBAN

Posted by Admin at
Share this post:
Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

Posted by vkjpbasis (SAP BASIS Consultant)
on Oct 10 at 9:27 AM
Hi,

In our R3 production sever in db13 Check and update optimizer statistics scheduled daily , but last 3 days it has got failed due to the below mentioned reason,

BR0301E SQL error -1555 at location stats_tab_collect-16
ORA-01555: snapshot too old: rollback segment number 16 with name "_SYSSMU16$" too small
BR0886E Checking/collecting statistics failed for table SAPRP1.EBAN

we have extended the tablespace PSAPUNDO then also same problem , kindly suggest to over come the issue

Regards
JP
__.____._
Copyright © 2010 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Related Content
Most Popular White Papers

In the Spotlight
Assess and overcome obstacles to realize the benefits of cloud. Join the IBM virtual discussion Oct. 14 @ 2 pm ET
_.____.__

0 comments:

Post a Comment

T r a n s l a t e to your language