RE: Snapshot (Materialized View) Maladies
- From: Ron Thomas <rthomas@xxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 4 Jun 2004 14:33:13 -0700
They look fine to me. Of course I'm reading this with Notes 6.5, running on
crossover 3.0 and SuSE
9.1...
Ron Thomas
Hypercom, Inc
rthomas@xxxxxxxxxxxx
"To really screw up Linux you have to work at it...To really screw up Windows,
you have to work ON
it..."
Mark.Bobak@xxxxxxxxxxxxxxx
Sent by:
oracle-l-bounce@xxxxxxxxxxx
To
rg oracle-l@xxxxxxxxxxxxx
cc
06/04/2004 02:21 PM
Subject
RE: Snapshot (Materialized
View) Maladies
Please respond to
oracle-l@xxxxxxxxxxxxx
There's another one, Jared. 5pt font.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of
Jared.Still@xxxxxxxxxxx
Sent: Friday, June 04, 2004 5:08 PM
To: oracle-l@xxxxxxxxxxxxx
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@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:
