Hi there,

Some background first:
OS: Sun Solaris 8 64bit
DB: Oracle 8.1.7.4.0 64bit

We recently upgraded from powerhouse version ph823d7 to ph843d. We first had problems with the database entry in the powerhouse dictionary and had to change the entry from:
==========
FROM:
Database MYDB &
Type ORACLE &
Null values not allowed &
Open "ORACLE" &
Owner HHH &
Userid '/
==========
TO:
Database MYDB &
type ORACLE &
open oracle@mydb.world &
Null values not allowed &
Owner HHH &
Userid '/
==========
The only difference is we had to use a tnsnames.ora entry in the dictionary to specify a database to connect to - in the past this was not necessary as it picked up the ORACLE_SID I presume. If the entry is not there we get core dumps when trying to access tables using quiz.


After the upgrade we started to experience some performance problems with some of the powerhouse reports. I did a trace on one of the reports (on the db) and analyzed the trace (using tkprof) and noticed that the amount of fetches are almost double than when using the previous version of powerhouse. The SQL statements are all optimized and in SQLPLUS execute instantaneously. A suggestion from Oracle is that we have a look at the powerhouse application/software and look for a "prefetch" parameter/setting, but no luck.

Any ideas/suggestions will be greatly appreciated.

Thanks,
J.