RE: Materialized views and redo
- From: "Paul Vincent" <Paul.Vincent@xxxxxxxxx>
- To: <Oracle-L@xxxxxxxxxxxxx>
- Date: Mon, 18 Jun 2007 09:17:00 +0100
Answers to Jared's questions:
Force
No
10.2.0.2.0
Paul Vincent
Database Administrator
Information and Communication Technology
UCE Birmingham
paul.vincent@xxxxxxxxx
________________________________
From: Jared Still [mailto:jkstill@xxxxxxxxx]
Sent: 14 June 2007 19:48
To: Paul.Vincent@xxxxxxxxx
Cc: Oracle-L@xxxxxxxxxxxxx
Subject: Re: Materialized views and redo
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:
