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

Thread: statspack report

Threaded View

  1. #1
    Join Date
    Sep 2002
    Posts
    411

    statspack report

    Could someone please give me some advises with this report??? I think, the report reflect that the database had I/O issues but I am not sure how to attack the right problem.

    Instance Efficiency Percentages (Target 100%)
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    Buffer Nowait %: 99.94 Redo NoWait %: 100.00
    Buffer Hit %: 84.25 In-memory Sort %: 99.98
    Library Hit %: 90.59 Soft Parse %: 63.25
    Execute to Parse %: 63.75 Latch Hit %: 99.83
    Parse CPU to Parse Elapsd %: 91.82 % Non-Parse CPU: 99.98

    Shared Pool Statistics Begin End
    ------ ------
    Memory Usage %: 72.26 90.46
    % SQL with executions>1: 59.26 48.01
    % Memory for SQL w/exec>1: 42.20 35.04

    Top 5 Wait Events
    ~~~~~~~~~~~~~~~~~ Wait % Total
    Event Waits Time (cs) Wt Time
    -------------------------------------------- ------------ ------------ -------
    db file scattered read 2,419,171 178,492 76.70
    db file sequential read 656,065 25,652 11.02
    log file parallel write 70,378 16,616 7.14
    db file parallel write 1,983 3,639 1.56
    buffer busy waits 108,393 2,169 .93
    Last edited by mike2000; 03-25-2003 at 11:32 PM.

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