To compile the package body, login as perfstat and:
ALTER PACKAGE STATSPACK COMPILE BODY;
If there are any errors, post the errors.
SHOW ERRORS PACKAGE BODY STATSPACK
Otherwise, post the results of:
Code:select owner, object_name, object_type from dba_objects where object_name like 'STATS%' order by owner, object_name




Reply With Quote