-
编辑 删除
DB Bocks gets，Consistent gets And Physical reads 转载
Statistics----------------------------------------------------------1 recursive calls0 db block gets97 consistent gets0 physical reads0 redo size26360 bytes sent via SQL*Net to client554 bytes received via SQL*Net from client16 SQL*Net roundtrips to/from client0 sorts (memory)0 sorts (disk)219 rows processed自己测试了一个SQL转载一些概念官方在线文档基本的定义为如下：DB block gets：the number of accesses to the current image of a blockConsistent gets：the number of accesses to a read-consistent im
-
编辑 删除
log file sync等待事件
测试系统的一个statspack报告Top 5 Timed Events Avg %Total~~~~~~~~~~~~~~~~~~ wait CallEvent Waits Time (s) (ms) Time----------------------------------------- ------------ ----------- ------ ------CPU time 1 60.0log file parallel write 2 0 93 19.5log file sync 1 0 181 19.0control file parallel write 10 0 1 .8control file sequential read 214 0 0 .6转载记录log file parallel write事件：当日志缓存到日志文件时,这是一个主要的等待事件。虽然这个时间的名字中有"并行"(parallel)字样,但即使日志缓存并没
