Oracle Solution for Error ora-30446

ORA-30446: valid workload queries not found

What triggered the Error:

None of the specified queries can be successfully parsed. The error may come from many sources: SQL syntax error, the owner specified by the load_workload subprograms do not match the real user who generates the SQL statement

What should we do to fix it:

Only load valid SQL statements into the advisor repository. Make sure the statements can be parsed with privilege of the owner as specified in the owner parameter of the load_workload() subprogram.