Oracle performance tuning

db block get+consistent gets = logical read

 

consistent gets=一致性读的block的个数,简单理解就是select访问的block个数 db block gets=简单理解,就是update、insert、delete访问的block个数

 

logical I/O 与 physical I/O 的区别:

1)logical I/O是指对cache到 Buffer Cache 中的数据块(db block)的访问请求。又分为:consistent gets 和 db block gets(current gets) consistent gets代表对特定版本或时间的block的访问select db block gets代表对最新的或当前的block的访问,通常用于Insert,update,delete 2)physical I/O是指通过底层的I/O系统,对没有cache到 Buffer Cache 中的数据块(db block)的访问请求。其实就是oracle在buffer cache中没有发现需要的block,而去访问datafile,并且将block populate到buffer cache中的过程。

 


DB CPU:Amount of CPU time (in microseconds) spent on database user-level calls. This does not include the CPU time spent on instance background processes such as PMON.


DB time: Amount of elapsed time (in microseconds) spent performing Database user-level calls. This does not include the time spent on instance background processes such as PMON.

 

公式:DB TIME= DB CPU + Non-Idle Wait + Wait on CPU queue 

 

Instance activity Statistics & Wait event Statistics

SELECT * FROM V$STATNAME;
SELECT * FROM V$SYSSTAT;
SELECT * FROM V$SESSTAT;

SELECT * FROM V$SERVICE_STATS;


SELECT * FROM V$EVENT_NAME;
SELECT * FROM V$SYSTEM_EVENT;
SELECT * FROM V$SESSION_EVENT;

SELECT * FROM V$SERVICE_EVENT;

 

SELECT * FROM V$SYSTEM_WAIT_CLASS;
SELECT * FROM V$SESSION_WAIT_CLASS;
SELECT * FROM V$SERVICE_WAIT_CLASS;

 

Diagnostic:

SELECT * FROM V$DIAG_INFO;

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值