STATSPACK CONFIGURATION

[sambavan]

Its found under $ORACLE_HOME/rdbms/admin/spdoc.txt

Sam

[ashley75]

Sam,

Thanks for your help and now I am having problem to run STACKSPACK.SNAP


any recomendations ???

[sambavan]

What is the problem?

Sam

[ashley75]

Sam,

sorry , I kept bugging you on this since this is my first time.

here is the error message

SQL> execute statspack.snap
BEGIN statspack.snap; END;

*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'STATSPACK.SNAP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

What I don't understand is STATSPACK.SNAP is not existed in
%ORACLE_HOME%\rdbms\admin\

so where is this procedures located ???

[marist89]

its in spcpkg.sql

[ashley75]

so I have to run spcpkg.sql instead ???

[marist89]

spcpkg will create the statspack package. After the package is created, you can call statspack.snap.

There is a file called spdoc.txt that outlines the procedure to create the statspack repository and associated packages.

[oraka6]

What is statspack? When do we use it?

[sambavan]

Stats pack is a performance tuning tool. It is used when you want to tune your database. So you would run the statspack on a regular interval and gather statistics on your database and then you would use it's report to find out the cholk points and bottle necks and start tuning in one by one.

Sam

[ashley75]

Jeff,

Thanks for your reply,

I did run the spcpkg package and it create statspack package,when I run statspack.snap I still have problem and I am sorry to bother you again but I tried to get this work.

when I tried to call statspack.snap I still have the same problem

Please help