From oracle-l-bounce@freelists.org Fri Aug 6 10:53:54 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i76FrsF24640 for ; Fri, 6 Aug 2004 10:53:54 -0500 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 i76FrsI24635 for ; Fri, 6 Aug 2004 10:53:54 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 70F8B72CD10; Fri, 6 Aug 2004 10:44:44 -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 03260-59; Fri, 6 Aug 2004 10:44:44 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A23EA72CCF2; Fri, 6 Aug 2004 10:44:43 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 06 Aug 2004 10:43:20 -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 9CEBD72CA97 for ; Fri, 6 Aug 2004 10:43:19 -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 03260-13 for ; Fri, 6 Aug 2004 10:43:19 -0500 (EST) Received: from imcsvr-2.aetvn.com (imcsvr-2.aetvn.com [216.89.67.159]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4CB6172C498 for ; Fri, 6 Aug 2004 10:43:19 -0500 (EST) Received: by imcsvr-2.aetvn.com with Internet Mail Service (5.5.2653.19) id ; Fri, 6 Aug 2004 11:58:10 -0400 Message-ID: <30462D80AA52E74698512ADCC4F7EAA312239620@exchange.aetvn.com> From: "Gogala, Mladen" To: "'oracle-l@freelists.org'" Subject: RE: Oracle Wait Interface for data warehouses Date: Fri, 6 Aug 2004 11:58:08 -0400 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-type: text/plain X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 7083 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Mladen.Gogala@aetn.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Of course not. Queries in data warehouse environment do not wait, which means that you don't need wait interface. Queries in the DW enironment are tuned by means of BCHR, not by boring stuff like wait events, 10046 trace and alike. It suffices to stick "DW Inside, @#$%! Outside" sticker to the database, and it will immediately cease with all wait events. -- Mladen Gogala Oracle DBA email:mladeng@aetvn.com Ext: 9787 > -----Original Message----- > From: Milligan, Michael [mailto:Michael.Milligan@Ingenix.com] > Sent: Friday, August 06, 2004 11:50 AM > To: 'oracle-l@freelists.org' > Subject: Oracle Wait Interface for data warehouses > > > I bought the Oracle Press book Oracle Wait Interface: A > Practical Guide to Performance Diagnosis and Tuning. I was > wondering if anyone knows if wait interface tuning is > pertinent to true data warehouse environments? > > Thanks, > > Mike > > Michael Milligan > Oracle Certified Professional DBA > 1757 West 1825 South > Syracuse, Utah 84075 > Phone: 801-628-6058 > Email: michael.milligan@ingenix.com > > > This e-mail, including attachments, may include confidential > and/or proprietary information, and may be used only by the > person or entity to which it is addressed. If the reader of > this e-mail is not the intended recipient or his or her > authorized agent, the reader is hereby notified that any > dissemination, distribution or copying of this e-mail is > prohibited. If you have received this e-mail in error, please > notify the sender by replying to this message and delete this > e-mail immediately. > > "Secure Server" made the following > annotations on 08/06/2004 10:49:49 AM > ------------------------------"This e-mail, including > attachments, may include confidential and/or proprietary > information, and may be used only by the person or entity to > which it is addressed. If the reader of this e-mail is not > the intended recipient or his or her authorized agent, the > reader is hereby notified that any dissemination, > distribution or copying of this e-mail is prohibited. If you > have received this e-mail in error, please notify the sender > by replying to this message and delete this e-mail > immediately." ============================== > ---------------------------------------------------------------- > 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 > ----------------------------------------------------------------- > ---------------------------------------------------------------- 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 -----------------------------------------------------------------