Re: Materialized views and redo

  • From: "Jared Still" <jkstill@xxxxxxxxx>
  • To: Paul.Vincent@xxxxxxxxx
  • Date: Thu, 14 Jun 2007 11:48:10 -0700

On 6/14/07, Paul Vincent <Paul.Vincent@xxxxxxxxx> 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

Other related posts: