Tibero 세션 수 확인 및 세션 종료

- Tibero 활성화 된 세션 확인

 

select * from v$session;

19 665464 4294967295 0 SYS 10.77.160.212 0 ACTIVE 0 SYS WTHR 62 0 2019-06-18 10:54:25 THR_STAT_RECV_WAITING -1 0 612824 DISABLED QueryOneClient.exe 10680 12685 1 B DESKTOP DESKTOP QueryOne Client 2.1.6.71 NO DISABLED ENABLED ENABLED
21 702938 4294967295 0 SYS 10.77.160.212 1 RUNNING 0 SYS WTHR 64 64 0 2019-06-19 10:58:34 THR_STAT_RUNNING -1 0 775640 DISABLED QueryOneClient.exe 10896 12685 3 B DESKTOP DESKTOP QueryOne Client 2.1.6.71 NO DISABLED ENABLED ENABLED

 

- Tibero 세션 종료

ALTER SYSTEM kill SESSION (SID, SERIAL#);