Re: Logical Standby Issues (cont.)

Hi Mark,

this is a shot in the dark, but what if you try and wrap your mass update inside a pl/sql FORALL bulk statement ?

I haven't tested it, and I don't know how the redo will look that is generated by it and how the apply will handle it, but it would execute in an entirely different context from a regular sql update, so maybe that would work around your problem ?

Stefan

On 8/11/06, Mark Strickland <strickland.mark_at_gmail.com> wrote:
>
> Well, I did have 10046 turned on for the whole database and I did look
> at session waits from time to time as well. There is a 1.3-Gb trace
> file for the Applier process but it doesn't contain 10046 stuff. I'm
> looking through the other trace files. Nothing startling so far...
>
> Mark
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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