Oracle Error Message
QSM-00519: Summary Advisor is not installed. Please execute INITQSMA.SQL.
Reason for the Error
The current database has has not be created or upgraded to support Summary Advisor. Summary Advisor requires several Java stored procedures.
Solution
Log into the database with SYSDBA privileges. Execute the INITQSMA.SQL script found in the ADMIN directory under the ORACLE home. **** **** Messages 520-700 are in the 9i Summary Advisor Java modules 701-708 are Hypothetical Workload generator journal messages