Oracle sql patch: differenze tra le versioni
Jump to navigation
Jump to search
Nessun oggetto della modifica |
Nessun oggetto della modifica |
||
Riga 4: | Riga 4: | ||
https://oracle-base.com/articles/11g/sql-repair-advisor-11g |
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 |
DECLARE |
Versione attuale delle 14:28, 10 dic 2024
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; /