Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Q: statspack install
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 *
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