Advanced Search

Return to Snippet

Revision: 16494
at August 6, 2009 06:10 by kamilch
Initial Code 
declare
    host_name varchar2(128) = 'hostname';
    
    cursor host_sessions is select '' || sid || '' || serial# as session_id
                from v$session where machine = host_name order by sid desc;
begin
    for next_row in host_sessions
    loop
        execute immediate 'alter system kill session :1 immediate'
                           using next_row.session_id;
    end loop;
end;
/
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Kill all sessions from host in Oracle

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
Oracle

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
PL/SQL