How to check the source of analysis task in Oracle Performance Analyzer?
0
votes
2
answers
145
views
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 => ''
, sqlset_owner=>''
,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='' and parameter_name='SQLSET_NAME';
But the result is showing "NOT USED" for column parameter_value
|parameter_name | parameter_value|
|-------------------- | ------------------|
|SQLSET_NAME UNUSED||
Asked by pavankumar
(1 rep)
Jul 1, 2021, 09:04 AM
Last activity: Jul 20, 2025, 06:06 PM
Last activity: Jul 20, 2025, 06:06 PM