Oracle database backup report from OEM repository
To generate a report of all full and incremental backups from an Oracle Enterprise Manager (OEM) database, you can use the following SQL query. This query retrieves information from the… Read more »
Search Results for:
Mastering Oracle Database: Interview Questions and Answers
Oracle Database Architecture: A Comprehensive Overview Oracle Database architecture is a sophisticated and multi-tiered system designed to efficiently manage and process data. It consists of several key components distributed across… Read more »
GoldenGate benefits for replication of Oracle database environments
Real-Time Data Replication: GoldenGate enables real-time data replication with low-latency updates, ensuring that changes from the source database are propagated to the target in near real-time. This is crucial for… Read more »
Protected: Golden gate Monitoring
There is no excerpt because this is a protected post.
Protected: upgrade oracle database 12c to 19c
There is no excerpt because this is a protected post.
Oracle Database Daily Scripts
Database_STATUS set line 190 Select db_unique_name,open_mode,database_role,(select host_name from v$instance) HOST_NAME from v$database; Check the Oracle Instance Startup Time SET LINES 200 SET PAGES 999 COLUMN INSTANCE_NAME FOR A20 SELECT INSTANCE_NAME,TO_CHAR(STARTUP_TIME,… Read more »
Golden Gate interview questions and answers
Oracle Golden Gate interview questions and answers Q: What is Oracle GoldenGate? A: Oracle GoldenGate is a real-time data integration and replication tool that allows you to capture and deliver… Read more »
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 »
About me
Pankaj Yadav Sr.Database Administrator (Oracle/PostgreSQL/Sql Server) Oracle Certified Professional Nashville, Tennessee, USA pankaj.mcajnp@gmail.com https://www.linkedin.com/in/pankajdba https://www.oracleworlds.com/about-me/ As a Senior Oracle Database Administrator, I am highly skilled and experienced professional who has… Read more »
Azure PostgreSQL Flexible Server
PostgreSQL Flexible Server, which is a fully managed database service offered by Microsoft Azure. PostgreSQL Flexible Server is a managed database service that allows users to run PostgreSQL in a… Read more »