Archives: All

Browse Through List of technical Blogs:

This section will list the blogs from all sections.  We can click any link to jump over.

Category:                      Lets Talk Oracle

December 22, 2025	ORA-01017: Invalid Username/Password – Complete Guide
December 18, 2025	DBA_HIST_ACTIVE_SESS_HISTORY: Complete Guide to Oracle ASH Analysis
December 15, 2025	How to Configure Oracle Listener for Standalone Database: Step-by-Step Guide
December 10, 2025	How to Configure Oracle Listener for Standalone Database: Step-by-Step Guide
December 10, 2025	ORA-01555: Snapshot Too Old – Complete Fix Guide for Oracle 19c
December 9, 2025	ORA-12154: TNS Could Not Resolve the Connect Identifier – Complete Fix Guide
December 9, 2025	Migrating Oracle 19c Database from Local Storage to ASM: A Complete Step-by-Step Guide
December 9, 2025	ORA-00257: Archiver Error Connect Internal Only Until Freed – Complete Resolution Guide
May 13, 2025	Oracle ASM 19c Installation: Complete Guide to Oracle Restart Grid Infrastructure [2025]
May 13, 2025	Response file for Oracle ASM Standalone Oracle 19c
April 25, 2025	How to Enable Archive Log Mode in Oracle 19c (Complete Guide)
February 19, 2025	Oracle Database Memory Monitoring Guide
February 14, 2025	How to Export NLS_DATE_FORMAT in Oracle: Data Pump Import Date Format Fix
February 10, 2025	ASMSNMP User Setup: Complete Oracle ASM Monitoring Guide
February 3, 2025	Resolving Pluggable Database (PDB) Opening in RESTRICTED MODE (ORA-65177) in Oracle 19c
October 8, 2021	Optimizer Access Paths: index unique scan
October 8, 2021	Optimizer Access Paths : Fast Full Scan
September 21, 2021	Oracle Direct Path Read: Complete Performance Guide with Real Examples
September 21, 2021	Optimizer Access Paths : What is Index Full Scan
September 17, 2021	Optimizer Access Paths: How Index FFS works with Distinct
September 17, 2021	Optimizer Access Paths: How oracle database works
October 13, 2017	Cloud database war: Advantage shifting to Red?
September 19, 2017	Drop a database
September 14, 2017	Data Pump: impdp
September 7, 2017	DBA_HIST_SEG_STAT: SQL Queries to Track Oracle Growth
September 1, 2017	Oracle Data Pump: expdp & impdp
August 30, 2017	Data Pump: a tool to backup and restore database
July 14, 2017	How to re-organize your data files of a tablespace
July 14, 2017	How to copy Multi terabyte data to another Database Server
July 14, 2017	Move DB with Oracle 11g Binaries
July 14, 2017	How to: Speed up Inserts in database

Category:                      Expertise PostgreSQL

December 22, 2025	Why PostgreSQL Beat Specialized Vector Databases: A DBA’s Perspective
December 17, 2025	PostgreSQL as Vector Database: Complete pgvector Installation & Configuration Guide [2025]
February 14, 2025	PostgreSQL Schema Resolution Issues in ETL Processes
February 12, 2025	PostgreSQL Read-Only User: Complete Permission Setup Guide
February 12, 2025	How to Install PostgreSQL 16 on RHEL 9/Red Hat Linux [2025 Guide]
February 7, 2025	PostgreSQL Configuration Parameters: Essential Settings Guide
January 21, 2025	Mastering PSQL: Enable Timings and Fetch All Rows Without Paging
October 5, 2021	Data Replication Setup Using Master and Slave: PostgreSQL- IV
October 5, 2021	Data Replication Setup Using Master and Slave: PostgreSQL- III
October 5, 2021	PostgreSQL Meta-Command using psql: Command Information -IV
September 21, 2021	Data Replication Setup Using Master and Slave: PostgreSQL – I
September 21, 2021	Data Replication Setup Using Master and Slave: PostgreSQL – II
September 21, 2021	Automating Master and slave replication: PostgreSQL – I
September 21, 2021	MVCC Concurrency Architecture: PostgreSQL way of implementation – III( pros/cons)
September 21, 2021	PostGIS Installation with PostgreSQL
September 21, 2021	What is a Database Cluster: PostgreSQL
September 21, 2021	PostgreSQL Meta-Command using psql: Command Information -III
September 17, 2021	PostgreSQL Meta-Command using psql: Command Information -II
September 17, 2021	MVCC Concurrency Architecture: PostgreSQL way of implementation – II
September 17, 2021	Concurrency Control in PostgreSQL
September 17, 2021	PostgreSQL Meta-Command using psql: Command Information -I
August 27, 2021	PostgreSQL Meta-Command using psql: Generic Information
August 27, 2021	PostgreSQL Installation on CentOS 7
March 25, 2021	PostgreSQL Installation on Ubuntu
February 15, 2021	Evolvement of PostgreSQL: Background

Category:                      Do the Mongo

August 27, 2021	How To: List keys of collection MongoDB
December 23, 2020	How To: List all indexes in MongoDB
February 20, 2019	How To: Creating a collection subset from collection in MongoDB
October 11, 2017	WiredTiger: A game changer for MongoDB
August 11, 2017	MongoDB Enterprise Edition Installation – Ubuntu
August 3, 2017	How to: Uninstallation of MongoDB on Ubuntu
August 1, 2017	MongoDB Installation – Ubuntu
July 14, 2017	Mongo DB – An Introduction

Category:                      TimeSeries Databases

July 13, 2018	InfluxDB: How to perform Quick cluster installation on CentOS
July 11, 2018	InfluxDB: How to perform a single node installation on CentOS
July 9, 2018	Time Series Database : Evolvement

Category:                      BigData

July 14, 2017	Reduce in MapReduce … Unwinding
July 14, 2017	MapReduce – Sort & Shuffle
July 14, 2017	MapReduce – Unwinding Map
July 12, 2017	MapReduce – Unwinding Algorithm
July 12, 2017	MapReduce : Fault Tolerance
July 12, 2017	MapReduce Internals: Philosophy
July 12, 2017	MapReduce : Internals
July 12, 2017	HDFS Architecture : Explained
July 12, 2017	Magic of Hadoop
July 12, 2017	Journey of Hadoop
July 10, 2017	Big Data: Introduction and 4V’s