查询:
select SESS_ID,SQL_TEXT from v$sessions where STATE = 'ACTIVE';
结束:
sp_close_session('140695483797448');
拼接结束进程语句;
select concat('sp_close_session(',SESS_ID,');') from v$sessions where STATE = 'ACTIVE';
查询:
select SESS_ID,SQL_TEXT from v$sessions where STATE = 'ACTIVE';
结束:
sp_close_session('140695483797448');
拼接结束进程语句;
select concat('sp_close_session(',SESS_ID,');') from v$sessions where STATE = 'ACTIVE';