Re: Oracle 8i and COGNOS a bad mix?

Hi Jamie,

maybe it helps to set "optimizer_mode = rule" in your init.ora.

Martin

Jamie Schrumpf wrote:
>
> I've just discovered that the Impromptu report that ran in seconds under Oracle
> 7.3.3 now takes 1 hr and 22 minutes under 8i on a Sun Solaris. It seems that
> the new version does a full table scan instead of a Nested Loop, and there are
> about 13 joins against a 400K-record fact table.
>
> This is with optimizer_mode = CHOOSE. If I set optimizer_mode = FIRST_ROWS, the
> joins return data like the 7.3.3 defaults, but then the Impromptu catalog build
> doesn't work: the "retrieving metadata" fish swims forever, and the tables
> never get added to the catalog.
>
> This is not good.
>
> Add this to the fact that my cgi-bin executables from 7.3.3 don't increment the
> PL/SQL do loops when I moved them over, and you've got a ticked-off DBA (me)
> about ready to move back to 7.3.3.
>
> Has anyone else experience these results with the COGNOS toolsets and Oracle
> 8i? I've been fighting fires all week.
>
> TIA,
> --
> --------------------------------------------------
> Jamie Schrumpf
Received on Wed Dec 08 1999 - 17:39:46 CST