Trend analysis for STATSPACK report

[skdas]

Hi ,

I collect the STASPACK snapshot every one hour.

By running spreport I get the statistics between two SNAPSHOTS.

But I need the TREND analysis. Whether any site is there containing the SQLs for collecting the trend from Oracle STATPACK Tables.

[svk]

You can write your own queries using the statspack tables.

Normally, the TREND analysis is specific to your environment. So, its best to write your own queries instead of depending on something ready-made.

[skdas]

Barleson Book on STATSPAK has lot of SQL Queries to find the trend. But there is no CD , for those queries.

[svk]

That book is a very good source. But beleive me, take that just as a guideline. Write your own stuff based on that. It will give you much more meaningful output.

[marist89]

Originally posted by svk
That book is a very good source. But beleive me, take that just as a guideline. Write your own stuff based on that. It will give you much more meaningful output.

Agreed!

[SANJAY_G]

Originally posted by skdas
Barleson Book on STATSPAK has lot of SQL Queries to find the trend. But there is no CD , for those queries.

The code is available for download at Oracle Press.
http://shop.osborne.com/cgi-bin/orac...07222360X.html

[grjohnson]

All in all though you have to perform your own trend analysis. All statspak does is provide... well.. stats. It's up to you to determine the trends of them. There isn't an off-the-shelf piece of sotware that iI know off that lets you load the stats into. Sounds like something Oracle should. I know in OEM you can RECORD the performance of certain area of further analysis. But it is limited.