SAP Knowledge Base Article - Preview

2354832 - Oracle Dictionary/System Statistics hanging


You are trying to implement note 838725 to run the Oracle dictionary and/or System statistics and it is taking too long.

The issue may happen at any point in time, but it is most commonly discovered after an upgrade of the database since this is one of the post steps.



  • Oracle RDBMS as of 11g


SAP NetWeaver 2004 ; SAP NetWeaver 7.0 ; SAP NetWeaver 7.1 ; SAP NetWeaver 7.2 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 2 for SAP NetWeaver 7.0 ; SAP enhancement package 3 for SAP NetWeaver 7.0


oracle 11gR2 12c 12cR1 internal sysstats gather performance bad freeze freezing frozen standstill hung automatic diagnostic workload repository v$ x$ post completing not , KBA , BC-DB-ORA , Oracle , SV-PERF-DB-ORA , Oracle related performance issues , 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.