Oracle sql patch: differenze tra le versioni
Jump to navigation
Jump to search
(Creata pagina con " https://oracle-base.com/articles/11g/sql-repair-advisor-11g 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; / Categoria:Database Categoria:Oracle") |
Nessun oggetto della modifica |
||
| (Una versione intermedia di uno stesso utente non è mostrata) | |||
| 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 |
||
| Riga 16: | Riga 17: | ||
/ |
/ |
||
Per cancellarla: |
|||
begin |
|||
DBMS_SQLDIAG.drop_sql_patch(name => 'first_rows_query_nagios_space'); |
|||
end; |
|||
/ |
|||
[[Categoria:Database]] |
[[Categoria:Database]] |
||
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; /