set pages 1000
set lines 180

@?/rdbms/admin/tcellsim                       

10 Most active SQL tuning sets
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

NAME             OWNER             SQL_COUNT DESCP
------------------------------ ------------------------------ ---------- --------------------
DEMOSTS            SYS               1 SQL Tuning Set to ev

Specify the name and owner of SQL tuning set to use
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for sts_name: DEMOSTS
Enter value for sts_owner: SYS

 >> SQL tuning set specified: DEMOSTS owned by SYS

Run Cell simulation
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

>> 1. create a spa analysis task to test cell simulation
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

 >> Name of SPA analysis task: TASK_151

>> 2. Test execute statements with cell simulatin DISABLED
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

>> 3. Test execute statements with cell simulation ENABLED
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

>> 4. Compare peformance and generate analysis report
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

SPA_SUMMARY
------------------------------------------------------------
General Information
------------------------------------------------------------

 Task Information:                              Workload Information:
 ---------------------------------------------  ---------------------------------------------
  Task Name: TASK_151                            SQL Tuning Set Name: DEMOSTS
  Task Owner: SYS                                SQL Tuning Set Owner: SYS
  Description:                                   Total SQL Statement Count: 1

Execution Information:
---------------------------------------------------------------------------------------------
  Execution Name: EXEC_153                       Started: 10/02/2008 18:58:10
  Execution Type: COMPARE PERFORMANCE            Last Updated: 10/02/2008 18:58:10
  Description:                                   Global Time Limit: UNLIMITED
  Scope: COMPREHENSIVE                           Per-SQL Time Limit: UNUSED
  Status: COMPLETED                              Number of Errors: 0

Analysis Information:
---------------------------------------------------------------------------------------------
 Comparison Metric: IO_INTERCONNECT_BYTES
 ------------------
 Workload Impact Threshold: 1%
 --------------------------
 SQL Impact Threshold: 1%
 ----------------------
 Before Change Execution:                          After Change Execution:
 ---------------------------------------------     ---------------------------------------------
  Execution Name: cell_simulation_DISABLED          Execution Name: cell_simulation_ENABLED
  Execution Type: TEST EXECUTE                      Execution Type: TEST EXECUTE
  Scope: COMPREHENSIVE                              Scope: COMPREHENSIVE
  Status: COMPLETED                                 Status: COMPLETED
  Started: 10/02/2008 18:58:10                      Started: 10/02/2008 18:58:10
  Last Updated: 10/02/2008 18:58:10                 Last Updated: 10/02/2008 18:58:10
  Global Time Limit: UNLIMITED                      Global Time Limit: UNLIMITED
  Per-SQL Time Limit: UNUSED                        Per-SQL Time Limit: UNUSED
  Number of Errors: 0                               Number of Errors  : 0

Report Summary
---------------------------------------------------------------------------------------------

Projected Workload Change Impact:
-------------------------------------------
 Overall Impact      :  100%
 Improvement Impact  :  100%
 Regression Impact   :  0%

SQL Statement Count
-------------------------------------------
 SQL Category  SQL Count  Plan Change Count
 Overall         1      0
 Improved        1      0

Top SQL Statements Sorted by their Absolute Value of Change Impact on the Workload
--------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------
|           |               | Impact on | Metric   | Metric | Impact | % Workload | % Workload | Plan   |
| object_id | sql_id        | Workload  | Before   | After  | on SQL | Before     | After      | Change |
---------------------------------------------------------------------------------------------------------
|     4     | 4ynqdxdhu08p1 |      100% | 80388096 |      0 |   100% | 100%       |     0%     | n      |
---------------------------------------------------------------------------------------------------------