My Oracle Support Banner

DBMS_SQLTUNE Invalid after patching (Doc ID 2712246.1)

Last updated on APRIL 12, 2021

Applies to:

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

Symptoms

PACKAGE BODY SYS.DBMS_SQLTUNE invalid after applying 19c RU patch

SELECT 'Object_Status' "CHECK_NAME",owner,object_name,object_id,object_type,status from dba_objects
where owner='SYS' and object_name = 'DBMS_SQLTUNE';


CHECK_NAME   OWNER    OBJECT_NAME        OBJECT_ID    OBJECT_TYPE         STATUS
------------------------------------------------------------------ ------------ -----------------
Object_Status   SYS         DBMS_SQLTUNE      8742             PACKAGE               VALID
Object_Status   SYS         DBMS_SQLTUNE    12111             PACKAGE BODY      INVALID

 

Changes

 

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


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