From oracle-l-bounce@freelists.org Mon Oct 17 19:00:00 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9I000Jq029542 for ; Mon, 17 Oct 2005 19:00:00 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j9HNxvvX029533 for ; Mon, 17 Oct 2005 18:59:57 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E5102206D30; Mon, 17 Oct 2005 18:59:53 -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 08748-07; Mon, 17 Oct 2005 18:59:53 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6B258206D19; Mon, 17 Oct 2005 18:59:53 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=moE3hT9p1g/gxYoydkCPsyxj9Fpc2RRfNXlLycjaJbxeifE4NB3nSBpmGzYXAnnb1ADCiIGXuzizQ9YSHDM35alUUZCNkKo8sjSVF/hfcCwgzG8sp1BGx51ld5F4x07QN06YbaPGxi3u1F76HSbV3DhjSkBfYU2OKq6pW2lSvko= Message-ID: Date: Tue, 18 Oct 2005 01:57:57 +0200 From: Alex Gorbachev To: fred_fred_1@hotmail.com Subject: Re: Select any dictionary role Cc: oracle-l@freelists.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Content-Disposition: inline References: <435274F2.9040309@inter.net.il> X-archive-position: 27099 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: gorbyx@gmail.com Precedence: normal Reply-To: gorbyx@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-2.9 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.63 AFAIK and experienced, excessive access to some V$ views might cause some contention on latches. At least we experienced that in few db instances with one of our monitoring scripts. We think we hit the bug that accesing particular V$ table can lead for a long hold time of a latch. Well as V$ views are based on X$ memory structures, access to them is protected with latches. This is my understanding and that's what we've been told by Oracle support in that case. 2005/10/17, Fred Smith : > Hello all, > Just wanted to get your thoughts ... is there any "danger" to granting > developers the SELECT ANY DICTIONARY role in the database? (IMHO, they don't > particulary need such "open" access, however tools such as OEM require it > for login apparently). -- Best regards, Alex Gorbachev -- http://www.freelists.org/webpage/oracle-l