2012-12-12 - 12-14 11gR2 "2 Day + Performance Tuning Guide" page 52 - 168

 

 

 

Creating a SQL Tuning Set: Load Method -- SQL TUNING SET的加载方法
Loading Active SQL Statements Incrementally from the Cursor Cache You can load active SQL
statements from the cursor cache into the SQL tuning set incrementally over a
specified period of time. This technique enables you to not only collect current and
recent SQL statements stored in the SQL cache, but also SQL statements that will run
during a specified time period in the future.
 -- 从CURSOR CACHE增量加载SQL语句，包括未来某段时间的SQL语句都会加载入

 

Loading SQL Statements from the Cursor Cache You can load SQL statements from the
cursor cache into the SQL tuning set. However, because only current and recent SQL
statements are in the SQL cache, collecting these statements only once may result in a
SQL tuning set this is not representative of the entire database workload.
 -- 从CURSOR CACHE非增量加载SQL语句

 

Loading SQL Statements from AWR Snapshots You can load SQL statements captured in
AWR snapshots. This is useful when you want to collect SQL statements for specific
snapshot periods of interest that can be used for later comparison or tuning purposes.
 -- 从AWR SNAPSHOTS中加载

 

Loading SQL Statements from AWR Baselines You can load SQL statements captured in
AWR baselines. This technique is useful when you want to collect SQL statements that
are representative of a time period during known performance levels that can be used
for later comparison or tuning purposes.
 -- 从AWR BASELINES中加载

 

Loading SQL Statements from a User-Defined Workload You can load SQL statements by
importing from a table or view. This technique is useful if the workload you want to
analyze is not currently running on the database or captured in an existing AWR
snapshot or AWR baseline.
 -- 从USER-DEFINED WORKLOAD中加载