可以使用 onstat -r 命令反复在指定的时间间隔打印指定选项的统计信息。
使用 onstat -r seconds other_options 命令来指定重复其他选项的时间间隔。
使用 onstat -r other_options 命令来让此选项每隔五秒重复一次,这将使其他选项能与 -r 选项连接。如下所示: onstat -rFh 。
onstat -r 命令可以在命令方式和交互方式下使用,并可能对将命令重复输出到受监视系统的资源利用有用。
图: 命令输出
onstat -r GBase 8s Database Server Version 11.70.F -- On-Line -- Up 20:05:25 -- 1067288 Kbytes GBase 8s Database Server Version 11.70.F -- On-Line -- Up 20:05:30 -- 1067288 Kbytes GBase 8s Database Server Version 11.70.F -- On-Line -- Up 20:05:35 -- 1067288 Kbytes
图: 命令输出
onstat -r 10 GBase 8s Database Server Version 11.50.F -- On-Line -- Up 20:06:58 -- 1067288 Kbytes GBase 8s Database Server Version 11.50.F -- On-Line -- Up 20:07:08 -- 1067288 Kbytes GBase 8s Database Server Version 11.50.F -- On-Line -- Up 20:07:18 -- 1067288 Kbytes
图: onstat -r 1 -h 命令输出
onstat -r 1 -h Buffer pool page size: 2048 buffer hash chain length histogram # of chains of len 3841 0 3767 1 522 2 62 3 8192 total chains 4351 hashed buffs 5000 total buffs Buffer pool page size: 2048 buffer hash chain length histogram # of chains of len 4020 0 3392 1 735 2 43 3 2 4 8192 total chains 4172 hashed buffs 5000 total buffs
图: onstat -rFh 命令输出
onstat -rFh Fg Writes LRU Writes Chunk Writes 0 0 21 address flusher state data # LRU Chunk Wakeups Idle Tim 460e6820 0 I 0 0 2 5 9.820 states: Exit Idle Chunk Lru Buffer pool page size: 2048 buffer hash chain length histogram # of chains of len 6342 0 1850 1 8192 total chains 1850 hashed buffs 5000 total buffs Fg Writes LRU Writes Chunk Writes 0 0 21 address flusher state data # LRU Chunk Wakeups Idle Tim 460e6820 0 I 0 0 2 10 22.755 states: Exit Idle Chunk Lru Buffer pool page size: 2048 buffer hash chain length histogram # of chains of len 4396 0 3796 1 8192 total chains 3796 hashed buffs 5000 total buffs