检查用户的当前操作

select a.sid,a.username,s.SQL_TEXT 
 from v$session a, v$sqltext s
where a.SQL_ADDRESS=s.ADDRESS
  and a.SQL_HASH_VALUE=s.HASH_VALUE

以上sql显示了目前每一个会话正在执行的SQL语句 

 select a.USERNAME,
       a.USER#,
       b.BLOCK_GETS,
       b.CONSISTENT_GETS,
       b.PHYSICAL_READS,
       b.BLOCK_CHANGES,
       b.CONSISTENT_CHANGES
  from v$session a, v$sess_io b
 where a.SID = b.SID;

以上语句显示了每个会话的物理磁盘命中率和内存命中率

  select a.USERNAME, c.NAME, sum(b.VALUE) value
   from v$session a, v$sesstat b, v$statname c
  where a.sid = b.sid
    and b.STATISTIC# = c.STATISTIC#
    and b.VALUE <> 0
  group by name, username

以上语句获得详细的用户信息

select a.SID, a.USERNAME, b.OWNER, b.OBJECT, b.TYPE
  from v$session a, v$access b   where a.SID = b.sid;   

以上语句得到正在访问的对象