Oracle sql patch
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; /