| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Oracle 8i and COGNOS a bad mix?
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,
--
 |
 |