ORACLE创建独立用户用于查询锁表、阻塞，查杀会话

1、创建用户

create user kill_user identified by kill_user account unlock;

2、连接权限

grant connect to kill_user;

3、相关试图权限

grant select on DBA_OBJECTS to kill_user;
grant select on GV_$LOCKED_OBJECT to kill_user;
grant select on GV_$SESSION to kill_user;
grant select on GV_$SQLAREA to kill_user;
grant select on GV_$PROCESS to kill_user;
grant select on GV_$LOCK to kill_user;
grant select on V_$ACCESS to kill_user;
grant select on V_$DATABASE to kill_user;
grant select on V_$SESSION to kill_user;
grant select on V_$SESSTAT to kill_user;
grant select on V_$SQL to kill_user;
grant select on V_$STATNAME to kill_user;
....

4、查杀会话权限

grant alter system to kill_user;