Step by Step Drop Database using DBCA in Oracle In this article, we are going to demonstrate Step by Step DROP database using DBCA (GUI) in Oracle. Generally, we do drop the database when application testing completed or not require anymore to business. We can drop the database using the below methods: 1. Manual (Command
Step by Step How to increase SGA size in Oracle I was facing a memory issue in my environment after validating the AWR and ADDM reports and came to the conclusion that SGA is undersized. Below are both options to increase SGA_MAX_SIZE and SGA_TARGET size using pfile & spfile. in our environment, it’s running using
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
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
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
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
How to Find User’s Privileges in Oracle In this article, we are going to find all forms of privileges of users in Oracle. Commonly users have the below types of access in databases which are important to perform day-by-day activities according to their roles & responsibilities. System Privileges Role PrivilegesObject Privileges Privileges are authentication to execute any activities in the database
Important Technical Links Powered by DBsGuru About Us DBsGuru is a group of experienced DBA professionals and serves the database and its related community by providing technical blogs, projects, training. Technical blogs are the source of vast information not about databases but its related product like middleware, PL/SQL, replication methodology, and so on. We are
