luke_wang的专栏

TPC：Transaction processing Performance Council  事务处理性能委员会TPC-B: measures throughput in terms of how many transactions per second a system can perform 测试一秒可以处理的事务个数pgbenchpgbench是基于tp

www.itpub.net/thread-1777234-1-1.htmllog file switch(checkpoint incomplete):原因：1）存在大量update操作；2）log file size太小，导致log switch太频繁；3）log group太少；log file switch(private strand flush incomplete):log file ...

http://m.blog.itpub.net/12679300/viewspace-1244578/Buffer Cache是SGA的一部分，Oracle利用Buffer Cache来管理data block，Buffer Cache的最终目的就是尽可能的减少磁盘I/O。 Buffer Cache中主要有3大结构用来管理Buffer Cache：Hash Bucket、Hash Chain Li...

https://blog.youkuaiyun.com/lqx0405/article/details/44777319Library cache包含了共享SQL区(shared SQL areas),私有SQL区(private SQLareas,如果配置了共享服务器),PL/SQL存储过程以及包，还有一些控制信息，比如说locks以及library cache handles。Dictionary cac...

db file sequential read:db file scattered read,  Avg wait time应当小于20ms  如果数据库执行全表扫描或者是全索引扫描会执行 Multi block I/O ，此时等待物理I/O 结束会出现此等待事件。一般会从应用程序（SQL），I/O 方面入手调整; 注意和《Instance Activity Stats》中的index fast ...

https://blog.youkuaiyun.com/notbaron/article/details/51284555latch: enqueue hash chainsenq: TX - row lock contentionenq: TX - index contentionenq: TX - contentionenq: HW - contentionenq: FB - contentionenq:...

latch free　　其实是未获得latch ，而进入latch sleep，见《全面解析9i以后Oracle Latch闩锁原理》

gc buffer waitgc current block 2-waygc cr multi block request

http://www.toutiao.com/a6439484337649975554/   善用性能工具进行SQL整体优化http://www.itpub.net/thread-1384552-1-1.html   Oracle性能调优原理及具体手段https://wenku.baidu.com/view/31eb51270722192e4536f6f8.html   Oracle内存全

http://www.pgcon.org/2007/schedule/attachments/35-TPC-E%20implementation-Mark-Wong-Rilson-Nascimento.pdf https://wenku.baidu.com/view/0ad580faf90f76c661371a0c.html https://www.baidu.com/link?u

http://www.perlmonks.org/?node_id=130699执行mysql测试sql-bench/test-select，报错Can't locate DBI.pm in @INCperl -MCPAN -e 'install DBI'perl -MCPAN -e 'install DBD::mysql'perl -MCPAN -e 'install

http://blog.chinaunix.net/uid-7589639-id-4126046.htmlhttp://www.cnblogs.com/conanwang/p/5910079.htmlhttp://imysql.cn/2014/10/17/sysbench-full-user-manual.shtmlsysbench:sysbench --test=fi

jMeter: java编写的压力测试工具http://jmeter.apache.org/usermanual/get-started.htmlLoadRunner:https://saas.hpe.com/en-us/software/loadrunner

ASM

topiostatsarperf

latch: in memory undo latch

http://blog.youkuaiyun.com/kaka1121/article/details/51496387http://blog.chinaunix.net/uid-24907956-id-3428052.html

PGA memory operation