RE: Snapshot (Materialized View) Maladies
- From: "Michael Fontana" <mfontana@xxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 7 Jun 2004 14:12:44 -0500
Thanks for all the sympathetic responses on Mviews. I really appreciate
them. What I was hoping for was specific suggestions, or ways in which
listees have actually enhanced the monitoring infrastructure. We now
have a process that detects the fact that the DBA job is running past
the next refresh time (by joining two separate Oracle viers
(dba_jobs_running/dba_mview). This should be part of the Oracle
software, because it pretty much defines a data integrity issue, in my
opinion.
It almost seems as though Oracle touted Snapshots, and then Mviews, as
THE distributed data solution years ago, and yet never fully carried out
the mission. I almost have to blush, because I had several development
teams dismantle manual table copies between systems as unreliable, and
they certainly were LESS reliable than what Oracle provides. However,
as a DBA, I maintain that anything less than 100% data integrity,
regardless of the cause (and network is often a prime suspect) ought to
at least be detected and reported by the DB software.
Any other opinions?
Michael Fontana
Sr. DBA
NTT/Verio
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Lex de Haan
Sent: Saturday, June 05, 2004 1:44 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Snapshot (Materialized View) Maladies
Hi Michael,
did you check out 10g? there are various enhancements in the MV area,
such as TUNE_MVIEW, new columns in the REWRITE_TABLE, and the
REWRITE_OR_ERROR hint ... and in the area of jobs, the DBMS_SCHEDULER is
an interesting new package.
I am pretty sure there are still lots of opportunities for further
enhancements :-)
Kind regards,
Lex.
---------------------------------------------
visit my website at http://www.naturaljoin.nl
---------------------------------------------
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Michael Fontana
Sent: Friday, June 04, 2004 20:37
To: oracle-l@xxxxxxxxxxxxx
Subject: Snapshot (Materialized View) Maladies
I am getting prepared to write up an enhancement request to Oracle for
improved administration, configuration and problem detection tools for
Materialized View (aka snapshot) processing.
----------------------------------------------------------------
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:
