sql profiles
<PRE>
<a href=http://www.oracle.com/technology/products/manageability/database/pdf/ow06/auto_sql_tuning_jlewis.pdf>Autotune</a> J Lewis PDF
<a href=http://oukc.oracle.com/static05/opn/oracle9i_database/022607_1000/022607_1000_source/022607_1000/index.htm>Optimizing through Understanding</a> J Lewis seminar  recorded
<a href=http://jonathanlewis.wordpress.com/2007/02/11/profiles/>SQL Profiles</a> J Lewis notes
<a href=http://orafaq.com/node/17>autotune<a> Oracle Faqs
<a href=http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/sql_tune.htm>Autotune</a> Oracle Docs

Stored Outlines = Plan Stability
     <a href=http://www.dbazine.com/oracle/or-articles/jlewis4>Stored Outlines<a> J Lewis
     <a href=http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10752/outlines.htm>Plan Stability<a> Oracle Docs

- stored outlines associate hints with a sql statement
- sql profies associate hints of a statistics nature to an sql statement
- plan stability

begin
dbms_sqltune.alter_sql_profile(
   name => 'SYS_SQLPROF_014559fb1dd38000'
   attribute_name => 'STATUS',
   value => 'DISABLED');
   end;
/

DBMS_SQLTUNE:

ADD_SQLSET_REFERENCE
REMOVE_SQLSET_REFERENCE

CANCEL_TUNING_TASK
CREATE_TUNING_TASK
DROP_TUNING_TASK
EXECUTE_TUNING_TASK
INTERRUPT_TUNING_TASK
REPORT_TUNING_TASK
RESET_TUNING_TASK
RESUME_TUNING_TASK

SELECT_SQLSET
UPDATE_SQLSET
CREATE_SQLSET
LOAD_SQLSET
DELETE_SQLSET
DROP_SQLSET

ACCEPT_SQL_PROFILE
ALTER_SQL_PROFILE (name,'STATUS', ENABLE/DISABLE)
ALTER_SQL_PROFILE (name,'NAME',)
ALTER_SQL_PROFILE (name,'DESCRIPTION',) 
ALTER_SQL_PROFILE (name,'CATEGORY',) 
DROP_SQL_PROFILE

SELECT_WORKLOAD_REPOSITORY
</PRE>