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 …
Oracle ASM is widely used in the IT industry. In this post, I have compiled the Top 46 Oracle ASM Interview Questions to enhance knowledge about Oracle ASM instances. These questions are good for basic and experienced levels. We have also given the advanced Level Interview questions Basic Level Oracle ASM Interview Questions Question 1 What …
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 …
ORA-00937: not a single-group group function is one of the common messages we often get while aggregating data. Causes of ORA-00937: not a single-group group function This error happens when you are using a mixture of individual columns and aggregate functions in the same select statement without using any group by clause with that individual …
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 »
