一.
select a.EVENT, a.SQL_ID, a.MACHINE, b.SQL_TEXT, b.SQL_FULLTEXT,b.FIRST_LOAD_TIME,b.LAST_LOAD_TIME,b.LAST_ACTIVE_TIME
from v$session a, v$sql b
where a.SQL_ID = b.SQL_ID
and a.USERNAME is not null
and a.STATUS = 'ACTIVE'
二. select parsing_user_id,executions,sorts,command_type,disk_reads,sql_text
from v$sqlarea
order by disk_reads desc
三.
select * from V$session where username='VACCUSER'
select * from v$locked_object