update: Q: statspack install

I ran a desc against all of the tables that should have been created during the install. There are a few of them missing. Anyone have any idea why? Also, anyone know a way I can add them?

ORA-04043: object stats$buffer_pool does not exist 
ORA-04043: object stats$idx_stats does not exist 
ORA-04043: object stats$iostat does not exist 
ORA-04043: object stats$sgastat_summary does not exist 
ORA-04043: object stats$tab_stats does not exist 
ORA-04043: object stats$vmstat does not exist 

Should I unistall and reinstall again? I got the statspack.tar file off of metalink so I thought it would work OK...

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:31:25 CST