Author Archives: Pankaj Yadav

Database Contents

Introduction to Databases: What is a database? What are the different types of databases? Why are databases important in today’s world? Relational Databases: What are relational databases? How do they… Read more »

Check the Oracle Database size CDB and PDB

Following Queries for NON-CDB database:Check the database physical consumed size select sum(bytes)/1024/1024/1024 size_in_gb from dba_data_files; Total space used by the data in the database. select sum(bytes)/1024/1024/1024 size_in_gb from dba_segments; Check… Read more »

Oracle Golden Gate Overview & Components

Introduction to Oracle GoldenGate Oracle Goldengate enables the exchange and manipulation of data at the transaction level among multiple, heterogeneous platforms. Oracle GoldenGate Architecture allows to replicate selected data, transactional… Read more »