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 »
Displaying Report Generating the Date time and user name without Domain or System name: 1- Go to Design mode and Create footer in SSRS report 2- From The toolbox add… Read more »
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 »
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 »
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 »
There is no excerpt because this is a protected post.
There is no excerpt because this is a protected post.
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 »
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 »
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 »
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 »
Transitioning from an on-premises DBA role to a cloud DBA role can be a rewarding career move as more and more companies are adopting cloud technology. Here are some steps… Read more »