ORACLE

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-676a2edd117dc537775019/] 2. …

Today, we will discuss how you can define database-based authorizations for your user created on a database basis in PostgreSQL. Authorizations defined on a database …

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 …