Getting SQL Details - Performance Tuning

1. Connect SQL*Plus to the database with the appropriate privileges, and then optionally query the current task settings.

  style="margin-top:auto;margin-bottom:auto;margin-left:.5in;background:white"

1. BEGIN 
2.   DBMS_SPM.SET_EVOLVE_TASK_PARAMETER(
3.     task_name => 'SYS_AUTO_SPM_EVOLVE_TASK'
4. ,   parameter => parameter_name
5. ,   value => value
6. );
7. END;
8. /

For example, the following PL/SQL block sets a time limit to 20 minutes, and also automatically accepts plans:

BEGIN

  DBMS_SPM.SET_EVOLVE_TASK_PARAMETER(

    task_name => 'SYS_AUTO_SPM_EVOLVE_TASK'

,   parameter => 'LOCAL_TIME_LIMIT'

,   value => 1200

);

  DBMS_SPM.SET_EVOLVE_TASK_PARAMETER(

    task_name => 'SYS_AUTO_SPM_EVOLVE_TASK'

,   parameter => 'ACCEPT_PLANS'