반품
-
제목
Oracle Instance Report Average Write Time conflicts with Performance dashboard metric -
설명
An Oracle report on I/O activity reports the Average Write time as 0.02 ms during last 24 hours. When viewing the Performance Dashboard, the same metric value is reported as "24.01" during the same reporting time period. -
원인
Often the dashboard metric and the report metric may differ due as a different unit scale is used to properly graph the collected metrics and display them for review. -
해결 방안
Hover over the Performance dashboard metric value to view the actual unit dashboard value. In this case the value displayed is in miliseconds.Average Write Time:The average time spent (ms) writing a data block from the database buffer to the disk. The DBWR writes data blocks to datafiles (for example, flushing dirty data buffers from the SGA to the datafiles).* On most disks this metric should not exceed 20 milliseconds and readings above 40 milliseconds may indicate either a device bottleneck, or poorly configured disks or storage sub-systems.
The metric is calculated as follows:(Datafile write)1000 * -----------------------------------------------(Physical writes - Physical writes direct) -
첨부 파일
