DATABASE

How to Check Long Running Job in the Oracle Database 4.5 (2)

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…

Step by Step Apply Patch on Oracle DB Home (January 2021) 5 (1)

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…

Table Refresh Using EXPDP-IMPDP Datapump Command 0 (0)

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…

Oracle Critical Database Patch IDs for January 2021 5 (1)

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…

MySql File-based Master Slave Replication – All Database 0 (0)

MySql File-based Master Slave Replication – All Database Replication enables data from one MySQL database server to be copied to one or more MySQL database servers. Replication is asynchronous by…

Solution for MySql – ERROR 1819 (HY000): Your password does not satisfy the current policy requirements 0 (0)

Solution for MySql – ERROR 1819 (HY000): Your password does not satisfy the current policy requirements When you install Mysql Server using YUM Repository method Click here to read more…

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…

Step by Step Drop Database Manually in Oracle 5 (2)

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…

How to Find User’s Privileges in Oracle 3 (2)

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…