- 论坛徽章:
- 0
|
楼主,我也出现类似问题。
CPU0 states: 1.4% user 0.5% system 0.0% nice 0.0% iowait 97.0% idle
CPU1 states: 65.1% user 34.2% system 0.0% nice 0.0% iowait 0.1% idle
Mem: 3608404k av, 3596036k used, 12368k free, 0k shrd, 99720k buff
2696776k actv, 40k in_d, 94348k in_c
Swap: 4096564k av, 893928k used, 3202636k free 2792856k cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
11847 oracle 21 0 125M 125M 123M R 99.9 3.5 14:38 1 oracle
——————————————————————————————————————————
早高峰时load average:12左右,平时都还可以,通过pid得出该进程做了如下操作:
SELECT UIN ,NICKNAME , PASSWORD, STRID , SEX ,FACELINK , BIRTHDAY , EMAIL , EMAIL_BAK , PHONE ,FAX ,MOBILE , PROVINCE ,CITY ,ZIPCODE ,ADDRESS ,HOMEPAGE ,HOMEPAGE1 ,COMPANY ,DEPARTMENT_ID , COMPANY_ID,ZHIWU,RESUME FROM User_info_tb WHERE (UIN=:1) order by UIN desc
-------------------------------------------------------------------------------------------------------
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
SQL> select count(*) from user_info_tb;
COUNT(*)
----------
1794773
SQL>
----------------------------------------------------------------------------------------
问题出现在早高峰比较厉害。因为这套系统对外运行,早上班高峰访问比较集中。以上截图是在晚上,还可以。这是个长连接,表的数据量比较大。180W的数据,已经对uin建了index.这条sql执行非常频繁。哪位大大给点分析及建议。谢谢!
[ 本帖最后由 gerry_wxy 于 2007-3-21 23:09 编辑 ] |
|