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

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.