根据addm建议,这个sql从昨天晚上20点到现在14点执行了65390次,平均消耗了0.12S,
如果优化好这条sql,DB将得到61%的好处,不知道ORACLE是怎么计算的?
RECOMMENDATION 1: SQL Tuning, 61% benefit (8274 seconds)
ACTION: Run SQL Tuning Advisor on the SQL statement with SQL_ID
"7g98ktr8drf47".
RELEVANT OBJECT: SQL statement with SQL_ID 7g98ktr8drf47 and
PLAN_HASH 2414031861
SELECT * FROM (SELECT AA.*, ROWNUM RN FROM ( select * from
DBBS_RELY Where TOPICID = :1 order by RELYTIME asc,id asc ) AA
WHERE ROWNUM <= :2) WHERE RN >= :3
RATIONALE: SQL statement with SQL_ID "7g98ktr8drf47" was executed 65390
times and had an average elapsed time of 0.12 seconds.
我们使用DBMS_SQLTUNE看下Oracle对此条sql的建议
sys@g> /
REPORT
--------------------------------------------------------------------------------
GENERAL INFORMATION SECTION
-------------------------------------------------------------------------------
Tuning Task Name : 7g98ktr8drf47
Tuning Task Owner : SYS
Scope : COMPREHENSIVE
Time Limit(seconds)