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

Thread: Analyzing statspack report

  1. #1
    Join Date
    Jul 2002
    Posts
    205

    Analyzing statspack report

    Hi ,
    I got the following report from starts pack . Is there anything to be changed in the parameters to improve it.

    Load Profile
    ~~~~~~~~~~~~ Per Second Per Transaction
    --------------- ---------------
    Redo size: 29,546.78 542.54
    Logical reads: 2,650.11 48.66
    Block changes: 232.15 4.26
    Physical reads: 0.00 0.00
    Physical writes: 0.68 0.01
    User calls: 2,124.94 39.02
    Parses: 600.86 11.03
    Hard parses: 0.00 0.00
    Sorts: 0.55 0.01
    Logons: 0.04 0.00
    Executes: 1,146.58 21.05
    Transactions: 54.46

    % Blocks changed per Read: 8.76 Recursive Call %: 55.26
    Rollback per transaction %: 0.00 Rows per Sort: 33.08

    Instance Efficiency Percentages (Target 100%)
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    Buffer Nowait %: 99.99 Redo NoWait %: 100.00
    Buffer Hit %: 100.00 In-memory Sort %: 100.00
    Library Hit %: 99.99 Soft Parse %: 100.00
    Execute to Parse %: 47.60 Latch Hit %: 97.97
    Parse CPU to Parse Elapsd %: 42.98 % Non-Parse CPU: 97.21

    Shared Pool Statistics Begin End
    ------ ------
    Memory Usage %: 20.89 21.08
    % SQL with executions>1: 75.41 75.44
    % Memory for SQL w/exec>1: 62.58 62.59

    Top 5 Timed Events
    ~~~~~~~~~~~~~~~~~~ % Total
    Event Waits Time (s) Ela Time
    -------------------------------------------- ------------ ----------- --------
    CPU time 3,319 78.93
    latch free 31,758 508 12.08
    log file sync 30,153 369 8.77
    control file parallel write 202 3 .08
    buffer busy waits 192 2 .04
    -------------------------------------------------------------

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    To paraphrase his excellency TKyte: I stopped at 75 stop lights on my way to work. Is that alot?

    What is your snapshot interval?
    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."

  3. #3
    Join Date
    Jul 2002
    Posts
    205
    STATSPACK has run for 15 Minutes..

  4. #4
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    not much activity on your database.in the big scheme of things it looks okay.Are you facing a performance problem ?

    regards
    Hrishy

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