分页跟buffer_cache关系

分页和buffer_cache关系
今天老大说分页时候会不会cache select语句的信息，然后再到下一页会不会快点，我说不会，我做个试验给他看看
首先清理内存中信息（重启数据库或者手动情况都一样）

alter system flush buffer_cache;

做一个10046时间，观察trace内容

--取0行数据select *       from (             select rownum rn,t.*             from             (select  OPERATE_TIME,SERVER_INFO ,ACCESS_IP ,USERID from bi_logfile where    OPERATE_TIME>=(sysdate-10)) t             where rownum<2)       where rn >1;--查看buffer cache中有没有bi_logfile表的数据SQL> SELECT o.OBJECT_NAME, COUNT(*) NUMBER_OF_BLOCKS     FROM DBA_OBJECTS o, V$BH bh    WHERE o.DATA_OBJECT_ID = bh.OBJD      AND o.OWNER        ='JSCNBI'    GROUP BY o.OBJECT_NAME    ORDER BY COUNT(*);