oracle 锁表

select s.username,
       l.object_Id,
       l.session_id,
       s.serial#,
       l.oracle_username,
       l.os_user_name,
       l.process
  from v$locked_object l, v$session s
 where l.session_id = s.sid;

select s.username,
       l.object_Id,
       l.session_id,
       s.serial#,
       s.lockwait,
       s.status,
       s.machine,
       s.PROGRAM
  from v$locked_object l, v$session s
 where l.session_id = s.sid;

select sql_text
  from v$sql
 where hash_value in
       (select sql_hash_value
          from v$session
         where sid in (select session_id from v$locked_object));

select l.session_id sid,
       s.serial#,
       l.locked_mode,
       l.oracle_username,
       s.user#,
       l.os_user_name,
       s.machine,
       s.terminal,
       a.sql_text,
       a.action
  from v$sqlarea a, v$session s, v$locked_object l
 where l.session_id = s.sid
   and s.prev_sql_addr = a.address
 order by sid, s.serial#;

# 解锁
alter system kill session '385,2853';





  
  -- session
  select distinct s.SID,
                s.SERIAL#,
                q.SQL_TEXT,
                s.SQL_ID,
                s.USERNAME,
                --q.SQL_FULLTEXT,
                s.EVENT,
                s.WAIT_CLASS,
                s.ROW_WAIT_OBJ#,
                s.SECONDS_IN_WAIT,
                s.wait_time
  from v$session s
  left join v$sql q
    on s.SQL_ID = q.SQL_ID
 where s.STATUS = 'ACTIVE'
 and s.USERNAME is not null
order by s.SID, s.SERIAL#;


select dbms_sqltune.report_sql_monitor(sql_id => '',report_level => 'all',type => 'html') from dual;

  
  -- 表分析
  ANALYZE TABLE SeikyuTbl COMPUTE Statistics FOR TABLE FOR ALL COLUMNS FOR ALL INDEXES ;