Reading a statspack report ...
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Reading a statspack report ...

  1. #1
    Join Date
    Jul 2003
    Location
    Sacto
    Posts
    5

    Reading a statspack report ...

    Forum,

    I was able to run a statspack report against one of my Oracle 9.2.0.2 databases and send that up to ORAPERF for evaluation. I really don't know were to start reading the report since there is so much information.

    The bottom of the report showed the following:

    YAPP Report Generator
    for STATSPACK files
    (Version 2.0.11 Beta)

    Advice...

    The advice is given in the order of the most impact of the total reponse time. The percentage gain is taken of the reponse time.

    Maximum
    Gain
    (%) What Detail

    0 Check Parallel Cache Management locking strategies Don't use DBA locking for read intensive blocks, use Hash Releasable locking.. Check to see if there are false pings or any hot blocks...

    1 Check your network
    for congestion This should normally be a non issue.

    2 Tune the TX enqueue. No detailed information is available

    5 Tune the DFS lock
    handle event. No detailed information is available

    22 Tune the global cache
    cr request event. No detailed information is available


    Any assistance in reading this report will be appreciated.


    Thanks,

    James Bennett

  2. #2
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    If you have Tom's Expert One-on-One Oracle book, there is a chapter on Statspack. Also you can go thru the sample chapter of his upcomming book in which he has explained nicely, how to use Statspack.

    Check this link :

    http://www.osborne.com/products/0072...657_ch02bb.pdf
    -- Dilip

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