RE: Snapshot (Materialized View) Maladies

From: <Scott.Shafer_at_dcpds.cpms.osd.mil>
Date: Fri, 4 Jun 2004 16:26:08 -0500
Message-ID: <D5DBDB57DE20D711ABF9000629261E9101CA5482@SATXPO1>

Looks like something in translation. Lemme guess - you're using outlook as well? Go to view -> fonts -> and select "larger" in the menu bar on the message.

Scott Shafer
San Antonio, TX
210.581.6217

-----Original Message-----
From: Bobak, Mark [mailto:Mark.Bobak_at_il.proquest.com] Sent: Friday, June 04, 2004 4:21 PM
To: oracle-l_at_freelists.org
Subject: RE: Snapshot (Materialized View) Maladies

There's another one, Jared. 5pt font.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Jared.Still_at_radisys.com
Sent: Friday, June 04, 2004 5:08 PM
To: oracle-l_at_freelists.org
Subject: Re: Snapshot (Materialized View) Maladies

> Our main issue with them is that there is nothing reported in the alert
> log and no easy detection method for problem determination when they are
> NOT WORKING! You must check DBA_JOBS and numerous other tables via
> scripts for exceptions (such as - job running too long, job hasn't run
> at all, job not running at frequency or time specified, etc). Worst of
> all, sometimes even these queries fail to detect that the snapshot has
> not refreshed, and ain't ever gonna. In extreme cases, we've had to
> rebuild several million row mviews at the recommendation of Oracle,
> simply because we had a network outage or some other glitch.
>
> Any comments or similar experiences?
>

Many times. Network glitches can cause the MV slave/master sync to go awry. I've found the result of it in the mv logs, and could determine why they would not refresh, but could not determine how it happened ( I forget exact details at the moment )

The last time it happened was 2 hours before I had to get to the airport to catch a plane for HOTSOS. :(

That time, dropping/recreating the refresh group fixed the problem.

Jared

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 Fri Jun 04 2004 - 16:20:08 CDT