How to kill session for SQL ID in Oracle database? Sample scripts to kill SQL ID in oracle database
AB Answered question 06/10/2022
Below is the sample scripts to kill session for SQL_ID in oracle database.
1 2 3 4 5 6 7 8 | --- For single instance database SELECT 'alter system kill session ' '' || SID || ',' || SERIAL# || '' ' immediate ;' FROM v$session WHERE sql_id = '&sql_id' ; --- For RAC database SELECT 'alter system kill session ' '' || SID|| ',' || SERIAL#|| ',@' || inst_id|| '' ' immediate ;' FROM gv$session WHERE sql_id = '&sql_id' |
meda Changed status to publish 06/10/2022