Posted on 2010-10-19 13:33
瘋狂 閱讀(207)
評論(0) 編輯 收藏 所屬分類:
database
查詢字符編碼
select userenv('language') from dual;
查看被鎖定的對象：
select *
from v$locked_object l,dba_objects o ,v$session s
where l.object_id = o.object_id and l.session_id=s.sid;
查詢共享游標的sql語句：
select sql_id ，sql_text,executions from v$sqlarea where sql_text like '';
數據庫閃回
alter table nt2_agent enable row movement;
FLASHBACK TABLE nt2_agent TO TIMESTAMP TIMESTAMP'2010-12-21 09:00:00'