You are gathering new Oracle optimizer statistics by using BR*Tools and encounter a similar issue as shown below:
BR0280I BRCONNECT time stamp: 2016-02-10 01.18.22
BR0301E SQL error -4021 at location stats_tab_collect-69, SQL statement:
'BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPSR3"', TABNAME => '"<TABLE>"', ESTIMATE_PERCENT => 10, METHOD_OPT => 'FOR ALL COLUMNS SIZE 1', DEGREE => NULL, CASCADE => TRUE, NO_INVALIDATE => FALSE); END;'
ORA-04021: timeout occurred while waiting to lock object
ORA-06512: at "SYS.DBMS_STATS", line 24301
ORA-06512: at "SYS.DBMS_STATS", line 24352
ORA-06512: at line 1
BR0886E Collecting statistics failed for table SAPSR3.TABLE
- SAP Netweaver
- Oracle database
KBA , BC-DB-ORA , Oracle , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.