整个DB的 wait time + service 也就3,469/67.85% =5112 sec , 而底下的SQL 就占了4772/5112 = 93%
1,116,271
9221,210.7 48.8 321.14 4772.69 3349272485
Module: /usr/WebSphere/AppServer/java/bin/java@rmsvtp02
SELECT COUNT(ROWNUM) FROM TS_FLPLNRELVIEW R, TS_FLPLNCMPNT T WHE
RE R.FLPLNCMPNTTGTID = T.FLPLNCMPNTID AND R.FLPLNCMPNTSRCID = :B
3 AND UPPER(T.FLPLNCMPNTCODE) = :B2 AND R.FLPLNVIEWID = :B1 AND
ROWNUM <= 1 |