mysql锁历史记录_查看oracle的sql语句历史记录和锁表的情况

查询sql的历史记录

select * from v$sqlarea t where t.PARSING_SCHEMA_NAME in ('用户名')

order by t.LAST_ACTIVE_TIME desc

select * from v$sqlarea t order by t.LAST_ACTIVE_TIME desc

查看一段时间内的执行情况

select * from v$sqlarea t where (

to_char(t.LAST_ACTIVE_TIME,'yyyy-mm-dd hh24:mi:ss')

> '2011-12-28 14:11:39' ) and

(to_char(t.LAST_ACTIVE_TIME,'yyyy-mm-dd hh24:mi:ss')

< '2011-12-28 14:11:43') order by t.LAST_ACTIVE_TIME

desc

查询当前时间

select sysdate from dual

查询锁表的情况

select * from v$locked_object;

select

b.owner,b.object_name,a.session_id,a.locked_mode from v$locked_object a,dba_objects

b where b.object_id =

a.object_id;

select

b.username,b.sid,b.serial#,logon_time from v$locked_object a,v$session

b where a.session_id = b.sid

order by b.logon_time;