Find table’s statistics are LOCKED or UNLOCKED in Oracle Table’s statistics is a key role in terms of performance along with the execution plan of SQL’s statements. Here we demonstrate how to find the table’s statistics are LOCKED or UNLOCKED in Oracle. Some time due to performance issues or on-demand business impact or auto-enable statistics
Find Last Successful Login Date in Oracle Oracle12c new features To find the last successful login date in oracle is now easy to retrieve from supporting version 12c onwards i.e this is a new feature of Oracle 12c. The question comes to mind why we require the user’s last successful login date, it may be
Add datafile into tablespace in Oracle Most of the time due to the application’s DML operation, tablespace crosses their threshold. As everyone knows it’s a critical scenario, if we ignore/skipped adding space into tablespace it may cause the application at a hung state or the database to a hung or down. To avoid this cause
How to check Connected Sessions along with Network Authentication in Oracle Here we are going to share SQL code to check connected sessions along with network authentications which show additionally network-related stuff like client connections, client version, client driver, network service banner, etc. In day-by-day usage as a DBA, we have to validate connected sessions,
Step by Step Utility “OPatch” Upgrade along with Latest Download Binary in Oracle I was applying the October patch on my 12.2.0.1 Oracle home and it got failed with the below error in prechecks due to the version of utility “OPatch” didn’t meet to minimum required version as per Oracle recommendations. So always recommended going
Steps to compile invalid public synonyms In my environment after doing an application upgrade some of the public synonyms get invalid. Below is the query to check invalid public synonyms or if you want to check the invalid objects in the database. Click here for sample output. Invalid object in database Below is SQL command
Find Date after Upgrade or Downgrade in Oracle Today, my one DBA friend asked about how to validate the database upgraded or downgraded from which version along with what was the date. So, I thought it better to publish which helps my DBA friends. Below is an SQL command to validate in the database about
Oracle Critical Database Patch IDs for October 2020 Patch Release by Oracle An Essential/Critical Patch Update could be a collection of patches for multiple security vulnerabilities. These patches address vulnerabilities in Oracle code and in third-party elements enclosed in Oracle merchandise. These patches are sometimes additive, however every informative describes only the protection patches intercalary
ORA-01102: Cannot Mount Database in EXCLUSIVE mode When we are doing database refresh from Prod to Dev (lower environment), At that time we put the cluster database parameter to false. This parameter is spfile file specific, so we need to bounce the database. After the refresh completed successfully, we are masteron steroids trying to start
Find Total, Free & Utilized values of PROCESSES, SESSIONS & TRANSACTIONS SQL command for standalone database. Click here to get sample output. SQL command for RAC database. Click here to get sample output. Click here for “How to increase Processes, Sessions and Transactions Initialization Parameters” We always encourage the technical person to visit section SCRIPTS to get
