Re: Can I use choose optimization mode in Oracle with ESSBase

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 6 Dec 2000 22:59:29 +0100
Message-ID: <90ol0q$1qcsm$1@ID-62141.news.dfncis.de>

Set optimizer_mode = choose in init.ora
and don't analyze your essbase tables
and analyze your datawarehouse tables and you'r there.

Hth,

Sybrand Bakker, Oracle DBA

<lsantos_at_pobox.com> wrote in message news:90m62d$pvu$1_at_nnrp1.deja.com...
> Hi!
>
> I´m an experienced Oracle DBA but new with Hyperion ESSBase.
>
> I was told that ESSBase claims that Oracle database optimizer mode
> must be set to RULE!
>
> So, my situation: I have a powerful Oracle 8.1.6 database DW based
> without all the new exciting DW features of Oracle 8i... :-(
>
> My question: Can ESSBase client be configured to issue an "ALTER
> SESSION SET OPTIMIZER_MODE=RULE' just after its connection to the
> Oracle Database?
>
> Best regards,
> Luis Santos
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Dec 06 2000 - 15:59:29 CST