OCM 11g 考试通过 + OU Guru Week 巡讲顺利结束

最新推荐文章于 2019-10-26 10:36:48 发布

conglou7547

最新推荐文章于 2019-10-26 10:36:48 发布

阅读量99

点赞数

Go to My Oracle Blog

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
/