获取某时间段内的top session_id+session_serial# set linesize 260 pagesize 10000 col nvl(event,'ON CPU') for a40 select * from (select session_id,session_serial#,sql_id,nvl(event,'ON CPU'),count(*)
获取活动会话最多的sample_time v$active_session_history视图去挖掘信息 set linesize 260 pagesize 1000 alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss'; select * from ( select inst_id,sample_time,sample_id,coun
CPU used by this session:所有session的cpu占用量,不包括后台进程。 DB block changes:那部分造成SGA中数据块变化的insert,update或delete操作数,这项统计可以大概看出整体数据库状态。 Execute count:执行的sql语句数量(包括递归sql) Logons current:当前连接到实例的Sessions。 Logons
1、监控等待事件select event,sum(decode(wait_time,0,0,1)) prev, sum(decode(wait_time,0,1,0)) curr,count(*)from v$session_waitgroup by event order by 4; Lock wait occur when a session attempts to acquire a loc