查看Oracle最耗性能SQL以及查看锁表进程SQL语句1和杀掉锁表进程

查看Oracle最耗性能SQL
SELECT *
  FROM (SELECT PARSING_USER_ID, EXECUTIONS, DISK_READS, SQL_TEXT
          FROM V$SQLAREA
         ORDER BY DISK_READS DESC)
 WHERE ROWNUM <= 10 AND SQL_TEXT NOT LIKE 'DECLARE job%' AND SQL_TEXT NOT LIKE 'BEGIN PROC%';

查看锁表进程SQL语句1
SELECT SESS.SID || ',' || SESS.SERIAL# AS SESSION_ID,
       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
 ORDER BY LO.OS_USER_NAME;

杀掉锁表进程：
alter system kill session 'SESSION_ID';