advise on statspack report
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: advise on statspack report

  1. #1
    Join Date
    Sep 2002
    Posts
    411

    advise on statspack report

    below is the stat on my report

    Instance Efficiency Percentages (Target 100%)
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    Buffer Nowait %: 99.83 Redo NoWait %: 100.00
    Buffer Hit %: 91.78 In-memory Sort %: 97.00
    Library Hit %: 97.27 Soft Parse %: 95.93
    Execute to Parse %: 39.28 Latch Hit %: 99.73
    Parse CPU to Parse Elapsd %: 27.96 % Non-Parse CPU: 99.95

    Shared Pool Statistics Begin End
    ------ ------
    Memory Usage %: 90.50 90.27
    % SQL with executions>1: 53.53 74.76
    % Memory for SQL w/exec>1: 47.92 64.18

    Top 5 Wait Events
    ~~~~~~~~~~~~~~~~~ Wait % Total
    Event Waits Time (cs) Wt Time
    -------------------------------------------- ------------ ------------ -------
    SQL*Net more data from dblink 5,091 35,811 37.22
    SQL*Net break/reset to client 50 20,530 21.34
    db file sequential read 77,933 19,841 20.62
    SQL*Net message from dblink 8,537 5,632 5.85
    db file scattered read 12,169 4,041 4.20


    I wouldn't worry too much about dblink b/c the users getting data from another data to this database and I won't worry much about. what I need to aks is
    Parse CPU to Parse Elapsd %: 27.96 which I think it's low, what about the SQL*Net break/reset to client???

    thanks

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    SQL*Net events can usually be ignored...
    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
    Sep 2002
    Posts
    411
    thanks so much Jeff

    what about Parse CPU to Parse Elapsd %: 27.96 which I think it's low.

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