From oracle-l-bounce@freelists.org Thu Jul 7 12:50:30 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j67HoU2p032167 for ; Thu, 7 Jul 2005 12:50:30 -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 j67HoTIP032157 for ; Thu, 7 Jul 2005 12:50:29 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C35421C9F54; Thu, 7 Jul 2005 12:50:21 -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 15885-08; Thu, 7 Jul 2005 12:50:21 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 490371C9C2D; Thu, 7 Jul 2005 12:50:21 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=srXZyvniYTrTLdGbGNR69HXum0Ioj8FVDRIn1DUVsGHfcz26+9O7i44Xm9hDwBzzJFnJhZ3KR1y1VyRiu4koDA9xBuLKZxuACHLlLU3ktmVddz+JQ0lkQe4kvDo5uHSG4VkzSrnNS1qYhrX7XpmJdw3tYHLPkh3qAPmS5vMszCo= Message-ID: Date: Thu, 7 Jul 2005 12:48:35 -0500 From: Dennis Williams To: "Goulet, Dick" Subject: Re: VPD vs multiple schems vs multiple instance Cc: "Mercadante, Thomas F (LABOR)" , dubey.sandeep@gmail.com, oracle-l@freelists.org In-Reply-To: <4001DEAF7DF9BD498B58B45051FBEA6502A520D3@25exch1.vicorpower.vicr.com> 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: <4001DEAF7DF9BD498B58B45051FBEA6502A520D3@25exch1.vicorpower.vicr.com> X-archive-position: 22199 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: oracledba.williams@gmail.com Precedence: normal Reply-To: oracledba.williams@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-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-3.9 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.63 Dick Well, I think we at least agree that this is a critical decision, and best approached carefully. Often you are stuck with the consequences of this decision for years. The best answer may depend on your organization and the application. Oh, I forgot another critical issue. If your manager doesn't understand the work of a DBA, he/she may start looking at the ratio of instances per DBA. We all know that is bogus, but sometimes that is important to the person who controls your paycheck and career. Welcome to Dilbert's world. Before that, I used to try to put several applications/user groups into a single instance. After that, separate instances started looking more attractive. ;-) Dennis On 7/7/05, Goulet, Dick wrote: > Tom, > > Well your quite right, we agree to disagree. -- http://www.freelists.org/webpage/oracle-l