Oracle sql patch: differenze tra le versioni

Da Emigar.
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;
/