压测监控指标命令（Linux）与SQL语句

数据库查询

----连接数
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