RE: Materialized views and redo

From: Paul Vincent <Paul.Vincent_at_uce.ac.uk>
Date: Mon, 18 Jun 2007 09:17:00 +0100
Message-ID: <2AA2551968D1D349909FB594CC6310A27EAD@STAFFEXA.staff.uce.ac.uk>

Answers to Jared's questions:  

Force
No
10.2.0.2.0  

Paul Vincent
Database Administrator
Information and Communication Technology UCE Birmingham
paul.vincent_at_uce.ac.uk  

---

	From: Jared Still [mailto:jkstill_at_gmail.com] 
	Sent: 14 June 2007 19:48
	To: Paul.Vincent_at_uce.ac.uk
	Cc: Oracle-L_at_freelists.org
	Subject: 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

Received on Mon Jun 18 2007 - 03:17:00 CDT