Home » RDBMS Server » Server Administration » error when running statspak (Oracle 9.2.0.8)
error when running statspak [message #287984] Fri, 14 December 2007 04:12 Go to next message
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
Re: error when running statspak [message #287985 is a reply to message #287984] Fri, 14 December 2007 04:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

exec perfstat.statspak.snap;

Check each letter, seems one is missing.

Regards
Michel
Re: error when running statspak [message #288115 is a reply to message #287985] Fri, 14 December 2007 22:43 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Good eyes micheal Smile
Previous Topic: implication of alter database begin backup
Next Topic: Bubble Fragmentation
Goto Forum:
  


Current Time: Mon Dec 05 09:10:26 CST 2016

Total time taken to generate the page: 0.12086 seconds