/* 透過作業系統pid查詢正在執行SQL指令*/

SELECT * FROM v$sql SQLINFO where SQLINFO.SQL_ID =

(SELECT SEN.SQL_ID FROM v$session SEN WHERE SEN.PADDR =

(SELECT PRO.ADDR FROM v$process PRO WHERE PRO.SPID = 25832));

/* 查詢等待佇列比較大的SQL*/

SELECT * FROM v$sql SQLINFO WHERE SQLINFO.SQL_ID =

(SELECT LONGWAIT.SQL_ID FROM v$session_longops LONGWAIT WHERE LONGWAIT.TIME_REMAINING>0);

透過作業系統PID查詢執行的SQL

相關文章