Execute Analysis Task is failing with error
Hi,
We are in process of trying to evaluate performance impact for SQL's for planned 12c migration. We have captured SQL's from 11g production environment and trying to test them on TEST database server.
Steps performed are as below
1) created a SQL Set in production environment (Version 11.2.0.3)
2) Loaded the SQL to STS using AWR
3) Transferred STS to my test database (version 11.2.0.3) using
DBMS_SQLTUNE.create_stgtab_sqlset
dbms_sqltune.PACK_STGTAB_SQLSET
export/import
dbms_sqltune.unpack_stgtab_sqlset
4) Now created analysis task on test 11g database
5) Executed analysis task on 11g
exec DBMS_SQLPA.execute_analysis_task(task_name => 'TASK_8234',execution_type=>'test execute',execution_name=>'11g');