| error when running statspak [message #287984] |
Fri, 14 December 2007 04:12  |
oraclestew
Messages: 13
Registered: December 2007
Location: Warrington, UK
|
Junior Member |
|
|
Hi,
I am trying to run statspak to look at performance of a report at a new job, but when i exec statspak.snap i get the error below.
SQL> exec perfstat.statspak.snap;
BEGIN perfstat.statspak.snap; END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'PERFSTAT.STATSPAK' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
I have looked at the statspak objects, and get the following results.
SQL> select owner
2 , object_type
3 from all_objects
4 where object_name = 'STATSPACK'
5 ;
OWNER OBJECT_TYPE
------------------------------ -------------------
PUBLIC SYNONYM
PERFSTAT PACKAGE
PERFSTAT PACKAGE BODY
Any idea why i'm getting this error and how i can get statspak to run.
Regards
Stew
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
