AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Dynamic sql to kill session oracle rac12/31/2022 ![]() ![]() Is there > a script you can provide me that will loop thru all session and get SIDs and > Serial# of the sessions to be kill? > Thanks Thanks to abdul khabeer khayyam mohammed and all Date: Mon, 06:21:05 +0000 From: Subject: Re: Dynamic SQL to kill loop thru sessions to kill To: Toolbox oracle-db-l try, >spool A.sql >select 'alter system kill session '||sid||','||session#||' immediate ' from v$session where username not in ('SYS') >spool off Regards, Khayyam "milber.ch via oracle-db-l" wrote: SELECT s.sid, s.username, s.schemaname, s.terminal, s.status, s.serial#, s.osuser, s.program FROM v$session s you should write a script whit a loop and to use: ALTER SYSTEM KILL SESSION 'SID,SERIAL#' IMMEDIATE 7 arsenelupain via oracle-db-l : > Hi > I have about 580 sessions to kill and database cannot be shutdown. ![]() Select 'alter system kill session '||sid||','||serial#||' immediate ' from v$session Īlter system kill session 552,1 immediate Īlter system kill session 553,1 immediate Īlter system kill session 554,1 immediate Īlter system kill session 555,1 immediate Īlter system kill session '552,1' immediate Īlter system kill session '553,1' immediate Īlter system kill session '554,1' immediate Īlter system kill session '555,1' immediate įrom: RE: Dynamic SQL to kill loop thru sessions to killDate: Wed, 16:59:46 +0000 How can I manipulate this dynamic session to have 'sid,serial#' in the quote ![]()
0 Comments
Read More
Leave a Reply. |