RE: Snapshot (Materialized View) Maladies

From: Michael Fontana <mfontana_at_verio.net>
Date: Mon, 7 Jun 2004 14:12:44 -0500
Message-ID: <00c001c44cc3$6b0267f0$380b0a0a@corp.verio.net>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Lex de Haan
Sent: Saturday, June 05, 2004 1:44 PM
To: oracle-l_at_freelists.org
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Michael Fontana
Sent: Friday, June 04, 2004 20:37
To: oracle-l_at_freelists.org
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_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 Mon Jun 07 2004 - 14:09:51 CDT