RE: problem dropping synonyms

Look for v$session_wait.event

-----Original Message-----
From: Ryan [mailto:ryan.gaffuri@xxxxxxx]
Sent: Wednesday, March 31, 2004 8:07 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: problem dropping synonyms


what do look for in those views? 

----- Original Message ----- 
From: Khedr,  <mailto:Waleed.Khedr@xxxxxxx> 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: