第1步：确定安装ID&用户ID.

SELECT inst_id,sid FROM gv$session WHERE username='<ENTER-USERNAME>';

第2步：

SELECT 
      s.sid,s.CLIENT_INFO,s.MACHINE,s.PROGRAM,s.TYPE,s.logon_time,s.osuser,sq.sorts,sq.DISK_READS,sq.BUFFER_GETS,sq.ROWS_PROCESSED,sq.sqlTYPE,sq.sql_TEXT
 FROM gv$session s,gv$sql sq
WHERE s.sql_HASH_VALUE = sq.HASH_VALUE
  AND s.inst_id = :inst_id -- replace with instID from above
  AND s.sid = :sid -- replace with ID from above
  AND sq.inst_id = s.inst_id

可能有多个Ids&实例Ids返回.因此,用户可以选择如何在Web界面中使用这些数据等.