| Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn |
|---|
| SQL*Net more data from dblink | 406,747 | | 466 | 1 | 184.13 |
| db file scattered read | 28,659 | | 330 | 12 | 12.97 |
| SQL*Net message from dblink | 30,115 | | 254 | 8 | 13.63 |
| log file parallel write | 21,021 | | 177 | 8 | 9.52 |
Hi All
As below example, I have question What is measure of "Waits" value in "Wait Events" section in AWR report?
Because "Waits" value is high but "Total Wait Time (s)" is low. example "SQL*Net message from dblink" has 30,115 "Waits" but "Total Wait Time (s)" less than "db file scattered read" has 28,659 "Waits".
Could you please explain more about "Waits" value?
Thank you
Hiko