- 最后登录
- 2023-8-16
- 在线时间
- 1686 小时
- 威望
- 2135
- 金钱
- 50532
- 注册时间
- 2011-10-12
- 阅读权限
- 200
- 帖子
- 5207
- 精华
- 39
- 积分
- 2135
- UID
- 2
|
3#
发表于 2012-5-21 13:40:52
注意 今后再以这种无意义标题发的帖子 一律不看不回!
Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
CPU time 1,592 51.8
db file sequential read 263,366 1,228 5 40.0 User I/O
direct path read 1,721,880 290 0 9.4 User I/O
SQL*Net more data to client 5,637,615 175 0 5.7 Network
control file sequential read 144,055 35 0 1.2 System I/O
direct path read 主要由 lob读取引起 physical reads direct (lob) 1,761,180 488.97
考虑加大buffer cache 减少 db file sequential read 和 direct path read
考虑优化SQL 减少 以下SQL的逻辑读 以减少cpu time
Buffer Gets Executions Gets per Exec %Total CPU Time (s) Elapsed Time (s) SQL Id SQL Module SQL Text
1,773,446 5,744 308.75 5.29 31.72 61.99 2rkjfjh0ayn4b w3wp.exe select USERID, EMAILID, substr...
858,032 53,631 16.00 2.56 12.83 12.85 3k326fnhd3ra6 w3wp.exe select ID, DEPTID, DEPTNAME, P...
761,670 3,791 200.92 2.27 24.85 86.99 0yqkhcfnc94gk w3wp.exe insert into INBOX(USERID, EMAI... |
|