RE: Snapshot (Materialized View) Maladies

  • From: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Sat, 5 Jun 2004 20:44:29 +0200

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

Other related posts: