SYMPTOM:
The Strategy Intelligence Server takes much longer than expected to start up. This may be noticed when moving to a new database version, a new database instance in Oracle or the creation of a new schema.
CAUSE:
A possible cause may be the type of table analysis that is being done against the metadata. Check in Oracle to determine which type of statistics is being used to analyze the tables. In Oracle, the choices are:
It has been found in some cases where use of 'estimate statistics' provides better performance when starting the Strategy Intelligence Server against an Oracle database.
Also, there may be an inherited difference between the join used in these analysis types. Use of a hash join may yield better performance rather than using nested loop joins. It has been found in some cases where use of 'a hash join' provides better performance when starting the Strategy Intelligence Server against an Oracle database.
For more detailed information regarding these types of analysis and joins, contact the respective vendor.
ACTION:
Re-analyze the table statistics type so that it no longer uses 'compute statistics,' but instead uses 'estimate statistics'.
View the explain plan of the metadata tables in the schema to see if they are using a hash join or nested loop joins.
Third Party Software Installation
WARNING:
The third-party product(s) discussed in this technical note is manufactured by vendors independent of Strategy. Strategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability.
