I have installed STATSPACK

[lgargano]

I have instance and I need to get information about it ( CPU utilization, memory utilization and disk utilization) and I need to gather information about performance. I have installed STATSPACK (@spcreate), I have run two statistics about it (execute statspack.snap, and I have done the report (@spreport). I didn’t understand the result about the report. I would like to know what should I consider for get information for my objective.

[davey23uk]

all those metrics are better defined by using os tools, such as iostat, vmstat etc

[sunil_kandi]

try uploading the report to www.oraperf.com and see if tht helps in reading the output...

[robertbalmer]

Get this book:
Oracle 9i Performance Tuning Tips & Techniques
ISBN 0-07-222473-8

This book has a chapter on Statspack report interpreting

[Lily_Liu_2004]

all those metrics are better defined by using os tools, such as iostat, vmstat etc

Sometimes we need to look at the historic statistics about CPU and disk IO and memory.

How can I get such kind of historic os related information?

I mean that don’t have to bother unix admin.

Thanks,

[Lily_Liu_2004]

Right now i am thinking about:
1) use a cron job to run vmstat and iostat every 2 minuets
and put this data in one database.
This step is easy.

2) Then pull those data from the database to generate the area diagrams, or line diagrams or pie diagrams and put them on web.
So we can visually see what is/was going on for the time beign or
yesterday.

My question is:
Can I use any free tool or web-programming language to easily
accomplish step 2?