Re: MView refresh question
- From: rjamya <rjamya@xxxxxxxxx>
- To: Sriram Kumar <k.sriramkumar@xxxxxxxxx>
- Date: Tue, 29 May 2012 07:33:33 -0400
Thanks Sriram, well the idea is to _detect_ if there has been any change
(especially inserts), the process will figure out exactly which rows based
on status. sometimes we have tens of rows changed in a minute, sometimes it
has been a hundred k, so all we need to detect is " were there any inserts
done in the last mv refresh ", if so, we will trigger sleeping process, if
not we will let it sleep some more.
Hopefully this week we will get to rest some ideas ... oh and you are not
late, we are still in the eval phase
Thanks
Raj
On Sat, May 26, 2012 at 4:48 AM, Sriram Kumar <k.sriramkumar@xxxxxxxxx>wrote:
> Hi,
>
> apologies for jumping in late. How about a row-level trigger on the mview
> that performs a enqueue of the PK on AQ ? and then the poller can do a look
> up based on the PK?
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
