STATSPACK CONFIGURATION

[marist89]

Login as the perfstat user and execute spctab.sql to create the tables.

[ashley75]

jEFF,

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???

[marist89]

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
from dba_objects
where object_name like 'STATS%'
order by owner, object_name

[ashley75]

Jeff,

Every thing is good now, what I need to do next ???

Run the STACKPACK.SNAP ???? HOW ???

Please advise

[marist89]

Now, all you have to do is take a snapshot of the database:
exec statspack.snap;


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...

[ashley75]

Thanks so much for your help and kindness

[ashley75]

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]

[marist89]

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.