oracle buffer gets=db block gets+consistent gets

SQL> select STATISTIC#,name from v$statname where name like '%db block gets%';
 
STATISTIC# NAME
---------- ----------------------------------------------------------------
        63 db block gets
        64 db block gets from cache
        65 db block gets from cache (fastpath)
        66 db block gets direct

--9号会话为用户会话       
SQL> select sid,VALUE from v$sesstat where STATISTIC#=63 and sid=9;
 
       SID      VALUE
---------- ----------
         9        375
 
--9号会话插入数据        
SQL> insert into t_detail values(2);

1 row created.

SQL> commit;

Commit complete.  

--回到监控会话发现   
SQL> select sid,VALUE from v$sesstat where STATISTIC#=63 and sid=9;
 
       SID      VALUE
---------- ----------
         9        378

--9号会话多次运行select查询, db block gets未发生变化

小结：db block gets仅与dml有关   

--buffer gets如何计算
buffer  gets =  db block gets +  consistent  gets  

 

---db block gets与consistent gets可由如何计算而知
SQL>  select STATISTIC#,name from v$statname where name like '%db block get%';
 
STATISTIC# NAME
---------- ----------------------------------------------------------------
        63 db block gets
        64 db block gets from cache
        65 db block gets from cache (fastpath)
        66 db block gets direct
 
SQL>  select STATISTIC#,name from v$statname where name like '%consistent gets%';
 
STATISTIC# NAME
---------- ----------------------------------------------------------------
        67 consistent gets
        68 consistent gets from cache
        69 consistent gets from cache (fastpath)
        70 consistent gets - examination
        71 consistent gets direct  

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/9240380/viewspace-756266/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/9240380/viewspace-756266/