Below are some of the basic hygiene techniques and concepts we should keep in mind to get the maximum performance out of our query . …

The index scans are the table access paths used by the oracle optimizer to generate the best execution plan. There are different types of scans …

Automatically Run Configuration Scripts Before 19c in the oracle database software installation requires manual effort to run the root.sh scripts. But from 19c we can …

Before 12c if one of the standby database goes out of sync with respect to the primary database we have to perform the below steps …

Being a DBA we must know the difference between the SQL profile and the baselines. To start with we know that optimizer uses the information …