Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-04063: view "SYS.DBA_HIST_SQLSTAT" has errors

Manohar Naidu PenderyDec 7 2016 — edited Dec 9 2016

i compiled a package is executed and showing the status is valid

and for package body it is throwing errors

SQL> show error

Errors for PACKAGE BODY DBMS_SQLTUNE:

LINE/COL ERROR

-------- -----------------------------------------------------------------

19279/7 PL/SQL: SQL Statement ignored

19281/14 PL/SQL: ORA-04063: view "SYS.DBA_HIST_SQLSTAT" has errors

19996/5 PL/SQL: SQL Statement ignored

20106/20 PL/SQL: ORA-04063: view "SYS.DBA_HIST_SQLSTAT" has errors

20282/5 PL/SQL: SQL Statement ignored

20646/22 PL/SQL: ORA-04063: view "SYS.DBA_HIST_SQLSTAT" has errors

22738/7 PL/SQL: SQL Statement ignored

22767/22 PL/SQL: ORA-04063: view "SYS.DBA_HIST_SQLSTAT" has errors

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 6 2017

Added on Dec 7 2016

#general-database-discussions

10 comments

1,151 views