Oracle sql patch

Da Emigar.
Jump to navigation Jump to search


https://oracle-base.com/articles/11g/sql-repair-advisor-11g

How to Create a SQL Patch to add Hints to Application SQL Statements (Doc ID 1931944.1)

DECLARE
 l_patch_name  VARCHAR2(32767);
BEGIN
 -- SQL ID
 l_patch_name := SYS.DBMS_SQLDIAG.create_sql_patch(
   sql_id    => '85m4pf9c6m791',
   hint_text => 'FIRST_ROWS',
   name      => 'first_rows_query_nagios_space');
END;
/

Per cancellarla:

begin
 DBMS_SQLDIAG.drop_sql_patch(name => 'first_rows_query_nagios_space');
end;
/