ON COMMIT FAST MViews seems to be less than bulletproof

From: "Brady, Mark" <Mark.Brady@xxxxxxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Date: Fri, 15 Jun 2007 20:08:32 -0400

This is on Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit
Production

 

From the Alert Log we see:

 

 

Fri Jun 15 10:49:03 2007

Following on-commit snapshots not refreshed :

DEALNET.BROWSER_MV_INFO

DEALNET.BROWSER_MV_STATUS

Fri Jun 15 10:49:41 2007

Following on-commit snapshots not refreshed :

DEALNET.BROWSER_MV_INFO

DEALNET.BROWSER_MV_STATUS

Fri Jun 15 11:52:56 2007

Following on-commit snapshots not refreshed :

DEALNET.BROWSER_MV_INFO

DEALNET.BROWSER_MV_STATUS 

 

 

I've googled this and I find a lot of posts asking what causes this but
not a lot of posts for what causes this and how to prevent it. Can
anyone point me to a cause? 

 

TIA,

Mark

>>> This e-mail and any attachments are confidential, may contain legal,
professional or other privileged information, and are intended solely for the
addressee.  If you are not the intended recipient, do not use the information
in this e-mail in any way, delete this e-mail and notify the sender. CEG-IP2

Follow-Ups:

Re: ON COMMIT FAST MViews seems to be less than bulletproof
From: Alexander Fatkulin

Re: ON COMMIT FAST MViews seems to be less than bulletproof
From: Jared Still

References:
- Re: TOAD Access to other Schemas
  - From: Rich Jesse
- Re: TOAD Access to other Schemas
  - From: rjamya

ON COMMIT FAST MViews seems to be less than bulletproof

Other related posts: