Q: statspack install

From: Vince Laurent <vlaurent_at_NOSPAM.networkusa.net>
Date: Thu, 19 Dec 2002 16:14:57 -0600
Message-ID: <3ug40v4hon91hce61pjgsvlcohl15mljep@4ax.com>

I am trying to get statspack up and running on our server (Oracle 8.1.7.3 on HP-UX 11.0). I ran the statscre.sql and checked all the .lis files for errors - there were none. Then I tried testing the application (as per 'Oracle High-Performance Tuning with STATSPACK') by running 3 commands... this is what I get:

SQL> connect / as sysdba;
Connected.
SQL> execute statspack.snap
PL/SQL procedure successfully completed. SQL> execute statspack.snap
PL/SQL procedure successfully completed. SQL> @?/rdbms/admin/statsrep

   DB Id DB Name Inst Num Instance ----------- ---------- -------- ----------

 1487533990 PSS               1 PSS
     , stats$sgaxs sga
       *

ERROR at line 13:
ORA-00942: table or view does not exist

So what happened? There were no errors during the install? I even tried it again spacing the executes out a bit... still no luck.

Thanks!
Vince Received on Thu Dec 19 2002 - 16:14:57 CST