Re: MView refresh question
From: rjamya <rjamya_at_gmail.com>
Date: Tue, 29 May 2012 07:33:33 -0400
Message-ID: <CAGurbTOLXmvyFrXtY9TSOZyHc2EHb2LE-BpwsEACVg-_n3WL8w_at_mail.gmail.com>
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
Date: Tue, 29 May 2012 07:33:33 -0400
Message-ID: <CAGurbTOLXmvyFrXtY9TSOZyHc2EHb2LE-BpwsEACVg-_n3WL8w_at_mail.gmail.com>
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_at_gmail.com>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?
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue May 29 2012 - 06:33:33 CDT