在一个非常空闲的系统中，用AWR发现一条语句的consistent gets比较高：

　　01 SELECT * FROM

　　02 (

　　03     SELECT RESOURCES.CATALOGID, ARTICLE.TITLE AS TITLE, ARTICLE.ID AS ID,

　　04     ARTICLE.HOTDESC AS BRIEF, ARTICLE.CREATORTIME AS TIME, ARTICLE.PIC AS PICTURE,

　　05     ARTICLE.ISPICARTICLE AS ISPICARTICLE, RESOURCES.URL AS FILEURL, ARTICLE.TYPE AS TYPE,

　　06     ARTICLE.LINKURL AS LINKURL, RESOURCES.SITE, RESOURCES.ORDERLINE AS L_ORDERS,

　　07     TO_CHAR(ARTICLE.CREATORTIME, 'YYYY') AS YEAR, TO_CHAR(ARTICLE.CREATORTIME, 'MM') AS MONTH,

　　08     TO_CHAR(ARTICLE.CREATORTIME, 'DD') AS DAY, TO_CHAR(ARTICLE.CREATORTIME, 'HH24') AS HOUR,

　　09     TO_CHAR(ARTICLE.CREATORTIME, 'MI') AS MINUTE, TO_CHAR(ARTICLE.CREATORTIME, 'SS') AS SECOND,

　　10     ARTICLE.ISNEW, ARTICLE.ISHOT, ARTICLE.TITLEFONTCOLOR, ARTICLE.TITLEFONTNAME,

　　11     ARTICLE.TITLEBOLD , ARTICLE.ORDERS, ARTICLE.ISINSTANCY

　　12     FROM ARTICLE, RESOURCES

　　13     WHERE 1=1

　　14     AND RESOURCES.STATE=1

　　15     AND TO_CHAR(ARTICLE.ID)=TRIM(RESOURCES.SOURCEID)

　　16     AND RESOURCES.CATALOGID=20794

　　17     ORDER BY ISINSTANCY DESC, L_ORDERS DESC

　　18 ) WHERE ROWNUM<31

　　执行计划及统计信息如下：

　　01 --------------------------------------------------------------------------------------

　　02 | Id  | Operation                       | Name          | Rows  | Bytes | Cost (%CPU)|

　　03 --------------------------------------------------------------------------------------

　　04 |   0 | SELECT STATEMENT                |               |    30 | 38790 |  2972   (1)|

　　05 |   1 |  COUNT STOPKEY                  |               |       |       |            |

　　06 |   2 |   VIEW                          |               |   126 |   159K|  2972   (1)|

　　07 |   3 |    SORT ORDER BY STOPKEY        |               |   126 | 18018 |  2972   (1)|

　　08 |   4 |     HASH JOIN                   |               |   126 | 18018 |  2972   (1)|

　　09 |   5 |      TABLE ACCESS BY INDEX ROWID| RESOURCES     |   126 |  7560 |    48   (0)|

　　10 |   6 |       INDEX RANGE SCAN          | IDX_RESOURCES |   126 |       |     1   (0)|

　　11 |   7 |      TABLE ACCESS FULL          | ARTICLE       | 60606 |  4912K|  2923   (1)|