• Home
  • About
  • Log In
  • Register
  • Job Openings
Follow Us
KTEXPERTS
  • Oracle DBA
    • Oracle 12C New Features
      • Oracle Multitenant Features
      • Non Container Features
    • Oracle Architecture
      • Oracle Server Architecture
      • Oracle Background Processes
      • Oracle Pyhisical Database
      • Select and Update Statement
      • Startup and Shutdown Modes
      • Redolog File Management
      • User Management
        • RMAN (Recovery Manager)
        • Oracle Production Support Scripts
    • Oracle Tablespace Management
    • Oracle Datapump (Exports & Imports)
    • Performance Tuning
    • Oracle Dataguard
    • Oracle ASM
    • Oracle Auditing
    • Oracle Partitioning
    • SecureCRT
    • Partitions/Shell Script
  • Oracle RAC
    • Introduction to Oracle RAC
    • 11gR2 RAC Installation
    • 12cR2 RAC Installation
    • 19c RAC Installation
    • Flashback Restore on Two Node RAC Servers
  • GoldenGate
    • Oracle to Oracle GoldenGate Unidirectional Replication
    • MySQL to Oracle Heterogeneous Replication
    • Oracle to MySQL Heterogeneous Replication
    • CredentialStore in Goldengate
    • GoldenGate Monitoring Commands
    • Usage of HandleCollisions and No HandleCollisions
    • Goldengate subdirs
    • Enable/Disable DDL replication
    • Data Selection & Filtering
    • Automation scripts in Goldengate
    • Logdump utility
    • Initial loads with GoldenGate
    • IgnoreDelete and IgnoreUpdate parameters in GG
    • COLS & COLSEXCEPT FILTER in GG
    • Add new table to existing GoldenGate Replication
      • Cassandra
  • AWS
    • EC2 (Elastic Compute Cloud)
    • S3 (Simple Storage Service)
    • IAM (Identity and Access Management)
    • CloudWatch
    • VPC (Virtual Private Cloud)
    • Route 53
    • RDS
    • Dynamo DB
    • EFS (Elastic File System)
    • Cloud Trail
    • Cloud Front
    • SNS (Simple Notification Service)
    • SQS (Simple Queue Service)
    • SES (Simple Email Service)
    • Redshift
    • Elastic Cache
    • Snowball
  • SQL Server
  • DevOps
    • LINUX
    • GIT
    • Chef
    • Ansible
    • Docker
    • Maven
  • MySQL
    • MySQL Installation & Upgrade
    • MySQL DBA
    • Difference Between Oracle and MySQL
  • PostgreSQL
    • Installation of PostgreSQL
    • WAL Internals in PostgreSQL
    • Replication to GCP PostgreSQL
    • Level of Work in Postgres Database
    • Data Fragmentation in PostgreSQL
    • PostgreSQL Interview Q&A
    • PostgreSQL Commands
  • Authors
    • Authors
    • Speakers
    • Volunteers
  • INDEX
    • Oracle DBA
      • Performance Tuning
      • Oracle RAC
      • Oracle 12c New Features
      • Oracle Production Support Scripts
      • Oracle DataGuard
      • Data Pump (Export & Import)
      • Oracle 18c
      • RMAN (Recovery Manager)
      • Oracle Tablespaces
      • Oracle ASM
      • Oracle Partitioning
      • Oracle Architecture
    • PostgreSQL
    • AWS
    • DevOps
    • GoldenGate
    • Cassandra
    • SQL Server
    • Oracle RAC
    • MySQL
    • SecureCRT
  • Webinar Recordings
  • Daily Tips
    • Oracle DBA Tips
    • GoldenGate Tips
    • MySQL Tips
    • SQL Server Tips
    • PostgreSQL Tips
    • MongoDB Tips
    • DevOps Tips
    • Exadata Tips
    • Python Tips
    • Data Science Tips
    • AWS Tips
    • .NET Tips
    • Linux Tips
  • Python
  • MongoDB

Postgres

Tablespace Administration in Postgres – Q&A

Tablespace Administration in Postgres – Q&A

1 year ago by Mitesh R SettyPostgreSQL

Tablespace Administration in Postgres – Q&A 1.  What is tablespace in Postgres? A. It specifies in which location contents of the tables should be stored. We can’t use a database without tablespace Default tablespace is pg_default Users while creating objects can specify on which tablespace… Read More

WAL Internals in PostgreSQL

WAL Internals in PostgreSQL

1 year ago by Ankit GoyalPostgreSQL

WAL Internals in PostgreSQL Write-Ahead Log (WAL) is a very important term in transaction processing. In PostgreSQL, it is also known as a transaction log. A log is a record of all the events or changes and WAL data is just a description of changes… Read More

Replication to GCP PostgreSQL Using  Oracle GoldenGate

Replication to GCP PostgreSQL Using Oracle GoldenGate

1 year ago by Ankit GoyalGolden Gate

Replication to GCP PostgreSQL Using Oracle GoldenGate Use Case: Real-time replication of transactional data from an on-premises database to GCP Managed PostgreSQL instance using GoldenGate. Architecture: Source Database (Source Database can be any GoldenGate supported databases)  Oracle GoldenGate (OGG) 19c/18c/12c for extraction from Source DB… Read More

Level of Work in Postgres Database

Level of Work in Postgres Database

3 years ago by Athar IshteyaquePostgreSQL

Dear Readers, In this article, we will see the Level of work. L1 Level Jobs Installation Postgres software as per standard document. Space monitoring for Table space, File system on Postgres db system etc. Logs monitoring for Backup, Index rebuilding and other maintenance jobs. Checking… Read More

Visa Sponsorship

Recent Comments

  • Binnary Ajay Kumar on How to move or rename Oracle Home
  • Prabhu on How to move or rename Oracle Home
  • Krishna on Protected: How to kill Long Running Query using scripts.
  • krishna on Linux Basic Commands for DevOps (PART-2)
  • Ankit on Data Fragmentation in PostgreSQL

Started ktexperts.com with a small hope of sharing knowledge, And today we can proudly say that ktexperts.com is being accessed from all corners of the world. Here’s a glimpse of our growth.

Categories

Ad

KT Experts Journey….! Watch and Subscribe Our KT Experts YouTube Channel.

https://www.youtube.com/watch?v=kzqFBMFlzRI

Recent Posts

  • Protected: OPERATORS IN PYTHON March 15, 2023
  • Protected: Installation of PostgreSQL March 15, 2023
  • Protected: Introduction to MongoDB March 11, 2023
  • Introduction to PostgreSQL March 6, 2023
  • FUNCTIONS IN PYTHON February 28, 2023
  • Table/index movement using pl/sql procedure February 23, 2023
  • Protected: Share Knowledge February 21, 2023

About KTEXPERTS

KT Experts is one enthusiastic knowledge-sharing platform. The platform concentrates on all Database Technologies like Oracle Database Administration(DBA), Oracle RAC, Oracle GoldenGate, MySQL, SQL Server Database Administration, Cassandra, AWS and DevOps.

This page consists of all the well-developed articles  of the Technologies. This is an effort of many dedicated professionals for a better IT world.

We have received the best reviews over time and the usage of this page has been increasingly drastic. So why wait? Let’s get started!!!

Thank you 

Follow Our Social Networking Sites

Recent Posts

  • Protected: OPERATORS IN PYTHON

  • Protected: Installation of PostgreSQL

  • Protected: Introduction to MongoDB

    Protected: Introduction to MongoDB

  • Introduction to PostgreSQL

    Introduction to PostgreSQL

  • FUNCTIONS IN PYTHON

    FUNCTIONS IN PYTHON

Our Partners

Scholar IT Solutions

Website Visitors


Locations of visitors to this page

COPYRIGHT © 2017 - KTEXPERTS.COM Back To Top
sponsored