Oracle kill session script4/1/2024 Using below commands we are able to discover spid and kill a INACTIVE session: SQL> Set lines 400 pages 400 We will killed a session at OS Level using spid. SQL> alter system kill session '564,279' immediate SQL> select 'alter system kill session '''||sid||','||serial#||''' immediate ' from v$session where status='KILLED' Īlter system kill session '564,279' immediate Īlter system kill session '683,6167' immediate Īlter system kill session '1044,7191' immediate SQL> select USERNAME, SID, SERIAL#, STATUS, SQL_ID from v$session where status='KILLED' Using below commands we are able to be told and kill a KILLED session: SQL> alter system kill session '12,19428' immediate 'ALTERSYSTEMKILLSESSION'''||SID||','||SERIAL#||'''IMMEDIATE 'Īlter system kill session '12,19428' immediate Īlter system kill session '13,31126' immediate Īlter system kill session '15,53334' immediate Īlter system kill session '17,50020' immediate SQL> select 'alter system kill session '''||sid||','||serial#||''' immediate ' from v$session where status='INACTIVE' SQL> select USERNAME, SID, SERIAL#, STATUS, SQL_ID from v$session where status='INACTIVE' Using below commands we will be told and kill a INACTIVE session: SQL> set lines 400 pages 400 We will kill a session at Database Level using sid and serial#.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |