-
编辑 删除
DBMS_SQLTUNE + SQL Performance Analyzer 实战小记
根据上一篇文章中生产的SPA任务，通过DBMS_SQLTUNE提出的建议优化sql一. dbms_sqltune.create_tuning_task可以基于sql text,sql_id, workload repository,sqlset,SPA Task。本处以前面实验用的SPA Task为例。--根据spa task_name创建任务(通过其他方式创建任务理应更简单)DECLARE L_SQL_TUNE_TASK_ID VARCHAR2(...
-
编辑 删除
利用SPA（SQL Performance Analyzer）对比两个SQL Tuning Set
简单介绍：1.A SQL tuning set (STS) is a database object that includes one or more SQL statements along with their execution statistics and execution context, and could include a user priority ranking. You can load SQL statements into a SQL tuning set from different SQL sources, such as AWR, the sha...
-
编辑 删除
SPA（SQL Performance Analyzer）实践小记 step-by-step
--1. Create a SQL Tuning Set:BEGINdbms_sqltune.create_sqlset('DJANGO_SET1');END;--2.Load SQL into the STS(From AWR Snapshots,load all the queries between two snapshots) --测试环境，SQL不足，加载两个快照间所有sql select snap_id, begin_interval_time, end_interval_time f...
