SOLVED! Re: Q: statspack install

Apparently the 8.1.6 versions start with 'stats*.sql' while the 8.1.7 ones start with 'sp*.sql'. I uninstalled the 8.1.6 ones and reinstalled the 8.1.7 ones. All is happy.

for now!
Vince

On Thu, 19 Dec 2002 16:14:57 -0600, Vince Laurent <vlaurent_at_NOSPAM.networkusa.net> wrote:

>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.
Received on Thu Dec 19 2002 - 16:47:13 CST