0 Comments

Step by Step Combo Patch Apply (October 2021 Patch 19c) in Oracle 5 (3)

Step by Step Combo Patch Apply (October 2021 Patch 19c) in Oracle In this article, we are going to demonstrate step by step combo patch 33248420 (19.13.0.0.211019) of October 2021 in Oracle database version 19c. It’s also called an upgrade from database version 19.3.0.0 to 19.13.0.0. Here we will apply a combo patch 33248420 that […]

 1,449 Total Views,  10 Views Today

0 Comments

Monitor PostgreSQL Cluster using pgCenter 0 (0)

Monitor PostgreSQL Cluster using pgCenter pgCenter is a command-line admin tool for observing and troubleshooting PostgreSQL i.e monitor PostgreSQL cluster. Postgres provides various activity statistics about its runtime, such as connections, statements, database operations, replication, resources usage, and more. The general purpose of the statistics is to help DBAs to monitor and troubleshoot Postgres. However, […]

 215 Total Views,  2 Views Today

0 Comments

Install and Configure pg_repack in PostgreSQL 5 (1)

Install and Configure pg_repack in PostgreSQL pg_repack is a PostgreSQL extension which lets you remove bloat from tables and indexes, and optionally restore the physical order of clustered indexes. Unlike CLUSTER and VACUUM FULL it works online, without holding an exclusive lock on the processed tables during processing. pg_repack is efficient to boot, with performance […]

 685 Total Views,  18 Views Today

0 Comments

Install and Configure pgBadger in PostgreSQL Part-II 0 (0)

Install and Configure pgBadger in PostgreSQL Part-II This article is a continuation of the Installed pgBadger package in PostgreSQL click here to read more. In this blog, we will Configure PostgreSQL Cluster to use pgBadger. Since pgbadger reads the PostgreSQL logs and picks up the information, it is essential to make some changes on postgresql.conf […]

 363 Total Views,  5 Views Today

0 Comments

Oracle Critical Database Patch ID for October 2021 5 (1)

Oracle Critical Database Patch ID for October 2021 An Essential/Critical Patch Update could be a collection of patches for multiple security vulnerabilities. These patches address vulnerabilities in Oracle code and third-party elements enclosed in Oracle merchandise. These patches are sometimes additive, however every informative describes only the protection patches intercalary since the previous essential Patch […]

 2,126 Total Views,  11 Views Today

0 Comments

Install and Configure pgBadger in PostgreSQL Part-I 0 (0)

Install and Configure pgBadger in PostgreSQL Part-I pgBadger is a PostgreSQL log analyzer built for speed providing fully detailed reports based on your PostgreSQL log files.                                                           […]

 360 Total Views,  3 Views Today

0 Comments

PostgreSQL major version upgrade from 12.8 to 13.4 using pg_upgrade 0 (0)

PostgreSQL major version upgrade from 12.8 to 13.4 using pg_upgrade Current PostgreSQL version numbers consist of a major and a minor version number. For example, in version number 13.1, where 13 is the major version number and 1 is the minor version number. pg_upgrade is a utility to upgrade PostgreSQL Cluster to major version eg 10.7 to 11.2 or 12.1 to 13.4. pg_upgrade […]

 532 Total Views,  5 Views Today

0 Comments

PostgreSQL minor version upgrade from 13.1 to 13.4 0 (0)

PostgreSQL minor version upgrade from 13.1 to 13.4 Current PostgreSQL version numbers consist of a major and a minor version number. For example, in version number 13.1, where 13 is the major version number and 1 is the minor version number. Minor releases never change the internal storage format and are always compatible with earlier […]

 655 Total Views,  11 Views Today

0 Comments

Access Oracle database from PostgreSQL using Oracle Foreign Data Wrapper (ORACLE_FDW) 5 (1)

Access Oracle database from PostgreSQL using Oracle Foreign Data Wrapper (ORACLE_FDW) Nowadays many companies are using a mix of RDBMS systems, for example, some instances are running on Oracle and other instances are running on PostgreSQL, and if we want to access data we need to do it using a heterogeneous connection. Heterogeneous connections allow […]

 512 Total Views,  4 Views Today

0 Comments

RMAN Incremental Level 1 Differential and Cumulative Database Backup Scripts in Oracle 0 (0)

RMAN Incremental Level 1 Differential and Cumulative Database Backup Scripts in Oracle In this article, we are going to prepare a script for RMAN Incremental and differential Level 1 (L1) database backup which includes backup of datafiles (L1), control files, spfile along with archives. RMAN incremental backups back up only datafile blocks that have changed since […]

 710 Total Views,  10 Views Today