Re: logical standby and funtion based indexes
- From: kathryn axelrod <kat.axe@xxxxxxxxx>
- To: eglewis71@xxxxxxxxx
- Date: Fri, 6 Apr 2012 23:57:27 -0700
Hi Ed,
Active DG should work as it would be using a physical standby thus
eliminating the FBI restriction. That said, Streams might be another
(cheaper) option to consider. I can't personally attest to it working
with FBIs, but as per the documentation, as of 10.2, it supports them:
http://docs.oracle.com/cd/B19306_01/server.102/b14229/whatsnew.htm#i972920
On Thu, Apr 5, 2012 at 4:17 PM, ed lewis <eglewis71@xxxxxxxxx> wrote:
> Hello,
> We've created a logical standby, and discovered
> issues with tables that have function-based indexes.
> Its appear the LSB does not use them. This caused
> the LSB to lag far behind the primary database.
> This particular DB has over a thousand tables with
> FBIs.
> To resolve this, we're adding unique indexes to the
> offending tables that require them. To me, this is not
> an ideal solution, especially as table volumes grow.
>
> I'm considering implementing active dataguard, and use this
> as our reporting DB. I hope to be able to try this in a week
> or so.
>
> Hasn't anyone used active dg to resolve the FBI issue ?
>
> Does anyone have any other solutions ?
>
> Your feedback is appreciated.
>
> thanks
> ed lewis
> --
> //www.freelists.org/webpage/oracle-l
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
