-
Its found under $ORACLE_HOME/rdbms/admin/spdoc.txt
Sam
Thanx
Sam
Life is a journey, not a destination!
-
Sam,
Thanks for your help and now I am having problem to run STACKSPACK.SNAP
any recomendations ???
-
Thanx
Sam
Life is a journey, not a destination!
-
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 ???
-
-
so I have to run spcpkg.sql instead ???
-
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.
Jeff Hunter
-
What is statspack? When do we use it?
-
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
Thanx
Sam
Life is a journey, not a destination!
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|