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 log switches creating contentions at the database. For example, by increasing the redo log file size, the number of log switches can be decreased which
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 Oracle Instance. The same as Oracle Database Instance ASM(Automatic Storage Management) instance is also built. It’s also having separate SGA(System global area) and background processes.
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
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
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. These multiple servers act as a single system. It provides fast recovery at the time of any site failure. To avoid the outage and provide
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 the same name as the user due to which both the terms are sometimes equipoise benefits used interchangeably though they are not the same. The
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
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 in Oracle 12c. Command to validate applied patches on Oracle home. Click here to get sample output. SQL Command to validate applied patches in Oracle
