I have created a table lock(TM)situation on my DB and ran a script to identify the SID,lock mode, and username. I can easily kill one of the sessions with OEM but need the SQL syntax to do the same from SQL*PLUS linemode.
Printable View
I have created a table lock(TM)situation on my DB and ran a script to identify the SID,lock mode, and username. I can easily kill one of the sessions with OEM but need the SQL syntax to do the same from SQL*PLUS linemode.
select username, sid, serial# from v$session
where sid > 6;
alter system kill session 'sid,serial#';
(where sid and serial# are from v$session query, and use single quotation marks around sid,serial#)
Thank you!