- 最后登录
- 2023-8-16
- 在线时间
- 1686 小时
- 威望
- 2135
- 金钱
- 50532
- 注册时间
- 2011-10-12
- 阅读权限
- 200
- 帖子
- 5207
- 精华
- 39
- 积分
- 2135
- UID
- 2
|
5#
发表于 2014-3-14 17:11:07
Physical Reads Executions Reads per Exec %Total CPU Time (s) Elapsed Time (s) SQL Id SQL Module SQL Text
8,186,762 1 8,186,762.00 43.27 562.78 3461.99 fmt8hr9dntv5m JDBC Thin Client select * from (select * from G...
1,001,154 1 1,001,154.00 5.29 26.64 422.95 3hbm32un274wz JDBC Thin Client select * from (select t.log_id...
select * from (select * from GW_7000_STATEREPORTLOG t where t.log_id>:1 order by t.log_id) where rownum<=500
select * from (select t.log_id, t.inner_service_id, t.msg_id, t.registered_delivery, t.service_id, t.src_id, t.dest_terminal_id, t.report_id from GW_7000_MTLOG t where t.log_id>:1 order by t.log_id) where rownum<=500
2个类似的SQL只要求返回500行,但消耗了大量IO
table scans (long tables) 33 0.01 0.00
主线问题估计很简单 就是有大的全表扫描
Segments by Physical Reads
Total Physical Reads: 18,919,861
Captured Segments account for 91.1% of Total
Owner Tablespace Name Object Name Subobject Name Obj. Type Physical Reads %Total
SMSLOGUSR TBS_USMP01 GW_7000_MTLOG P20130711 TABLE PARTITION 2,905,734 15.36
SMSLOGUSR TBS_USMP01 GW_7000_MTLOG P20130712 TABLE PARTITION 2,792,884 14.76
SMSLOGUSR TBS_USMP01 GW_7000_MTLOG P20130709 TABLE PARTITION 2,407,568 12.73
SMSLOGUSR TBS_USMP01 GW_7000_MTLOG P20130708 TABLE PARTITION 680,456 3.60
SMSLOGUSR TBS_USMP01 GW_7000_STATEREPORTLOG P20140309 TABLE PARTITION 677,182 3.58 |
|