Trend analysis for STATSPACK report
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Trend analysis for STATSPACK report

  1. #1
    Join Date
    Jul 2002
    Posts
    205

    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.

  2. #2
    Join Date
    Jul 2000
    Posts
    521
    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

  3. #3
    Join Date
    Jul 2002
    Posts
    205
    Barleson Book on STATSPAK has lot of SQL Queries to find the trend. But there is no CD , for those queries.

  4. #4
    Join Date
    Jul 2000
    Posts
    521
    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

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    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
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  6. #6
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    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"

  7. #7
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    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
  •  



Click Here to Expand Forum to Full Width