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

Thread: STATSPACK

  1. #1
    Join Date
    Nov 2000
    Posts
    440
    I have generated the report spreport and here a small portion of the result that i got.

    It gives me my Top 5 Wait Events: are they tunable, are those waits are normal?


    My Execute to Parse hit ratio is at 4.42 %

    What should i do?



    Instance Efficiency Percentages (Target 100%)
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    Buffer Nowait %: 100.00 Redo NoWait %: 100.00
    Buffer Hit %: 91.43 In-memory Sort %: 99.54
    Library Hit %: 97.27 Soft Parse %: 95.83
    Execute to Parse %: 4.42 Latch Hit %: 100.00
    Parse CPU to Parse Elapsd %: % Non-Parse CPU:

    Shared Pool Statistics Begin End
    ------ ------
    Memory Usage %: 95.08 16.27
    % SQL with executions>1: 91.41 69.20
    % Memory for SQL w/exec>1: 86.61 54.55

    Top 5 Wait Events
    ~~~~~~~~~~~~~~~~~
    Wait % Total Event Waits Time (cs) Wt Time
    ------------- ------------ ------------ -------
    db file sequential read 115,950 0 .00
    direct path read 88,154 0 .00
    direct path write 83,153 0 .00
    db file scattered read 69,624 0 .00
    SQL*Net more data to client 62,901 0 .00
    -------------------------------------


    [Edited by steeve123 on 05-03-2001 at 11:02 AM]

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Check out the following articles on how to read the statspack reports...

    http://www.oracle.com/oramag/oracle/...ml?o20tun.html
    http://www.oracle.com/oramag/oracle/...ml?o50tun.html
    Jeff Hunter

  3. #3
    Join Date
    Nov 2000
    Posts
    440
    i did, and it's not helping me

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