Skip to content

Instantly share code, notes, and snippets.

@Tracnac

Tracnac/Auto SQLTUNE Report.md

Last active October 19, 2022 11:57
Show Gist options
  • Save Tracnac/336e985e30f862c33b0e0e350d010ee1 to your computer and use it in GitHub Desktop.
Save Tracnac/336e985e30f862c33b0e0e350d010ee1 to your computer and use it in GitHub Desktop.
Download ZIP
Auto SQLTUNE Report #oracle #sql
Raw
Auto SQLTUNE Report.md 
set long 5000000
set linesize 512
set pagesize 10000
column auto_tuning_task_report format a256


select DBMS_AUTO_SQLTUNE.REPORT_AUTO_TUNING_TASK(
NULL,
NULL,
'TEXT',
'TYPICAL',
'ALL',
NULL,
NULL) auto_tuning_task_report
from dual;
  1. Activer l'implémentation automatique de SQL Profiles par l'auto-tâche « Automatic SQL Tuning » dans la base de données Oracle N4DS de staging.

http://docs.oracle.com/cd/E11882_01/server.112/e16638/sql_tune.htm#CHDDICIF

BEGIN
DBMS_AUTO_SQLTUNE.SET_AUTO_TUNING_TASK_PARAMETER(
parameter => 'ACCEPT_SQL_PROFILES', value => 'TRUE');
END;
/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment