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@xxxxxxxxx> 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 >