Re: OLAP database planning and configuration best practice

From: Jeremy Schneider <jeremy.schneider_at_ardentperf.com>
Date: Tue, 23 Sep 2014 12:57:01 -0400
Message-ID: <CA+fnDAYFigMbcmqELEGQqh9VjC_PHyBxwgsCMFvWK_Uhoq6xXw_at_mail.gmail.com>

As a starting point, there's a whole section of the database docs about dw and bi. in particular, skim the warehousing and vldb guides. http://docs.oracle.com/database/121/nav/portal_6.htm

-Jeremy

--
http://about.me/jeremy_schneider

On Tue, Sep 23, 2014 at 3:57 AM, Milo <xueyuan.luo_at_gmail.com> wrote:



> Hi, all

> Is there any rule of thumb for planning and configuring the OLAP

> database(datawarehousing), such as what parameter should I use or adjust

> for OLAP, what other things we need to think about it, etc.

> Platform: IBM AIX

> Database version: Oracle 11g

> Database architecture: RAC

>

> I've googled a lot and searched on MOS, could not get a guide for

> configuring or tunning on OLAP senarios.

> I appreciate your help.

>

>

> ------------------------------

>  Best Regards,

> Milo

>


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

Received on Tue Sep 23 2014 - 18:57:01 CEST