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
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. =>
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
Oracle Database 21c Available Innovation Release Oracle Database 21c is the most latest version released by Oracle which is an innovation release where it’s available only for Premier Support (PS) till 30th Jun 2023. In the currently available release, Oracle 19c is a long-term supported database by Oracle where it will support till 30th April 2027
