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
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
Step by Step Apply Patch ODA X7-2M from 18.3 to 18.8 In this article, we are going to demonstrate step by step to apply the server patch on ODA (Oracle Database Appliance) X7-2M from 18.3 to 18.8 i.e upgrade ODA version from 18.3 to 18.8. To apply the server patch on Oracle Database Appliance (ODA).
Steps to Upgrade Java version in Weblogic 12.2 In this article, we are going to perform a change Java version in Weblogic 12.2. There are 2 methods to change Java versions in Weblogic 12c. 1. Installed JAVA tar file in a new location and changed JAVA version/location in all respected scripts. 2. Best and simple
How to Enable 64bit option in Oracle Virtual Machine while OS Installation on Windows Here we are going to demonstrate how to enable 64bit option in Oracle virtual machine (VM) while installing an operating system (OS). This issue may persist due to the VIRTUALIZATION option is DISABLED in BIOS especially when we configure a new
How to Check Retention Period of AWR Snapshot in Oracle AWR (Automatic Workload Repository) is a key to diagnose the performance of Oracle database, AWR collects various types of processes along with maintains statistics of database performance. Below is the SQL command to Check the Retention Period of AWR Snapshot in Oracle. We always encourage the technical
Step by Step Drop Database Manually in Oracle Sometimes we need to drop/delete the database, especially for the test and development databases. Usually, we drop test or development database once the application team’s testing completed and this database seems not to be in use. Key Points to remember before dropping the databases. =>
