When I found the session that still holding in the database, and I checked that is not the user's working session, so I try to kill the session by command.
alter system kill session 'SID,SERIAL#' [immediate];
if you killed by 'alter session kill session' but they still in the oracle ,
so I have the other way to kill it in os session.
kill -9 SPID
== TaTsHuYa ==
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment