Re: Materialized views and redo

On 6/14/07, Paul Vincent <Paul.Vincent_at_uce.ac.uk> wrote:
>
> On a system which otherwise generates very little redo (since about 99%
> of all transactions are read-only, using only SELECTs), we have a
> materialized view which is refreshed once an hour. This was introduced to
> give a far better response time on a common query type which ran in 15
> seconds without the view, but now runs in a second or less, using the
> materialized view.
>
>

Refresh type? (full or fast)
Re the previous question: Is there a log(s) on source table(s)? (there will be for fast refresh)
Database version? (it matters...)

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

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