11g OCM的升级考试比较刺激，需要多准备一下的。
巡讲结束了，又有时间回到“正常”的工作中来=）
[@more@]
为了不让此更完全心情化，附上常用的的ASH脚本一个，11g以前是用case实现的，发现11g之后能用pivot，杀掉不少字符。用途么不用多 解释的，凡是使用过Enterprise Manager的活动会话数（Avg Active Session Count）工具的人都懂的。
-- 数据库版本至少为11g
set echo off
set verify off
alter session set
nls_date_format='HH24:MI';
select * from
(select
nvl(wait_class,'CPU') activity,
trunc(sample_time,'MI') time
from
v$active_session_history
) v
pivot (
count(*)
for
activity in (
'CPU' as "CPU",
'Concurrency' as
"Concurrency",
'System I/O' as "System I/O",
'User
I/O' as "User I/O",
'Administrative' as "Administrative",
'Configuration' as "Configuration",
'Application' as
"Application",
'Network' as "Network",
'Commit' as
"Commit",
'Scheduler' as "Scheduler",
'Cluster'
as "Cluster",
'Queueing' as "Queueing",
'Other' as
"Other"
)
)
where time > sysdate - interval
'&last_min' minute
order by time
/
Todd
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/22966231/viewspace-1033668/ ，如需转载，请注明出处，否则将追究法律责任。
