1.select * from v$session where username=drop_user_name 如果有则 2.alter system kill session 'C.sid,C.serial#' 3.drop user drop_user_name
1. alter system kill session 2. Oracle自带的orakill,可以同时释放使用的资源Usage: orakill sid thread where sid = the Oracle instance to target thread = the thread id of the thread to kill The thread id should be retrieved from the spid column of a query such as: select spid, osuser, s.program from v$process p, v$session s where p.addr=s.paddr
where username=drop_user_name
如果有则
2.alter system kill session 'C.sid,C.serial#'
3.drop user drop_user_name
2. Oracle自带的orakill,可以同时释放使用的资源Usage: orakill sid thread where sid = the Oracle instance to target
thread = the thread id of the thread to kill The thread id should be retrieved from the spid column of a query such as: select spid, osuser, s.program from
v$process p, v$session s where p.addr=s.paddr