Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 7.3 as a Data Warehouse

Re: Oracle 7.3 as a Data Warehouse

From: TurkBear <jvgreco_at_pop.primenet.com>
Date: 1997/11/03
Message-ID: <34610e82.253378749@news.primenet.com>#1/1

Just as an added note, Oracle has tested its RDBMS against TeraByte sized databases, so it should be OK - Search the Oracle site for info on warehousing ( also try www.oramag.com )

John Greco
Oracle DBA ( not that big - just 8Gigs )

mjr_at_netcom.com (Mark Rosenbaum) wrote:

>In article <63a46p$sis_at_camel21.mindspring.com>,
>Tony <trodgers_at_mindspring.com> wrote:
>>I'm curious if anyone out there is using Oracle 7.3 running as a data
>>warehouse. I'm specifically looking for a warehouse that is 40 - 50GB or
>>larger. I'm curious about the experiences people have had with very large
>>tables and how the CBO handles access, as well as general read times. Any
>>input would be valuable. I'd just like to compare notes.
>
>Tony,
>
>I hate to sound cute but it depends on the exact release of Oracle
>and the platform and release of OS. Some general guide lines though
>
>For large tables (fact tables typically in star/snowflake) try using
>Partitioned views on the time dimension.
>
>Test everything at full size (some bugs only appear at larger sizes)
>
>The front end tool will but but constraints on how things are to be
>done use it during the testing.
>
>Hope this helps
>
>Mark
Received on Mon Nov 03 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US