Here we are going to demonstrate step-by-step Oracle database upgrades from 11g (11.2.0.4) to 12c (12.2.0.1), same steps can be followed to upgrade to 12.1.0.2 as well.…
View More Step by Step Oracle Database Upgrade from 11g (11.2.0.4) to 12c (12.2.0.1) using DBUA
Part I – Installing and patching the software Occasionally during our regular DBA tasks, we get a client request or simply notice the need and…
View More How to Upgrade from 11.1.0.7 to 11.2.0.3 on Linux
Starting with Oracle Database 12.2.0.1 the orapwd utility – used to create Password Files for remote authentication – enforces complexity rules for the provided password.…
View More orapwd enforces password complexity rules in 12.2.0.1
In this post, I will walk you through on how to perform load balancing and connection pooling with PgPool-II, what are the benefits and motivation…
View More PostgreSQL Connection Pooling and Load Balancing with PgPool-II Cluster
In this article, I will share how upgraded the PostgreSQL from 11.9 to 12.4 in AWS RDS. Make sure that you thoroughly test after the…
View More Upgrading the PostgreSQL DB engine for Amazon RDS from 11.9 to 12.4
Queries returning aggregate, summary, and computed data are frequently used in application development. Sometimes these queries are not fast enough. Caching query results using Memcached…
View More Materialized View Strategies Using PostgreSQL
Window Functions Window functions allow you to perform calculations across a set of rows that are related to the current row. For example; we have…
View More Advanced SQL Techniques You Should Know
There are three types of developers: those who know that indexes speed up database queries, those who know that indexes speed up database queries and…
View More Understanding database Indexes in PostgreSQL
Adding, tuning and removing indexes is an essential part of maintaining an application that uses a database. Oftentimes, our applications rely on sophisticated database features…
View More Understanding Postgres GIN Indexes: The Good and the Bad
Database performance tuning: developers usually either love it or loathe it. I happen to be one that enjoys it and want to share some of…
View More Performance Tuning Queries in PostgreSQL