Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle Wait Interface for data warehouses

RE: Oracle Wait Interface for data warehouses

From: Gogala, Mladen <Mladen.Gogala_at_aetn.com>
Date: Fri, 6 Aug 2004 11:58:08 -0400
Message-ID: <30462D80AA52E74698512ADCC4F7EAA312239620@exchange.aetvn.com>


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_at_aetvn.com
Ext: 9787



> -----Original Message-----
> From: Milligan, Michael [mailto:Michael.Milligan_at_Ingenix.com]
> Sent: Friday, August 06, 2004 11:50 AM
> To: 'oracle-l_at_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_at_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_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
> -----------------------------------------------------------------
>
---------------------------------------------------------------- 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 Fri Aug 06 2004 - 10:53:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US