Advanced Search

Return to Snippet

Revision: 64410
at August 6, 2013 02:51 by ceduard0
Initial Code 
select o.OBJECT_NAME, l.SESSION_ID, l.ORACLE_USERNAME, l.OS_USER_NAME, l.PROCESS
  from V$LOCKED_OBJECT l, USER_OBJECTS o
where o.OBJECT_ID = l.OBJECT_ID;
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
List locked object Oracle Database using V$LOCKED_OBJECT view

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
List locked object Oracle Database

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
object, Oracle

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL