• Top SQL Patch Queries in Oracle Database

    Updated: 2023-09-14 06:25:00
    Here are some of the top SQL Patch Queries in Oracle Database Query to Query to find the hints associated with a SQL Patch select cast(extractvalue(value(x), '/hint') as varchar2(500)) as outline_hintsfrom xmltable('/outline_data/hint'passing (select xmltype(comp_data) xmlfrom sys.sqlobj$datawhere signature = select EXACT_MATCHING_SIGNATURE from v$sql where sql_id = '&SQL_ID';)) x; How to find all the SQL_PATCH in the […] The post Top SQL Patch Queries in Oracle Database appeared first on Techgoeasy.

  • how to find if the sql is using the SQL Patch

    Updated: 2023-09-13 06:12:00
    When we implement the SQL Patch for the statement, we would also like to confirm if the sql has started using the SQL Patch or not. We can use the below query to find out if the sql is using the SQL Patch How to find if the sql is using the SQL Patch col […] The post how to find if the sql is using the SQL Patch appeared first on Techgoeasy.

  • How to create SQL Patch for sql tuning in Oracle

    Updated: 2023-09-12 10:37:00
    SQL patch is a new feature from 12c onwards where we can insert hints into the sql statement using this feature. This is particularly useful when the application code cannot be modified and hints are providing the performance benefits. We have other tools like Sql profile, Sql plan baseline available also to to tune the […] The post How to create SQL Patch for sql tuning in Oracle appeared first on Techgoeasy.

Current Feed Items | Previous Months Items

Aug 2023 | Jul 2023 | Jun 2023 | May 2023 | Apr 2023 | Mar 2023