Re: problem dropping synonyms

From: Ryan <ryan.gaffuri_at_cox.net>
Date: Wed, 31 Mar 2004 20:07:06 -0500
Message-ID: <4eda01c41785$a6926e00$51a36244@ryan2le36ofjce>

what do look for in those views?

• Original Message ----- From: Khedr, Waleed To: oracle-l_at_freelists.org 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_at_cox.net]     Sent: Wednesday, March 31, 2004 7:17 PM     To: oracle-l_at_freelists.org
    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?

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Wed Mar 31 2004 - 19:01:18 CST