linux 使用FIO测试磁盘iops
FIO是测试IOPS的非常好的工具,用来对硬件进行压力测试和验证,支持13种不同的I/O引擎,包括:sync,mmap, libaio, posixaio, SG v3, splice, null, network, syslet, guasi, solarisaio 等等。 fio 官网地址...
db file sequential read 详解
db file sequential read (本文由thomaswoo_dba翻译,转载请注明出处)db file sequential read 事件有三个参数:file#,first block#, block count, 在oracle 10g里,此等待事件在归于 User I/O wait class 下面的. 处...
【等待事件】log file switch (checkpoint incomplete)
等待时间描述: Waiting for a log switch because thesession cannot wrap into the next log. Wrapping cannot be performed because thecheckpoint for that log has not completed.当你的日志组...