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 »
There is no excerpt because this is a protected post.
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 »
ASM- Automatic Storage Management – Interview Question Answer 1. What is ASM?ASM is a Volume Manager and a file system for Oracle Database Files that supports single-instance Oracle Database and… Read more »