Combo Patch Apply on Primary & Standby Database in Oracle In this article, we are going to demonstrate step by step apply combo patches on Oracle Primary & Standby (DATAGUARD) which released in January 2021, combo patch contains PSU (31985579) and OJVM (32119956) patches. Below is the database, system, patch id, etc. details. COMPONENTS PRIMARY
How to Check PGA full information in Oracle. A Program Global Area (PGA) is a memory region that contains data and control information for a server process. It is nonshared memory created by Oracle Database when a server process is started. Access to the PGA is exclusive to the server process. There is one PGA for
How to Check Long Running Job in the Oracle Database Sometimes in the database, few queries are taking a long time to complete the query, to validate which query taking a long time. Below is the query to check the long-running jobs/queries in the database where: SOFAR:- Total block Processed. TOTAL WORK:- Total work Block
How to Enable GUI in LINUX 7 Inside Oracle VM In this article, we are going to demonstrate how to enable/install GUI mode in LINUX 7.9 in side Oracle VM. This situation occurs when we don’t select the correct available option while installation for GUI/missing require packages. So when we start the server, we get
Mysql Logical Backup using mysqlpump – Export In this article, we are going to demonstrate Mysql Logical Backup using mysqlpump – Export. There are several ways to backup MySQL data. Those are: – 1) Physical Backup 2) Logical Backup Physical
Step-by-Step Approach For Applying PSU Patch in Oracle 12c For Single-Instance In this article, we are going to see Oracle12c Step-by-Step Applying PSU Patch For Single-Instance database. List of the steps to follow during the activity : Check the current version of Opatch Tool Upgrade the Opatch utility if needed Take the backup of ORACLE_HOME Shutdown
Step by Step guide for Table Refresh using DataPump Utility Oracle Data Pump is a high-speed data movement utility provided by Oracle (10g onwards). It’s an extension to the old EXP and IMP utility with improved performance and enhanced security features. Requirement of Table refresh: Table refresh is a common task that is quite often
Step by Step guide for Full Database Refresh using DataPump Utility Oracle Data Pump is a high-speed data movement utility provided by Oracle (10g onwards). It’s an extension to the old EXP and IMP utility with improved performance and enhanced security features. Here we are performing a full database refresh activity using Datapump: PARAMETERS SOURCE
Steps by steps to run SQL Tuning Advisor in Oracle As we all know running a slow query is a major performance issue in the database also has the biggest challenge for DBA to resolve this issue. Resolving the slowness issue we are using an Oracle tool called SQL Advisor. When you run SQL advisor
Oracle Critical Database Patch IDs for January 2021 An Essential/Critical Patch Update could be a collection of patches for multiple security vulnerabilities. These patches address vulnerabilities in Oracle code and third-party elements enclosed in Oracle merchandise. These patches are sometimes additive, however every informative describes only the protection patches intercalary since the previous essential Patch
