My Oracle Support Banner

AWR Snapshots Periodically Not Generating Automatically. MMON Stuck on 'external table read'. (Doc ID 2729835.1)

Last updated on AUGUST 06, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 19.1.0.0.0 [Release 12.1 to 19]
Information in this document applies to any platform.

Symptoms

AWR snapshots are not generated automatically on a regular schedule.  This problem occurs intermittently.

Generating an AWR snapshot manually succeeds, however.

The MMON background process is in charge of AWR snapshot generation.  Examination of a hanganalyze trace, during the time of incident, shows that MMON is trying to execute PL/SQL function, DBMS_QOPATCH.GET_OPATCH_LSINVENTORY, but is stuck on an extremely long, external-table read.  The function, skudmir(), appears within the short stack.

Changes

 N/A

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.