RE: Oracle Wait Interface for data warehouses
- From: "Milligan, Michael " <Michael.Milligan@xxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 6 Aug 2004 11:03:33 -0500
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@xxxxxxxx]
Sent: Friday, August 06, 2004 9:58 AM
To: 'oracle-l@xxxxxxxxxxxxx'
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@xxxxxxxxx
Ext: 9787
> -----Original Message-----
> From: Milligan, Michael [mailto:Michael.Milligan@xxxxxxxxxxx]
> Sent: Friday, August 06, 2004 11:50 AM
> To: 'oracle-l@xxxxxxxxxxxxx'
> 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@xxxxxxxxxxx
>
>
> 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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
