[SQL] 처리중인 SQL 쿼리문 진행 상황 확인

SELECT A.MESSAGE
	 , A.START_TIME
	 , A.LAST_UPDATE_TIME
	 , A.TIME_REMAINING
	 , ROUND((SOFAR/TOTALWORK)*100,0)||'%' AS PROGESS
	 , B.SQL_TEXT
FROM V$SESSION_LONGOPS A, V$SQL B
WHERE A.SQL_ADDRESS=B.ADDRESS
--AND ROWNUM<=10
AND A.TIME_REMAINING>0;

| 참고 url

https://self-interest.tistory.com/entry/%EC%98%A4%EB%9D%BC%ED%81%B4%EC%97%90%EC%84%9C-%EC%B2%98%EB%A6%AC%EC%A4%91%EC%9D%B8-SQL-%EC%BF%BC%EB%A6%AC%EB%AC%B8-%EC%A7%84%ED%96%89%EC%83%81%ED%99%A9-%ED%99%95%EC%9D%B8

오라클에서 처리중인 SQL 쿼리문 진행상황 확인