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?

Other related posts: