RE: Oracle Wait Interface for data warehouses

I'm sorry,

What did you mean by BCHR, and " "DW Inside, @#$%! Outside" sticker to the database " ?

Thanks in advance.

Mike

-----Original Message-----
From: Gogala, Mladen [mailto:Mladen.Gogala_at_aetn.com] Sent: Friday, August 06, 2004 9:58 AM
To: 'oracle-l_at_freelists.org'
Subject: RE: Oracle Wait Interface for data warehouses

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
-----------------------------------------------------------------


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 11:03:35 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
-----------------------------------------------------------------