Re: large matview log, does it lock base table when dropping? - oracle-l - FreeLists

Re: large matview log, does it lock base table when dropping?

From: "Thomas Day" <tomdaytwo@xxxxxxxxx>
To: dannorris@xxxxxxxxxxxxx
Date: Thu, 31 Jul 2008 13:15:47 -0400

Have you tried

alter materialized view log on *master* enable row movement;

alter materialized view log on *master* shrink size;

This is supposed to be very DML friendly.  I haven't tested it for locks but
it's supposed to only have row locks on data in the log.  It could take a
while for 100G though.

Follow-Ups:
- Re: large matview log, does it lock base table when dropping?
  - From: Dan Norris

References:
- large matview log, does it lock base table when dropping?
  - From: Dan Norris

Other related posts:

» large matview log, does it lock base table when dropping?
» Re: large matview log, does it lock base table when dropping?
» Re: large matview log, does it lock base table when dropping?
» RE: large matview log, does it lock base table when dropping?
» Re: large matview log, does it lock base table when dropping?