ORACLE

ADD-DROP Redo log files in Oracle Database 5 (4)

ADD-DROP Redo Log Files In Oracle Database In the real world, we may encounter scenarios where we need to or asked to increase/decrease the size of redo log files as…

Starting and stopping an Oracle ASM instance for Noncluster Databases 0 (0)

Starting and stopping an Oracle ASM instance for Noncluster Databases Oracle database is made up of memory structure, background processes, and database. This memory structure and background processes altogether called…

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…

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…

What is Cluster and How can we find if a Database is running on Cluster 4.6 (5)

What is Cluster and How can we find if a Database is running on Cluster Oracle Real Application Cluster provides its users to run a single database into multiple servers….

How to check size of a schema in Oracle 4 (3)

Check Schema size in Oracle A schema in an Oracle database is defined as a collection of database objects and is owned by a database user. The schema name shares…

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…

How to Validate Applied Patch in Oracle 12c 0 (0)

Validate Applied Patches in Oracle 12c Whenever we do patch apply before/after, need to validate all applied patches in Oracle home & databases. Below is the command to validate patches…