Oracle Database

Here are some of the Top Useful Queries for SQL Patch in Oracle Database Query to find the hints associated with a SQL Patch select cast(extractvalue(value(x), ‘/hint’) as varchar2(500)) as outline_hints from xmltable(‘/outline_data/hint’ passing (select xmltype(comp_data) xml from sys.sqlobj$data where signature = (select EXACT_MATCHING_SIGNATURE from v$sql where sql_id = ‘&SQL_ID’))) x; How to find all …

Top SQL Patch Queries in Oracle Database Read More »

When we implement the SQL Patch in Oracle 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 …

how to find if the sql is using the SQL Patch Read More »

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, and Sql plan baseline available to tune the application …

How to create SQL Patch in Oracle Read More »

In this article, we check about How to Configure Auto Login TDE Wallet. When we configure the TDE wallet, we need to explicitly open it after each database restart. ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY <wallet password> ; we can verify the status of the wallet as select wallet_type from v$encryption_walletwallet_type————-Password We can …

How to Configure Auto Login TDE Wallet Read More »

When we implement the sql profile for the statement, we would also like to confirm if the sql has started using the sql profile or not. We can use the below query to find out if the sql is using the sql profile How to find if the sql is using the sql profile col …

how to find if the sql is using the sql profile Read More »