1,查看某一时间的执行过的所有sql
select t.SQL_TEXT, t.FIRST_LOAD_TIME
from v$sqlarea t
where t.FIRST_LOAD_TIME like '2019-01-28%'
order by t.FIRST_LOAD_TIME desc
# : 2019-01-28% 为哪一时间的操作记录;
2,查询当前执行sql的机器信息
SELECT SID, OSUSER, USERNAME, MACHINE, PROCESS FROM V$SESSION WHERE audsid = userenv( 'SESSIONID' );
3,查询执行某一时间,某台机器,执行的sql
a)select b.sql_text,a.osuser,a.sid,a.machine from v$session a ,v$sqlarea b where a.sql_hash_value = b.hash_value ;
b) select b.sql_text,a.osuser,a.sid,a.machine ,b.first_load_time from v$session a ,v$sqlarea b where a.sql_hash_value = b.hash_value and b.first_load_time like '2019-01-29%' order by b.first_load_time desc ;
c) SELECT b.sid oracleID, b.username Oracle用户, b.serial#, spid 操作系统ID, paddr, sql_text 正在执行的SQL, b.machine 计算机名 FROM v$process a, v$session b, v$sqlarea c WHERE a.addr = b.paddr AND b.sql_hash_value = c.hash_value;