Posts by DBsGuru

How to find table’s statistics are LOCKED or UNLOCKED in Oracle 5 (1)

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 Last Successful Login Date in Oracle 5 (1)

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…

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…

How to Check Connected Sessions along with Network Authentication in Oracle 5 (3)

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…

Step by Step OPatch upgrade in Oracle 4.7 (3)

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…

How to Compile Invalid Public Synonyms 4 (1)

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…

How to Find Date after Upgrade or Downgrade in Oracle 5 (1)

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…

Oracle Critical Database Patch IDs for October 2020 5 (1)

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…

ORA-01102: Cannot Mount Database in EXCLUSIVE mode 5 (2)

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….

How to Find Total, Free & Utilized values of PROCESSES, SESSIONS & TRANSACTIONS in Oracle 0 (0)

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…