- 最后登录
- 2023-8-16
- 在线时间
- 1686 小时
- 威望
- 2135
- 金钱
- 50532
- 注册时间
- 2011-10-12
- 阅读权限
- 200
- 帖子
- 5207
- 精华
- 39
- 积分
- 2135
- UID
- 2
|
10#
发表于 2013-10-11 11:53:47
不了峰 发表于 2013-10-11 11:21
请问刘大 gcs msgs received', 'ges msgs received' 这两个指标 为何在dba_hist_s ...
FYI
SELECT
DECODE(name,'gc cr blocks received','global cache blocks received','gc cr blocks served','global cache blocks served','gc current blocks received','global cache blocks received','gc current blocks served','global cache blocks served',name) AS name,
SUM(VALUE) AS VALUE,
TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss') AS date_taken
FROM gv$sysstat
WHERE inst_id=1
AND name IN ('gc cr blocks received','gc cr blocks served','gc current blocks received','gc current blocks served','gcs messages sent','ges messages sent')
GROUP BY DECODE(name,'gc cr blocks received','global cache blocks received','gc cr blocks served','global cache blocks served','gc current blocks received','global cache blocks received','gc current blocks served','global cache blocks served',name)
UNION
SELECT name,VALUE,TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss') AS date_taken
FROM gv$dlm_misc
WHERE name IN ('gcs msgs received','ges msgs received')
AND inst_id=1;
|
|