Symptom
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:
'EXECUTE stmt_1d'
'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
Read more...
Environment
- SAP Netweaver
- Oracle database
Product
Keywords
ORA-04021, BR0886E , KBA , BC-DB-ORA , Oracle , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview