Here is the problem. Whoever owns the statspack package doesn't own the tables. The PERFSTAT user must own both the package AND the tables.
To verify, run:
Code:select owner, object_name, object_type from dba_objects where object_name like 'STATS%' order by owner, object_name




Reply With Quote