磁碟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/