1748270 Members
3760 Online
108760 Solutions
New Discussion юеВ

statspack

 
SOLVED
Go to solution
dngaya
Advisor

statspack

hello with all, I have a base oracle 8.1.7,
I installed statspack. well when I connect myself on the database with using it perfstat
and that I execute the following order for to start the capture of image: execute statpack.snap;
all occurs well but when I execute the order suivante:@spreport,
I have the id beginning but it not the ending id.
how to make there to get the id of end?.
thank you for your assistance.



2 REPLIES 2
Jean-Luc Oudart
Honored Contributor
Solution

Re: statspack

Statspack works on difference.
You need (at least) 2 snapshot to be in a position to generate a report.
e.g.
10am run 1st snapshot
11am run 2nd snapshot
Then run spreport

regards,
Jean-Luc
fiat lux
Yogeeraj_1
Honored Contributor

Re: statspack

Hi,

Above all you should enable timed_statistics!

Then run your statspack snaps on a 15 minutes interval preferably. (at high load)

This would be more meaningful.

hope this helps too!

if you need any further help, do let us know.

regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)