客户反映系统I/O资源比较高,并且数据库查询很慢,首先登录到客户环境查看了一下
Sid User Event W Scnds Details
--- ---------- ------------------------------- - ----- -----------------------------
3286SYS TCP Socket (KGAS) Y105698 : (0000000000000002)
3243SYSMAN wait for unread message on bro Y 29 channel context: (C0000004D119C310)
3304/SYS DIAG idle wait Y 66 component: (0000000000000001)
3177SYS SQL*Net more data from client N 0 driver id: (0000000062657100)
3169JTDATA db file scattered read Y 0 file#: (0000000000000006) 'jt_data.271.634300641'
3180JTDATA db file scattered read Y 0 file#: (000000000000001D) 'jt_dataa101.ora'
3221JTDATA db file scattered read Y 0 file#: (000000000000001D) 'jt_dataa101.ora'
3205JTDATA db file scattered read Y 0 file#: (0000000000000027) 'jt_dataa_106.ora'
3220JTDATA read by other session Y 0 file#: (0000000000000027) 'jt_dataa_106.ora'
3234JTDATA read by other session Y 0 file#: (0000000000000027) 'jt_dataa_106.ora'
3246JTDATA read by other session Y 0 file#: (0000000000000027) 'jt_dataa_106.ora'
3255JTDATA read by other session Y 0 file#: (0000000000000027) 'jt_dataa_106.ora'
3267JTDATA read by other session Y 0 file#: (0000000000000027) 'jt_dataa_106.ora'
3271JTDATA read by other session Y 0 file#: (0000000000000027) 'jt_dataa_106.ora'
3181JTDATA db file sequential read Y 0 file#: (000000000000005B) 'jt_data.358.802873621'
3185JTDATA read by other session Y 0 file#: (000000000000005B) 'jt_data.358.802873621'
3186JTDATA read by other session Y 0 file#: (000000000000005B) 'jt_data.358.802873621'
3189JTDATA gc buffer busy Y 0 file#: (000000000000005B) 'jt_data.358.802873621'
3190JTDATA db file sequential read N 0 file#: (000000000000005B) 'jt_data.358.802873621'
3191JTDATA read by other session Y 0 file#: (000000000000005B) 'jt_data.358.802873621'
3193JTDATA db file sequential read Y 0 file#: (000000000000005B) 'jt_data.358.802873621'
3196JTDATA gc buffer busy Y 0 file#: (000000000000005B) 'jt_data.358.802873621'
3202JTDATA read by other session N 0 file#: (000000000000005B) 'jt_data.358.802873621'
3204JTDATA db file sequential read Y 0 file#: (000000000000005B) 'jt_data.358.802873621'
3219JTDATA db file sequential read Y 0 file#: (000000000000005B) 'jt_data.358.802873621'
3223JTDATA read by other session Y 0 file#: (000000000000005B) 'jt_data.358.802873621'
3224JTDATA db file sequential read Y 0 file#: (000000000000005B) 'jt_data.358.802873621'
3225JTDATA db fi