Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Statspack error : ORA-06564: object HTP_PERFSTAT.STATSPACK does not exist
Hi All
While trying to use statspack to generate snaps, got the following error.
$sqlplus perfstat/perfstat
SQL> execute statspack.snap
BEGIN statspack.snap; END;
*
ERROR at line 1:
ORA-06564: object HTP_PERFSTAT.STATSPACK does not exist ORA-06512: at "SYS.DBMS_UTILITY", line 114 ORA-06512: at "SYS.DBMS_SHARED_POOL", line 45 ORA-06512: at "SYS.DBMS_SHARED_POOL", line 53 ORA-06512: at "PERFSTAT.STATSPACK", line 2708 ORA-06512: at line 1
Please note that spcreate.sql did not throw any error. Object STATSPACK
is in valid state in 'PERFSTAT' schema but in invalid state for
'HTP_PERFSTAT' schema.
Could not compile the body, because of 1353/16 PL/SQL: ORA-00942: table
or view does not exist error.
Any idea why this package is not getting compiled? We are totally lost as the output file has not thrown any error. Do I have to explicitly grant privileges to HTP_PERFSTAT schema?
TIA
Vidya
![]() |
![]() |