The following error occurs launching Optimizer: "ORA-00904: 'FILTER_PREDICATES': invalid identifier". This launch can be from Toad or as standalone. Error occurs at the startup of Tuning Lab tab. There are several of these messages and SQL cannot be Optimize as the error message appears again.
Plan table used does not have 'FILTER_PREDICATES' column. This and ACCESS_PREDICATED columns were introduced in Oracle 9.2.
1. Select Options from the top right corner of screen
2. Select General from left side tree
3. Verify the Plan table name that has been specifed to be used by Optimizer
4. This table needs to be verified to include the above columns, otherwise, use the "Allow Quest SQL Optimizer to create plan table automatically" in Options
5. This option will have Optimizer create a temporary plan table
