Career transition from on-premises DBA to cloud dba
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 »
Author Archives: Pankaj Yadav
Oracle ASM- Automatic Storage Management Interview Question Answer
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 »
Protected: Oracle golden gate step-by-step configuration
There is no excerpt because this is a protected post.
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 »
JServer JAVA Virtual Machine Component Invalid
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 »
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 »
how to resolve ORA-31623: a job is not attached to this session via the specified handle
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 »
How to transfer logins and passwords between instance of sql server
Transfer sql server login from one source server to target server sp_help_serverlogin is a stored procedure which helps to transfer logins and passwords from one instance of a server to… Read more »
Update maintenance window duration in oracle database
Update maintenance window duration in oracle database- Scenario- Current issue is we have default database level gather stats scheduled and maintenance window is 4 hrs, but maintenance task is not… Read more »
Script to check Running database operations in oracle database
Script to check Running database operations in oracle database. This script will provide you the details that what all operations working in background and what all those session related to,… Read more »