From oracle-l-bounce@freelists.org Wed Mar 31 18:56:41 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i310ufh18763 for ; Wed, 31 Mar 2004 18:56:41 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i310uco18754 for ; Wed, 31 Mar 2004 18:56:39 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 90FDB635B09; Wed, 31 Mar 2004 19:52:46 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 30364-89; Wed, 31 Mar 2004 19:52:46 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 84298635AD2; Wed, 31 Mar 2004 19:52:34 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 31 Mar 2004 19:51:22 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 43507635860 for ; Wed, 31 Mar 2004 19:51:22 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 30196-57 for ; Wed, 31 Mar 2004 19:51:22 -0500 (EST) Received: from maillnx-us311.fmr.com (maillnx-us311.fmr.com [192.223.178.26]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 838476356BB for ; Wed, 31 Mar 2004 19:51:21 -0500 (EST) Received: from virmro111nts.fmr.com (virmro111nts.fmr.com [172.26.5.99]) by maillnx-us311.fmr.com (Switch-3.1.2/Switch-3.1.0) with SMTP id i310xeNS009792 for ; Wed, 31 Mar 2004 19:59:41 -0500 Received: from MSGBOSCLD2WIN.dmn1.fmr.com ([10.46.17.17]) by MSGMROIM01WIN.DMN1.FMR.COM with Microsoft SMTPSVC(5.0.2195.5329); Wed, 31 Mar 2004 19:59:40 -0500 X-MimeOLE: Produced By Microsoft Exchange V6.0.6521.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPartTM-000-63f5cc20-dc92-4f79-9733-0a7e1702763a" Subject: RE: problem dropping synonyms Date: Wed, 31 Mar 2004 19:59:39 -0500 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: problem dropping synonyms Thread-Index: AcQXforN391bq0lkQxyqjShb3m8saQABgOMA From: "Khedr, Waleed" To: X-OriginalArrivalTime: 01 Apr 2004 00:59:40.0254 (UTC) FILETIME=[9C88A7E0:01C41784] X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 2244 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Waleed.Khedr@FMR.COM Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org ------=_NextPartTM-000-63f5cc20-dc92-4f79-9733-0a7e1702763a Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C41784.9C449DC2" ------_=_NextPart_001_01C41784.9C449DC2 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable What is in v$session_wait? library cache pin/lock? =20 Waleed -----Original Message----- From: Ryan [mailto:ryan.gaffuri@cox.net] Sent: Wednesday, March 31, 2004 7:17 PM To: oracle-l@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?=20 ------_=_NextPart_001_01C41784.9C449DC2 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
What=20 is in v$session_wait? library cache pin/lock?
 
Waleed
-----Original Message-----
From: Ryan=20 [mailto:ryan.gaffuri@cox.net]
Sent: Wednesday, March 31, = 2004 7:17=20 PM
To: oracle-l@freelists.org
Subject: problem = dropping=20 synonyms

I am attempting to drop a synonym and = it hangs.=20 This tells me the synonym is locked. I check v$access and it's not = being used.=20 I also checked v$lock. Anywhere else to look?=20
------_=_NextPart_001_01C41784.9C449DC2-- ------=_NextPartTM-000-63f5cc20-dc92-4f79-9733-0a7e1702763a-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@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 -----------------------------------------------------------------