1.oracle误删除数据的恢复方法 

2.查询被锁住的表，解锁

--找到当前被锁住的表 select sess.sid,        sess.serial#,        lo.oracle_username,        lo.os_user_name,        ao.object_name,        lo.locked_mode        from v$locked_object lo,        dba_objects ao,        v$session sess    where ao.object_id = lo.object_id and lo.session_id = sess.sid;  --解锁   alter system kill session   'sid,serial#' alter system kill session '37,3307'; （即查询到的sid和serial）

3.树形结构查询