Sql 调优顾问（接受配置文件）

发布于 2024-10-04 21:51:44 字数 597 浏览 3 评论 0原文

我已经为某些查询创建了 SQL 调整任务并执行了它。生成报告后，它建议我运行以下命令：

execute dbms_sqltune.accept_sql_profile(task_name => 'tuning_task_name',
                                        replace => TRUE);

但是！我当然想知道这个配置文件是做什么的？！在互联网上搜索这个问题后，我发现了以下查询：

select
    rat.attr1
from
  sys.WRI$_ADV_TASKS    tsk,
  sys.WRI$_ADV_RATIONALE  rat
where
  tsk.name = 'tuning_task_name'
and  rat.task_id   = tsk.id

该查询的结果如下：

alt text

我不明白它是做什么的 :( 而且我想将此配置文件提示转换为更可读的 (/+ 提示/) sql 提示？

原文

I have created sql tuning task for some query and executed it.After generating report,It recommends me to run the following command:

execute dbms_sqltune.accept_sql_profile(task_name => 'tuning_task_name',
                                        replace => TRUE);

But! Of course I want to know what does this profile do?! and after searching this question on the internet I found the following query:

select
    rat.attr1
from
  sys.WRI$_ADV_TASKS    tsk,
  sys.WRI$_ADV_RATIONALE  rat
where
  tsk.name = 'tuning_task_name'
and  rat.task_id   = tsk.id

And the result of this query is the following:

alt text

I don't understand what does it do :( And also I want to convert this profile hints into the more readable (/+ hint/) sql hints?

分享到QQ

分享到微博