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 »
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 »
To be addressed : 1.How to enable monitoring 2.Regular maintenance tasks 3.DB refresh , How to handle it ? Prerequisites : Source : Establish network connectivity between source and target… Read more »
JServer JAVA Virtual Machine Component Invalid Symptoms: The JAVAVM Component has become invalid in the database.Check the status of all the components in the database. SQL> col comp_id for a10… Read more »
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 »
ORA-31623: a job is not attached to this session via the specified handle ===================== -Issue- When performing Import via impdp, following error is coming:ORA-31623: a job is not attached to… Read more »