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;
相关推荐
oracle performance tuning summary
Oracle Performance Tuning Guide
Oracle Performance Tuning and Optimization (Publisher: Macmillan Computer Publishing)
Oracle Performance Tuning for 10gR2 Second Edition很好的oracle调优手册推荐给各位
oracle 10g原厂oracle performance tuning 课件
Oracle Database Performance Tuning Guide, 10g Release 2 Oracle Database Performance Tuning Guide, 10g Release 2 Oracle Database Performance Tuning Guide, 10g Release 2
oracle 11g performance tuning 英文版
Oracle 11gR2 Performance Tuning 性能优化 参考手册
oracle 10g数据库的性能优化,适合数据库开发者和管理人员参考
英文原版 ORACLE SQL PERFORMANCE TUNING AND OPTIMIZATION
Oracle Database 12c Release 2 Performance Tuning Tips and Techniques
Oracle Database 10g Performance Tuning
This document is about oracle performance tuning.
PERFORMANCE TUNING ORACLE RAC ON LINUX
实用经典的9i教材,虽然oracle11g出了很久了,但是9i教材撰写的还是非常详细和经典的。相对11g糟烂晦涩的教材来说,是绝对不可替代的。 对于新手来说是必备的首选教材。 多收两分,可以理解吧.... 不多说了 希望...
高清彩版 Oracle SQL Performance Tuning and Optimization: It's all about the Cardinalities