-
Trend analysis for STATSPACK report
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.
Last edited by skdas; 05-05-2003 at 02:04 PM.
-
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.
svk
-
Barleson Book on STATSPAK has lot of SQL Queries to find the trend. But there is no CD , for those queries.
-
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.
svk
-
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!
Jeff Hunter
-
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
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
-
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.
OCP 8i, 9i DBA
Brisbane Australia
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|