topic Re: statspack in Operating System - HP-UX

statspack

dngaya — Fri, 19 Dec 2003 05:46:47 GMT

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.

Re: statspack

Jean-Luc Oudart — Fri, 19 Dec 2003 05:51:52 GMT

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

Re: statspack

Yogeeraj_1 — Fri, 19 Dec 2003 11:52:26 GMT

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