what do look for in those views? ----- Original Message ----- From: Khedr, Waleed To: oracle-l@xxxxxxxxxxxxx Sent: Wednesday, March 31, 2004 7:59 PM Subject: RE: problem dropping synonyms 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?