Re: problem dropping synonyms

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?

Other related posts: