查詢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;