Hello and welcome to DBsGuru,I’m Jamsher Khan working as Senior Oracle DBA based in KSA-Jeddah, I have working experience in Oracle DBA, SQL Server, MySql, PostgreSQL, Linux, Golden Gate, ODA.Thanks for the visits!Share Learn Grow!

  • Role: author
  • Number of posts: 140
  • Registration Date: December 16, 2020
  • Website: https://dbsguru.com

Last comments from Jamsher Khan

Posts by Jamsher Khan

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

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

Postgresql Architecture – Process 5 (1)

May 30, 2021

Postgresql Architecture – Process In the previous blog, we looked at Memory Components in PostgreSql, Click here to read more. In this post we will discuss the Process of PostgreSQL,…

Loading

📌
2💬 read more

PostgreSQL Architecture – Memory Components 5 (1)

May 26, 2021

PostgreSQL Architecture – Memory Components In this post we will discuss Memory Components of PostgreSQL, Memory Components in PostgreSQL can be divided mainly into two category memory region 1). Shared…

Loading

📌
2💬 read more

Configure another instance of PostgreSql and administer using systemctl 3 (2)

May 24, 2021

Configure another instance of PostgreSQL and administer using systemctl In the previous post, we saw How to Install PostgreSQL 13 on Linux Using YUM Command. In this blog, we will…

Loading

📌
0💬 read more

Schema in PostgreSQL 0 (0)

May 21, 2021

Schema in PostgreSQL In PostgreSQL, a schema is a namespace that contains database objects such as tables, views, indexes, data types, functions, stored procedures. A database can contain one or…

Loading

📌
0💬 read more

Create, Drop, Alter Roles in PostgreSQL 0 (0)

May 19, 2021

Create, Drop, Alter Roles in PostgreSQL PostgreSQL represents accounts as roles. PostgreSQL uses roles to represent user accounts. It doesn’t use the user concept like other database systems Oracle &…

Loading

📌
0💬 read more