Archive for June 2021

Upgrade Oracle Database from 12c to 19c using AutoUpgrade utility 5 (4)

June 13, 2021

Upgrade Oracle Database from 12c to 19c using AutoUpgrade utility Upgrading a database is always a big task for DBAs in this world but this time Oracle introduces a new…

Loading

📌
6💬 read more

Similarities Between Oracle and PostgreSQL 5 (1)

June 11, 2021

Similarities Between Oracle & PostgreSQL In this blog, we will compare similarities between Oracle & PostgreSQL in terms of Memory, Process, Files, General architecture, etc. COMPONENTS ORACLE POSTGRESQL Architecture: Memory…

Loading

📌
5💬 read more

Solution for OGG-00516 Fatal error executing DDL replication in Oracle Goldengate 0 (0)

June 10, 2021

Solution for OGG-00516 Fatal error executing DDL replication in Oracle Goldengate In this blog, we will perform a solution to resolve OGG-00516 Fatal error executing DDL replication.This error occurs when…

Loading

📌
4💬 read more

Tablespaces in PostgreSQL 0 (0)

June 9, 2021

Tablespaces in PostgreSQL A tablespace allows superusers to define an alternative location on the file system where the data files containing database objects (such as tables and indexes) can reside….

Loading

📌
4💬 read more

Vacuum and Autovacuum in PostgreSQL 5 (2)

June 8, 2021

Vacuum and Autovacuum in PostgreSQL In this article, we will understand the detailed concept of Vacuum & Autovacuum along with practical examples of the same. Vacuum Whenever we run an…

Loading

📌
2💬 read more

Configure WAL Archiving in PostgreSQL 0 (0)

June 5, 2021

Configure WAL Archiving in PostgreSQL WAL is short for Write Ahead Log. In PostgreSQL terms, copying out generated WAL files is called archiving,If you save a copy of each WAL…

Loading

📌
6💬 read more

How to Grant READ ONLY Access on Schema Using ROLE in Oracle 0 (0)

June 3, 2021

How to Grant READ ONLY Access on Schema Using ROLE in Oracle This is a very frequent and common request by developers to grant READ ONLY access to specific application…

Loading

📌
4💬 read more

Postgresql Architecture – Physical Storage Structure 5 (2)

June 2, 2021

Postgresql Architecture – Physical Storage Structure In this blog, we will discuss PostgreSQL architecture of physical storage which can be categorized in below four part: 1. Data Directory 2. Physical…

Loading

📌
4💬 read more