Forum Stats

  • 3,758,157 Users
  • 2,251,345 Discussions
  • 7,870,070 Comments

Discussions

How to check the source of analysis task in Performance analyzer?

Pavankumar Sudabattula-Oracle
Pavankumar Sudabattula-Oracle Member Posts: 8 Employee
edited Jun 24, 2021 11:57AM in General Database Discussions

We have provided sql tuning set as input to the analysis task of performance analyzer

variable l_task_id VARCHAR2(64);

exec :l_task_id:=dbms_sqlpa.create_analysis_task( sqlset_name => '<sql set name>', sqlset_owner=>'<owner>',task_name => '<new task name>');

Now i want to list all the tasks associated with the sql tuning set. I have tried below ways but they are not working

select parameter_name,parameter_value from dba_advisor_exec_parameters where task_name='<task name>' and parameter_name='SQLSET_NAME';

But the result is showing "NOT USED" for column parameter_value

parameter_name parameter_value

-------------------- ------------------

SQLSET_NAME UNUSED

Tagged: