Skip to content

Instantly share code, notes, and snippets.

@dincosman
Last active October 26, 2023 21:55
Sql Patching of Problematic Query

DECLARE
patch_name VARCHAR2 (4000);
BEGIN
patch_name := DBMS_SQLDIAG.create_sql_patch (sql_id => '16rzwmtc4wpqu', hint_text => 'PARALLEL(2)', name=>'SQLPATCH_PRODUCTS_PARALLEL');
END;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment