数据库系统特别慢，CUP高峰占到了90多，原因查不出来。

select * from ( select rownumber() over() as rownumber_, j.REMIT_ID,j.ELECT_RECE_BILL,j.REMIT_NAME,j.REMIT_TIME,j.AMOUNT,j.OPER_TYPE,j.IS_RECONC,j.CENTER_CODE,(select count(APP_ID) from TBZ_APP_HAS_REMIT b where b.REMIT_ID=j.REMIT_ID) as APPCOUNT from TBA_REMIT_INFO j where j.CENTER_CODE = ? ) as temp_ where rownumber_ between 1 and 10 126702072 SQL0445W Value "select function0_.FUNCTION_ID as FUNCTION1_8_, function0_.FU" 是用这条语句吗。

select * from sysibmadm.snapdyn_sql order by total_usr_cpu_time desc fetch first 5 rows only