使用SQL tuning advisor(STA)自动优化SQL

您的位置：
门户
>> 文章精选
>> 软件开发专栏
>> 数据库
>> 查看资讯

使用SQL tuning advisor(STA)自动优化SQL

发表于：2013-6-21 09:59

作者：RobinsonCheng 来源：51Testing软件测试网采编

　　7、相关视图

　　DBA_ADVISOR_LOG
　　DBA_ADVISOR_TASKS
　　DBA_ADVISOR_FINDINGS
　　DBA_ADVISOR_RECOMMENDATIONS
　　DBA_ADVISOR_RATIONALE
　　DBA_SQLTUNE_STATISTICS
　　DBA_SQLTUNE_BINDS
　　DBA_SQLTUNE_PLANS

　　8、演示用到的脚本

SET ECHO OFF TERMOUT ON FEEDBACK OFF VERIFY OFF
SET SCAN ON
SET LONG 1000000 LINESIZE 180
COL recs FORMAT a135

VARIABLE tuning_task VARCHAR2(30)

DECLARE
l_sql_id v$session.prev_sql_id%TYPE;
BEGIN
SELECT prev_sql_id INTO l_sql_id
FROM v$session
WHERE audsid = userenv('SESSIONID');

:tuning_task := dbms_sqltune.create_tuning_task(sql_id => l_sql_id);
dbms_sqltune.execute_tuning_task(:tuning_task);
END;
/

SELECT dbms_sqltune.report_tuning_task(:tuning_task) as recs
FROM dual;

SET VERIFY ON FEEDBACK ON

33/3<1 23

《2023软件测试行业现状调查报告》独家发布~

搜索风云榜

送祝福，领好礼

2023测试行业调查报告

挣点稿费

AI与软件测试

文章资料精选