摘要:
查看 哪些表 被锁了 SELECT object_name, machine, s.sid, s.serial FROM gv$locked_object l, dba_objects o, gv$session s WHERE l.object_id = o.object_id AND l.ses 阅读全文
摘要:
1. select r.FIRST_LOAD_TIME,r. from v$sqlarea r order by r.FIRST_LOAD_TIME desc ; 查看某时间段内执行的语句 2. create table t_table_recove 新表 as select from table1 阅读全文