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.
BEGIN:VCARD VERSION:2.1 N:de Haan;Lex FN:Lex de Haan ORG:Natural Join B.V. TEL;WORK;VOICE:+31.30.2515022 TEL;HOME;VOICE:+31.30.2518795 TEL;CELL;VOICE:+31.62.2955714 TEL;WORK;FAX:+31.30.2523366 ADR;WORK:;;Pieter Breughelstraat 10;Utrecht;;3583 SK;Netherlands LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Pieter Breughelstraat 10=0D=0AUtrecht 3583 SK=0D=0ANetherlands URL;WORK:http://www.naturaljoin.nl EMAIL;PREF;INTERNET:lex.de.haan@xxxxxxxxxxxxxx REV:20040224T160439Z END:VCARD