Re: RAC for Reporting...!

Running DBMS_MVIEW.EXPLAIN_REWRITE for my Query and Materialised View gives me:

ERROR at line 1:

ORA-00936: missing expression
ORA-06512: at "SYS.DBMS_XRWMV", line 0
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 1475
ORA-06512: at line 7

The only hit on Metalink refers to patching to 9.2.0.4.... Great...!

Matt

> [...]
>
> Yes, the overhead of maintaining the MV's will still be there, just as
> it would be in the primary database.
>
> But the potential benefit would be in having a separate instance, with
> different tuning parameters and different hardware to run it, so that
> reporting queries don't impact transaction performance in the primary
> database. If you can build the MV's directly in your primary and run
> the reporting there, then you're right, there's no point.
>
> --Mark Bole
Received on Tue May 11 2004 - 03:01:32 CDT