Hi, I am new one to AWR report. Please anyone explain me about the columns in the "IOStat by Function/Filetype summary"?
If there are doucuments or link about these,will be better!
Specially the last column. Avg Tm(ms).
It means that the avg time about IO?
My Database's version : Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
Here are the two examples of my 20Mins' test result .
In 1) the DBWR's Avg Tm(ms) is null and LGWR's Avg Tm(ms) is not null.
In 2) the DBWR&LGWR's Avg Tm(ms) are null
what is the reason ?
1)
| Function/File Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Waits: Count | Avg Tm(ms) |
|---|
| Buffer Cache Reads | 516M | 53.74 | .423177 | 0M | 0.00 | 0M | 65.5K | 549.16 |
| Buffer Cache Reads (Data File) | 516M | 53.74 | .423177 | 0M | 0.00 | 0M | 65.5K | 549.16 |
| DBWR | 0M | 0.00 | 0M | 239M | 22.95 | .196006 | 0 | |
| DBWR (Data File) | 0M | 0.00 | 0M | 239M | 22.95 | .196006 | 0 | |
| Others | 67M | 1.60 | .054947 | 51M | 0.72 | .041825 | 1908 | 199.92 |
| Others (Control File) | 30M | 1.55 | .024603 | 13M | 0.68 | .010661 | 1894 | 199.92 |
| Others (Archive Log) | 0M | 0.00 | 0M | 37M | 0.03 | .030344 | 0 | |
| Others (Log File) | 37M | 0.04 | .030344 | 0M | 0.00 | 0M | 9 | 305.44 |
| Others (Data File) | 0M | 0.00 | 0M | 1M | 0.01 | .000820 | 5 | 10.80 |
| LGWR | 0M | 0.02 | 0M | 38M | 4.60 | .031164 | 23 | 106.04 |
| LGWR (Log File) | 0M | 0.00 | 0M | 37M | 4.58 | .030344 | 8 | 146.38 |
| LGWR (Control File) | 0M | 0.01 | 0M | 1M | 0.02 | .000820 | 15 | 84.53 |
| Direct Writes | 0M | 0.00 | 0M | 0M | 0.00 | 0M | 0 | |
| Direct Writes (Data File) | 0M | 0.00 | 0M | 0M | 0.00 | 0M | 0 | |
| Streams AQ | 0M | 0.00 | 0M | 0M | 0.00 | 0M | 5 | 636.00 |
| Streams AQ (Data File) | 0M | 0.00 | 0M | 0M | 0.00 | 0M | 5 | 636.00 |
| TOTAL: | 583M | 55.36 | .478125 | 328M | 28.27 | .268996 | 67.4K | 539.13 |
2)
| Function/File Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Waits: Count | Avg Tm(ms) |
|---|
| Buffer Cache Reads | 561M | 58.41 | .460539 | 0M | 0.00 | 0M | 71.1K | 620.07 |
| Buffer Cache Reads (Data File) | 561M | 58.41 | .460539 | 0M | 0.00 | 0M | 71.1K | 620.07 |
| DBWR | 0M | 0.00 | 0M | 90M | 8.48 | .073883 | 5 | 713.80 |
| DBWR (Data File) | 0M | 0.00 | 0M | 90M | 8.48 | .073883 | 0 | |
| DBWR (Control File) | 0M | 0.00 | 0M | 0M | 0.00 | 0M | 5 | 713.80 |
| Others | 32M | 1.68 | .026269 | 24M | 0.66 | .019702 | 2044 | 197.72 |
| Others (Control File) | 32M | 1.67 | .026269 | 12M | 0.64 | .009851 | 2035 | 198.22 |
| Others (Data File) | 0M | 0.01 | 0M | 12M | 0.02 | .009851 | 9 | 84.56 |
| LGWR | 0M | 0.00 | 0M | 22M | 4.53 | .018060 | 0 | |
| LGWR (Log File) | 0M | 0.00 | 0M | 22M | 4.53 | .018060 | 0 | |
| Streams AQ | 0M | 0.00 | 0M | 0M | 0.00 | 0M | 1 | 196.00 |
| Streams AQ (Data File) | 0M | 0.00 | 0M | 0M | 0.00 | 0M | 1 | 196.00 |
| TOTAL: | 593M | 60.09 | .486808 | 136M | 13.67 | .111645 | 73.2K | 608.27 |