|
楼主 |
发表于 2017-5-24 14:23:15
|
显示全部楼层
以6,438,033为例
这个数代表: 读取的块数* 次数
是不是意味着这个段被读取了MB= 6,438,033/1024/1024=6M左右?
这个数感觉也不对
如下是这个段的情况:
Segments by Physical Reads- Total Physical Reads: 94,573,525
- Captured Segments account for 97.5% of Total
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Physical Reads | %Total | NL011 | DBS1 | TMP_MAGE_SOURCE | | TABLE | 91,545,353 | 96.80 | NL011 | DBS1 | TC_MAGE_KEY_FILE | | TABLE | 282,194 | 0.30 | SYS | SYSTEM | ICOL$ | | TABLE | 181,427 | 0.19 | DS | DBS1 | GDN_FILE | | TABLE | 98,727 | 0.10 | NL011 | DBS1 | TC_MAGE_MS | | TABLE | 27,537 | 0.03 |
Back to Segment Statistics
Back to Top Segments by Physical Read Requests- Total Physical Read Requests: 6,541,001
- Captured Segments account for 96.4% of Total
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Phys Read Requests | %Total | NL011 | DBS1 | TMP_MAGE_SOURCE | | TABLE | 5,971,818 | 91.30 | NL011 | DBS1 | TC_MAGE_KEY_FILE | | TABLE | 235,832 | 3.61 | SYS | SYSTEM | ICOL$ | | TABLE | 46,007 | 0.70 | NL011 | DBS1 | PK_TMP_MAGE_SOURCE | | INDEX | 7,446 | 0.11 | DS | DBS1 | GDN_FILE | | TABLE | 5,888 | 0.09 |
而这个TMP_MAGE_SOURCE表是主要被物理读的对象,同一时刻
IOStat by Function summary- 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
- ordered by (Data Read + Write) desc
Function Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Waits: Count | Avg Tm(ms) | Direct Reads | 710.3G | 1685.51 | 201.82M | 0M | 0.00 | 0M | 6074.5K | 0.01 | Buffer Cache Reads | 11G | 128.83 | 3.112M | 0M | 0.00 | 0M | 461.8K | 0.30 | Others | 549M | 2.45 | .152M | 497M | 1.49 | .138M | 14.2K | 1.65 | LGWR | 0M | 0.00 | 0M | 695M | 70.39 | .193M | 253K | 2.01 | DBWR | 0M | 0.00 | 0M | 523M | 9.37 | .145M | 21.9K | 1.25 | Direct Writes | 0M | 0.00 | 0M | 0M | 0.00 | 0M | 3 | 1.00 | Streams AQ | 0M | 0.00 | 0M | 0M | 0.00 | 0M | 7 | 0.00 | TOTAL: | 721.8G | 1816.78 | 205.085 | 1.7G | 81.25 | .476M | 6825.3K | 0.11 |
这个710G的直接路径读,主要应该就是物理读表TMP_MAGE_SOURCE造成的
我的疑惑是从数据上看 91,545,353这个数跟710G,是怎么关联上的?好像怎么算都差距很大
|
|