数据库查询
----连接数
select count(1) 连接数 from V$SESSIONS ;
------活动会话数
select count(*) 活动会话 from v$sessions Where "V$SESSIONS".STATE='ACTIVE';
---Select * from V$DEADLOCK_HISTORY;
--buffer命中率
SELECT NAME,N_PAGES,N_LOGIC_READS,RAT_HIT FROM V$BUFFERPOOL;
---mermory pool
select ORG_SIZE/1024/1024 初始大小MB,total_size/1024/1024 当前总大小MB from V$mem_pool Where "V$MEM_POOL".NAME like '%SHARE%';
--BUFFERPOOL
select 'BUFFER' || rownum POOL,
N_PAGES * 8 / 1024 M_SIZE,
N_LOGIC_READS,
N_DISCARD,
N_PHY_READS,
trunc(RAT_HIT*100,4) HIT_RATIO
from v$bufferpool
where NAME='NORMAL'
union all
select 'SUM' ,
sum(N_PAGES) * 8 / 1024,
sum(N_LOGIC_READS),
sum(N_DISCARD),
sum(N_PHY_READS),
trunc(sum(N_LOGIC_READS) * 100.0/(sum(N_LOGIC_READS)+sum(N_PHY_READS)),4)
from v$bufferpool
where NAME='NORMAL'
Linux系统查询
打开文件数量:
lsof -u dmdba|wc –l
打开进程数量:
ps -aux|grep -v 'dmserver'|wc –l
cpu与内存
top