磁盤IOPS概念及IOPS的計算與測試

磁盤IOPS概念及IOPS的計算與測試

http://ce.sysu.edu.cn/hope/Item.aspx?id=12630

echo "The SYSTEM Metric of the last $start days to $end days:"

sqlplus -s "/ as sysdba" << !|grep -v "Session altered"

set lines 180

set pages 70

alter session set nls_date_format='mm-dd hh24:mi:ss';

col PhyRead_Total_MBps  heading "PhyR|MBps" format 999.99

col PhyWrite_Total_MBps heading "PhyW|MBps" format 999.99

col Redo_MBps          heading "Redo|MBps" format 99.99

col PhyRead_IOPS       heading "PhyR|IOPS" format 9999999.99

col Phywrite_IOPS      heading "PhyW|IOPS" format 9999999.99

col PhyWrite_redo_IOPS heading "Redo|IOPS" format 9999999.99

col OS_Load            heading "Load"  format 99.99

col DB_CPU_Usage_per_sec heading "DB CPU|cs/s" format 999.99

col Host_CPU_util      heading "CPU|%" format 99.99

col Network_Mbps       heading "Network|Mbps" format 999.99         

col HP_PS              heading "HP|PS" format 99.99

col Logons_PS          heading "Log|PS" format 99.99

col Enqueue_waits_PS   heading "Enq|PS" format 99.99

select max(end_time) time,

       trunc(sum(case metric_name when 'Physical Read Total Bytes Per Sec' then average end)/1024/1024,2) PhyRead_Total_MBps,

       trunc(sum(case metric_name when 'Physical Write Total Bytes Per Sec' then average end)/1024/1024,2) PhyWrite_Total_MBps,

       trunc(sum(case metric_name when 'Redo Generated Per Sec' then average end)/1024/1024,2) Redo_MBps,

       trunc(sum(case metric_name when 'Physical Read Total IO Requests Per Sec' then average end),2) PhyRead_IOPS,

       trunc(sum(case metric_name when 'Physical Write Total IO Requests Per Sec' then average end),2) Phywrite_IOPS,

       trunc(sum(case metric_name when 'Redo Writes Per Sec' then average end),2) PhyWrite_redo_IOPS,

       trunc(sum(case metric_name when 'Hard Parse Count Per Sec' then average end),2) HP_PS,

       trunc(sum(case metric_name when 'Current OS Load' then average end),2) OS_Load,

       trunc(sum(case metric_name when 'Logons Per Sec' then average end),2) Logons_PS,

       trunc(sum(case metric_name when 'CPU Usage Per Sec' then average end),2) DB_CPU_Usage_per_sec, 

       trunc(sum(case metric_name when 'Host CPU Utilization (%)' then average end),2) Host_CPU_util, 

       trunc(sum(case metric_name when 'Network Traffic Volume Per Sec' then average end)/1024/1024,2) Network_Mbps,

       trunc(sum(case metric_name when 'Enqueue Waits Per Sec' then average end),2) Enqueue_waits_PS

from dba_hist_sysmetric_summary

where end_time>=sysdate -$start

and   end_time<=sysdate -$end

group by snap_id

order by snap_id;

http://www.itpub.net/thread-1224372-1-1.html

oracle iops與mbps小記

http://blog.itpub.net/9240380/viewspace-758994/