ORACLE

In today’s article, we will learn how to Add Data File to Tablespace with queries step by step. 1. Columns and data types are learned …

In today’s article, we will explain how to increase a tablespace in an Oracle Database after determining the sizes of the Disk Groups. When increasing …

In this article, we will examine the methods for granting a user access privileges to all tables in the database. 1. Log in to the …

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 …