linux
加粗样式
查网络,IO,CPU
dstat -tnrcmd
数据库监控:
/opt/oracle.ahf/tfa/ext/oratop/oratop.RDBMS_11.2_LINUX.X64 ‘/ as sysdba’ -i 2 -d
iotop
数据库
SET SERVEROUTPUT ON
DECLARE
lat INTEGER;
iops INTEGER;
mbps INTEGER;
BEGIN
– DBMS_RESOURCE_MANAGER.CALIBRATE_IO (, <MAX_LATENCY>, iops, mbps, lat);
DBMS_RESOURCE_MANAGER.CALIBRATE_IO (1, 100, iops, mbps, lat);
DBMS_OUTPUT.PUT_LINE ('max_iops = ’ || iops);
DBMS_OUTPUT.PUT_LINE ('latency = ’ || lat);
DBMS_OUTPUT.PUT_LINE ('max_mbps = ’ || mbps);
end;
/