Re: materialized views

On 4/11/05, Mark Bole <makbo_at_pacbell.net> wrote:
>
>
> Why do you want to use MV's? If the performance benefit of using the
> MV's is greater than the cost of maintaining them, then what's the
> problem? Obviously you need to do some testing to find out if this is
> true in your case. Also, if you literally mean "just capture changed or
> new rows", then consider Change Data Capture, since an MV will include
> all the rows, not just the changed ones.
>

In the case of moving adhoc queries off of the OLTP database, you will know what the cost of maintaining the logs will be relative to the activity on the database. There's no way to predict adhoc usage.

Another, newer reason is that it may be required by your auditors in light of SarbanesOxley ( they require it of us for 2 systems ). Users are not allowed to have an account on our SAP or Agile(PLM) systems. They are required to use read-only MV's on another database.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

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