查看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;