Advanced Search

Return to Snippet

Revision: 13947
at May 14, 2009 06:38 by tenkyu
Initial Code 
SELECT 'ALTER SYSTEM KILL SESSION ''' || SID || ',' || SERIAL# || ''';' KILL_SQL
     , MACHINE
     , ORACLE_USERNAME
     , OS_USER_NAME
     , LOCKED_MODE
     , OBJECT_NAME
     , OBJECT_TYPE
  FROM V$LOCKED_OBJECT A
     , DBA_OBJECTS B
     , V$SESSION C
 WHERE A.OBJECT_ID = B.OBJECT_ID
   AND A.SESSION_ID = C.SID
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Kill locked session

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
Oracle

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
PL/SQL