Re: Snapshot too old

From: Mladen Gogala <mgogala_at_verizon.net>
Date: Sun, 15 Oct 2006 21:46:45 -0400
Message-id: <1160963205l.8277l.1l@medo.noip.com>

On 10/15/2006 09:37:35 PM, Daniel W. Fink wrote:
> Dean,
>
> I would start with reducing the runtime of the query. 33,219 seconds is
> almost 10 hours! Reduce the run time and you reduce the need for long
> undo retention. Also look at running this query against data that is not
> volatile (datamart or datawarehouse for example).

OK, let me ignite a flame war between the Inmon fans and the Kimball fans: what is the difference between data mart and a data warehouse? How to decide between the two? How to define granularity for data mart and how to define granularity for data warehouse?

-- 
Mladen Gogala
http://www.mladen-gogala.com

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

Received on Sun Oct 15 2006 - 20:46:45 CDT