Re: interesting wait event
- From: "K Gopalakrishnan" <kaygopal@xxxxxxxxx>
- To: Mark.Bobak@xxxxxxxxxxxxxxx
- Date: Tue, 28 Feb 2006 13:26:46 -0800
Mark:
DRM is file based in 10.1 and it is file+object based in R2. So adding
a datafile on one node and loading the data in the other node may
cause DRM for that file to be mastered on loading instance. Hope this
makes the issue logical..
Gopal
On 2/28/06, Bobak, Mark <Mark.Bobak@xxxxxxxxxxxxxxx> wrote:
> A quick Google search yielded nothing, and a quick MetaLink search
> yielded this (all too brief) description:
>
> "This event is related to dynamic remastering which I would not use
> until 10.2
> So if you are have performance problems because of DRM you should
> disable the same using
> _gc_affinity_time=0"
>
> Note that the reference to 10.2, above, is because the original poster
> who asked about the event reported running 10.1.
>
> I suppose it makes a certain amount of sense that a wait on a dynamic
> remastering event would occur when adding a datafile?
> I guess I'd try not adding datafiles during heavy loads....beyond that,
> if the event is really a problem, you probably ought to open an SR and
> get more info. I wouldn't recommend setting an undocumented parameter,
> particularly now that dynamic remastering is *presumably* ok in 10.2....
>
> -Mark
>
--
Best Regards,
K Gopalakrishnan
Co-Author: Oracle Wait Interface, Oracle Press 2004
http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/
--
//www.freelists.org/webpage/oracle-l
Other related posts:
