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

Thread: timed statistics and statspack report

Threaded View

  1. #9
    Join Date
    Jan 2001
    Posts
    2,828
    Hi All

    Code:
    Top 5 Wait Events
    ~~~~~~~~~~~~~~~~~                       Wait     % Total
    Event                         Waits  Time (cs)   Wt Time
    ---------------------------- ------ ------------ -------
    db file scattered read       56,100            0     .00
    db file sequential read      38,457            0     .00
    SQL*Net message to dblink    19,606            0     .00
    SQL*Net message from dblink  19,600            0     .00
    direct path read             11,006            0     .00
    now this means that there were 56,100 waits maybe in 100,000cs or maybe in 15secs
    if former the wait event maybe significant if later then they can be ignored

    can i base my arguments like above

    regards
    Hrishy
    Last edited by marist89; 04-29-2004 at 08:08 AM.

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