Sessions belonging to database statistics collection jobs can sometimes remain active. In this article, we will discuss how to identify and terminate these sessions. 1. …

In today’s article, we will be learning how to Check ALERT LOG Output in Database. We can query the errors encountered in the database directly …

In today’s article, I will be giving you information about active, inactive and other Session Statistics in the database. Active Session Statistics 1. We can …

In today’s article, we will discuss checking for LOCKs in the database, which is one of the checks we perform when there is a problem …

This error is occurs because the statistics belonging to the External Table cannot be collected while collecting the statistics belonging to the tables. Solution: We …

In today’s article we will be discussing how to remove GoldenGate in Oracle. The GoldenGate application is automatically removed by following the steps below. 1. …

In today’s article, we will be talking about how to install Oracle GoldenGate 12.2.0.0.0. Before starting the GoldenGate installation, GRID, RDBMS and Database are installed …

In today’s article, we will be talking about the three basic commands of Oracle Enterprise Manager: Start, Status and Stop. 1. Start OEM; [crayon-6aa5342cd2a7b826280001/] 2. …

In today’s article, we will be covering How to Start, Stop and View the Status of Oracle Enterprise Manager. START 1. Connect to the DB …

In today’s article, we will explain step by step how to install Oracle Enterprise Manager with DBCA. 1. We open a new terminal window on …