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.