Login as the perfstat user and execute spctab.sql to create the tables.
Sorry, please don't be upset with the rookie, I am getting there. After I run the SPCTAB.SQL, tables were created and the package body is compiled and valid.
What do I do next ??? I did read the doc but it miss too much info, none of the thing you mention are included on the doc. Like SPCPKG.sql and SPCTAB.sql, I didn't know we have to run them seperate. Any way, the doc is not good.
Could you please tell me what I need to do next to get the snapshot of the database???
To compile the package body, login as perfstat and:
ALTER PACKAGE STATSPACK COMPILE BODY;
If there are any errors, post the errors.
SHOW ERRORS PACKAGE BODY STATSPACK
Otherwise, post the results of:
select owner, object_name, object_type
where object_name like 'STATS%'
order by owner, object_name
Every thing is good now, what I need to do next ???
Run the STACKPACK.SNAP ???? HOW ???
Now, all you have to do is take a snapshot of the database:
After about 15 minutes or so of activity, take another snapshot. You can then use spreport.sql to get a generalized report between the two time periods...
Thanks so much for your help and kindness
One final thing Jeff
Where can I see the report or where the report will be stored at ???
were the data stored in the tables owned by PERFSTAT schema ??? If so , I have to go to those tables and get the info about the database ????
THanks again and Have a great weekend
[Edited by ashley75 on 03-15-2002 at 01:35 PM]
The report will go to a file of your choosing. The data stays in the database and you can report on it at any time.
Click Here to Expand Forum to Full Width