Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Installing statspack on oracle 8.1.6

Status
Not open for further replies.

rk0000

Technical User
Mar 15, 2002
33
IN
We have oracle 8.1.6 installed on IBM AIX 4.3.
I am installing Statspack on oracle. I connect as "sys" and execute the script from rdbms/admin/statscre.sql
I got the following error at the end. how to solve this?

Creating Package Body STATSPACK...

Warning: Package Body created with compilation errors.

Errors for PACKAGE BODY STATSPACK:

LINE/COL ERROR
-------- -----------------------------------------------------------------
752/7 PL/SQL: SQL Statement ignored
752/14 PLS-00320: the declaration of the type of this expression is
incomplete or malformed

753/14 PLS-00201: identifier 'SYS.V$SESSION' must be declared
789/10 PL/SQL: SQL Statement ignored
1061/6 PL/SQL: SQL Statement ignored
1077/13 PLS-00201: identifier 'SYS.V$SESSION' must be declared

NOTE:
STATSPACK complete. Please check statspack.lis for any errors.

not spooling currently
SQL> desc SYS.V$SESSION
ERROR:
ORA-04043: object SYS.V$SESSION does not exist

thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top