Re: update: Q: statspack install

To take snapshots using statspack, you are supposed to login as the user PERFSTAT (default password=PERFSTAT).

The statistics get written into a bunch of tables owned by the user PERFSTAT (that's what the spcreate.sql script does for you: creates the user PERFSTAT and then creates a bunch of tables in his schema).

Lord knows what the STATSCRE.SQL script is. It doesn't exist on my 8i installation, that's for sure.

Regards
HJR "Vince Laurent" <vlaurent_at_NOSPAM.networkusa.net> wrote in message news:a2i40vss2u6bgaqtg07d1ca3g07b1shp1v_at_4ax.com...
> 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:44:29 CST