[收藏本方案]

利用Oracle数据库存储和分析Unix操作系统的性能[29]

[入库：2005年8月18日] [更新：2007年3月24日]

本文简介：选择自 kamus 的 blog
首页 上页 下页 尾页 [1] [2] [3] [4] [5] [6] [7] [8] [9] [10] [11] [12] [13] [14] [15] [16] [17] [18] [19] [20] [21] [22] [23] [24] [25] [26] [27] [28] [29] [30] [31] [32] [33] [34] [35] [36] [37] [38] [39] [40]

 to_char(start_date,'yy/mm/dd    hh24')
order by
 server_name,
 to_char(start_date,'yy/mm/dd    hh24')
;

ttitle 'page_scan > 1|may indicate overloaded memory|whenever unix performs a page-in, the ram memory | on the server has been exhausted and swap pages are being used.';

select
 server_name,
 to_char(start_date,'yy/mm/dd    hh24') my_date,
 avg(running_queue)     c2,
 avg(kbytes_page_in)    c3,
 avg(kbytes_page_out)   c4,
 avg(user_cpu)           c5,
 avg(system_cpu)         c6,
 avg(idle_cpu)           c7
from
perfstat.stats$vmstat
where
page_scan > 1
and start_date > sysdate-&1
group by
 server_name,
 to_char(start_date,'yy/mm/dd    hh24')
order by
 server_name,
 to_char(start_date,'yy/mm/dd    hh24')
;

ttitle 'user+system cpu > 70%|indicates periods with a fully-loaded cpu subssystem.|periods of 100% utilization are only a | concern when runqueue values exceeds the number of cps on the server.';

select
 server_name,
 to_char(start_date,'yy/mm/dd    hh24') my_date,
 avg(running_queue)     c2,

首页 上页 下页 尾页 [1] [2] [3] [4] [5] [6] [7] [8] [9] [10] [11] [12] [13] [14] [15] [16] [17] [18] [19] [20] [21] [22] [23] [24] [25] [26] [27] [28] [29] [30] [31] [32] [33] [34] [35] [36] [37] [38] [39] [40]
本文关键：利用Oracle数据库存储和分析Unix操作系统的性能
　　相关方案
Google
 

本站最佳浏览方式为 分辨率 1024x768 IE 6.0（或更高版本的 IE浏览器）

go top