alter system权限以DBA身份登录,赋权: conn sys/password as sysdba grant alter system to user;
试试 grant alter system to user
grant alter system to username; alter system kill session 'sid,serial#';
1.先查出session_id和serial# select a.session_id,b.serial#,a.owner,a.name, a.mode_held,b.osuser, b.logon_time,b.terminal,b.status from dba_dml_locks a, v$session b where a.session_id=b.sid order by 2,3;2.再kill alter system kill session 'session_id,serial#'; 如:alter system kill session '280,26501';
conn sys/password as sysdba
grant alter system to user;
试试
grant alter system to user
alter system kill session 'sid,serial#';
select a.session_id,b.serial#,a.owner,a.name,
a.mode_held,b.osuser,
b.logon_time,b.terminal,b.status
from dba_dml_locks a,
v$session b
where a.session_id=b.sid
order by 2,3;2.再kill
alter system kill session 'session_id,serial#';
如:alter system kill session '280,26501';