What is in v$session_wait? library cache pin/lock? Waleed -----Original Message----- From: Ryan [mailto:ryan.gaffuri@xxxxxxx] Sent: Wednesday, March 31, 2004 7:17 PM To: oracle-l@xxxxxxxxxxxxx Subject: problem dropping synonyms I am attempting to drop a synonym and it hangs. This tells me the synonym is locked. I check v$access and it's not being used. I also checked v$lock. Anywhere else to look?