–non RAC databases SELECT s.sid, s.serial#, p.spid Now how to kill the server process associated with the session How to monitor transaction Rollback Progress I have a another post which in talk in detail about transaction rollback. SQL> select username, status from v$session where SID=12 Generally it is not recommended to kill session from background which has lot of undo to performed SQL> ALTER SYSTEM KILL SESSION ’42,2233' If the session is not doing undo but it is stuck somewhere, you can kill the server process in the background to clear the session.Īs such we can kill the background session in case of Undo also, it will still take time to clear the undo but in fast manner. Once the undo is over, it will be killed itself. ![]() If the command is not able to kill the session as it has to undo lot of transaction, it will return as Marked for Killed. We generally used this command when we want to clear session which is inactive and holding locks, long running session This command comes handy when you want to kill multiple session from multiple instance ALTER SYSTEM KILL SESSION 'SID, SERIAL#, instance_id is the instance where that session is running.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |