Re: redo curiosity

From: Maureen English <maureen.english@xxxxxxxxxx>
To: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
Date: Thu, 18 Feb 2010 12:22:13 -0900

Thanks!  That's definitely worth a try.  I'll add this to our large refreshes 
to see what
difference it makes tonight.

- Maureen

Allen, Brandon wrote:

The solution/workaround is to set atomic_refresh=>false so it will truncate the mview 
table instead of doing a delete.  Just search for "atomic_refresh" on MOS and 
you'll see the relevant notes about this (e.g. 365157.1).

Regards,
Brandon

--
//www.freelists.org/webpage/oracle-l

Follow-Ups:
- RE: redo curiosity
  - From: Stephens, Chris
- RE: redo curiosity
  - From: Allen, Brandon

References:
- Find out how often SQL is run
  - From: Ingrid Voigt
- RE: Find out how often SQL is run
  - From: D'Hooge Freek
- redo curiosity
  - From: Maureen English
- RE: redo curiosity
  - From: Allen, Brandon

Other related posts:

» redo curiosity- Maureen English
» Re: redo curiosity- TESTAJ3
» RE: redo curiosity- Michael McMullen
» Re: redo curiosity- Igor Neyman
» RE: redo curiosity- Allen, Brandon
» Re: redo curiosity- Maureen English
» Re: redo curiosity - Maureen English
» RE: redo curiosity- Stephens, Chris
» RE: redo curiosity- Allen, Brandon
» RE: redo curiosity- Mark W. Farnham
» Re: redo curiosity- Maureen English
» RE: redo curiosity- Stephens, Chris
» Re: redo curiosity- Gints Plivna
» RE: redo curiosity- Mark W. Farnham