摘要: -----------------------------------------------------------数据缓存实验set autotrace traceonly/off; --打开/关闭 跟踪模式,执行计划+statisticsselect * from hr.jobs;alter system flush buffer_cache; ----清除缓存,数据库数据高速缓存select * from hr.jobs;select * from hr.jobs;set autotrace off;---9 consistent gets 读取的block数量6physical re 阅读全文
posted @ 2013-08-10 12:41 kevinboy 阅读(196) 评论(0) 推荐(0) 编辑