SAP Knowledge Base Article - Preview

2278110 - BR0301E SQL error -4021 at location stats_tab_collect-69

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

SAP ERP 6.0

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.