Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 7.3 as a Data Warehouse
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