Workload Qualification - Oracle Exadata Recipes: A Problem-Solution Approach - page 85

Enter value for snap_low: 22919
Enter value for snap_high: 22966

PL/SQL procedure successfully completed.

SQL>

For purposes of the example below, we've decided to build a SQL Tuning Set based on three minutes of activity
from our cursor cache:

SQL> begin
dbms_sqltune.create_sqlset(sqlset_name=>'EXA_SIM2',
description=>'Exadata tcellsim test #2');
end;
/

PL/SQL procedure successfully completed.

SQL>
SQL> begin
dbms_sqltune.capture_cursor_cache_sqlset (
sqlset_name => 'EXA_SIM2',
time_limit => 180,
repeat_interval => 10
);
end;
/

PL/SQL procedure successfully completed.

SQL>

■ We chose to create our SQl tuning Set without using enterprise Manager to show how easy this can be done
outside of the browser interface, but you can also use Grid Control to accomplish the same task. the choice of whether
to use enterprise Manager versus oracle's built-in pl/SQl package is generally a matter of personal preference. the use
of enterprise Manager assumes functional, current versions of the software, and since not all organizations upgrade or
patch their enterprise Manager Grid Control software to the most recent versions and may have oracle 11gr2 databases
monitored and managed by earlier versions of Grid Control, we elected to demonstrate using built-in oracle pl/SQl
packages in this recipe.

Note

Once your SQL Tuning Set is created, change directories to $ORACLE_HOME/rdbms/admin , log in to SQL*Plus as
SYSDBA , and run tcellsim.sql . This will use SQL Performance Analyzer to perform storage cell simulation.

■ this process will execute SQl performance analyzer tests against the SQl in your SQl tuning Set and could
introduce a non-trivial load on your test system, so plan accordingly if you wish to run this on a production environment.

Note