Search Database SQL / Scripts


  Help us in improving the repository. Add new Queries/Scripts through 'Submit Database SQL / Scripts ' link.





Database Queries/Scripts

 Sample 1. Oracle - Get all locked Database Objects

SELECT allObj.Owner, allObj.Object_Name, locObj.Oracle_Username, locObj.OS_User_Name  
FROM V$Locked_Object locObj, All_Objects allObj
WHERE locObj.Object_ID = allObj.Object_ID

   Like      Feedback     locked database objects  Locked_Object  All_Objects



Subscribe to Java News and Posts. Get latest updates and posts on Java from Buggybread.com
Enter your email address:
Delivered by FeedBurner