[ORACLE]ORACLE V$SESSION 설명

ORACLE V$SESSION 설명

• 오라클 session 중 active 된 후 오래걸리는 애들 체크

select  SID, USERNAME, COMMAND, STATUS,LAST_CALL_ET, SCHEMANAME, MACHINE, TERMINAL, PROGRAM

       ,SQL_ADDRESS, SQL_HASH_VALUE, SQL_ID, STATE, SERVICE_NAME

from v$session

where STATUS = 'ACTIVE'

and COMMAND <> 0

order by LAST_CALL_ET desc

;

• COMMAND : 명령 수행 종류(http://redkite777.tistory.com/entry/%EC%98%A4%EB%9D%BC%ED%81%B4Vsession-Command-%EC%BB%AC%EB%9F%BC%EC%9D%98-%EC%BD%94%EB%93%9C%ED%91%9C)
• LAST_CALL_ET : 소요시간

참고 url

http://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_2088.htm#REFRN30223

http://redkite777.tistory.com/entry/%EC%98%A4%EB%9D%BC%ED%81%B4Vsession-Command-%EC%BB%AC%EB%9F%BC%EC%9D%98-%EC%BD%94%EB%93%9C%ED%91%9C