My Oracle Support Banner

DBMS_STATS.GATHER_SYSTEM_STATS fails with PLS-00302: component 'ATHER_SYSTEM_STATS' must be declared (Doc ID 2524935.1)

Last updated on NOVEMBER 06, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 18.3.0.0.0 and later
Information in this document applies to any platform.

Symptoms

EXEC DBMS_STATS.GATHER_SYSTEM_STATS fails with the below Error Message ie:

Errors in file /db/oradata/diag/rdbms/<sid>/<sid>/trace/<sid>_j000_79096.trc:
ORA-12012: error on auto execute of job "SYS"."ST$204"
ORA-06550: line 1, column 768:
PLS-00302: component 'ATHER_SYSTEM_STATS' must be declared
ORA-06550: line 1, column 757:
PL/SQL: Statement ignored

Changes

 Database Upgrade to 18.3.0.0.0 or Higher

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.