DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Statspack intepretation?

  1. #1
    Join Date
    Sep 2001
    Posts
    200

    Statspack intepretation?

    Hi fellows,
    I'm looking to run a statspack. Can anyone point me to any paper on reading it or understanding it?
    Thanks a bundle
    Life is what is happening today while you were planning tomorrow.

  2. #2
    Join Date
    Feb 2003
    Location
    INDIA
    Posts
    96
    Hi,

    There are some papers on metalink about interpratation, but it purely depends on your environment of database.

    1. Statspack useful to diagnose the issues for the the period.
    2. Regular monitoring (behaviours of I/O subsystems, reads writes on the tablespaces)
    3. Monitoring top queries.

    If you are on 10g, AWR reports provides more details.

    Dilipkumar Patel.

  3. #3
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Buy Expert one-on-one book.

    Tom explained in detail

    Tamil

  4. #4
    Join Date
    Sep 2001
    Posts
    200
    thanks for all your suggestions...
    Life is what is happening today while you were planning tomorrow.

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