SQL Performance (MOSC)

MOSC Banner

Execute Analysis Task is failing with error

edited May 22, 2015 10:04AM in SQL Performance (MOSC) 1 commentAnswered

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');

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center