2354832 - Oracle Dictionary/System Statistics hanging

Symptom

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.

Environment

Oracle RDBMS as of 11g

Product

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

Keywords

oracle 11.2.0.2 11.2.0.3 11.2.0.4 12.1.0.2 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 for Me (Login required).

Search for additional results

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