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 |
||
| Riga 16: | Riga 16: | ||
/ |
/ |
||
Per cancellarla: |
|||
begin |
|||
DBMS_SQLDIAG.drop_sql_patch(name => 'first_rows_query_nagios_space'); |
|||
end; |
|||
/ |
|||
[[Categoria:Database]] |
[[Categoria:Database]] |
||
Versione delle 14:25, 10 dic 2024
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; /
Per cancellarla:
begin DBMS_SQLDIAG.drop_sql_patch(name => 'first_rows_query_nagios_space'); end; /