get snapshot for database 中可以看到日志的读写Log pages read = 0Log read time (sec.ns) &nb...
显示全部get snapshot for database 中可以看到日志的读写
Log pages read = 0
Log read time (sec.ns) = 0.000000000
Log pages written = 0
Log write time (sec.ns) = 0.000000000
Number write log IOs = 0
Number read log IOs = 0
Number partial page log IOs = 0
Number log buffer full = 0
Log data found in buffer = 0
Log to be redone for recovery (Bytes) = 0
get snapshot for tablespaces 能看到表空间的读写
Buffer pool data logical reads = 1064
Buffer pool data physical reads = 162
Buffer pool temporary data logical reads = 0
Buffer pool temporary data physical reads = 0
Asynchronous pool data page reads = 15
Buffer pool data writes = 0
Asynchronous pool data page writes = 0
Buffer pool index logical reads = 778
Buffer pool index physical reads = 323
Buffer pool temporary index logical reads = 0
Buffer pool temporary index physical reads = 0
Asynchronous pool index page reads = 0
Buffer pool index writes = 0
Asynchronous pool index page writes = 0
Buffer pool xda logical reads = 0
Buffer pool xda physical reads = 0
Buffer pool temporary xda logical reads = 0
Buffer pool temporary xda physical reads = 0
Asynchronous pool xda page reads = 0
Buffer pool xda writes = 0
Asynchronous pool xda page writes = 0
Total buffer pool read time (millisec) = 686
Total buffer pool write time (millisec) = 0
Total elapsed asynchronous read time = 15
Total elapsed asynchronous write time = 0
Asynchronous data read requests = 6
Asynchronous index read requests = 0
Asynchronous xda read requests = 0
No victim buffers available = 0
Direct reads = 484
Direct writes = 0
Direct read requests = 38
Direct write requests = 0
Direct reads elapsed time (ms) = 55
Direct write elapsed time (ms) = 0
Number of files closed = 0
收起