How to check datapump job status
How to check Export/Import data pump job status Monitor export/Import with the data pump views – The main view to monitor Export/Import jobs are dba_datapump_jobs and dba_datapump_sessions. set line 190… Read more »
How to check Export/Import data pump job status Monitor export/Import with the data pump views – The main view to monitor Export/Import jobs are dba_datapump_jobs and dba_datapump_sessions. set line 190… Read more »
How To Resolve Database Blocking In Oracle Database blocking is a situation where the statement run by one user locks a record or set of records and another statement run… Read more »
How to change RAC database NoarchiveLog Mod to Archivelog mode Login to one of the nodes (i.e. linux Node1) and disable the cluster instance parameter by setting cluster_database to FALSE… Read more »
Oracle DBA interview questions and answers: What is the difference between Oracle DBA role and an Oracle Developer role in an organization? Are there any similarities between both? An Oracle… Read more »
How to check free space in UNDO tablespace select a.tablespace_name, SIZEMB, USAGEMB, (SIZEMB – USAGEMB) FREEMB from (select sum(bytes) / 1024 / 1024 SIZEMB, b.tablespace_name from dba_data_files a, dba_tablespaces b where… Read more »
Script for Oracle Database session,user,process and sid details. col OS_USER for a25 col SID for a10 col USERNAME for a20 col PID for a20 select substr(a.spid,1,9) pid, substr(b.sid,1,5)… Read more »
Datapatch apply steps on 12c Databases after patch- Run the below steps to apply datapatch for all the databases running on 12C RDBMS home. Set environment . oraenv 12c_DBname Sqlplus… Read more »
Catbundle apply steps after RDBMS 11g Patching 1: Catbundle apply and post installation script implementation – Run the below steps to apply post install scripts and catbundle for all the… Read more »
Switchover using traditional manner – Without DG Broker approach (Manual database Switchover) Preparation before switchover: (Pre-Work) (1)Check both Primary and standby databases in Sync , there is no archive log gap…. Read more »
Data guard switchover physical standby- Switchover using DataGaurd Broker- Follow given steps to switchover databases through data guard broker dgmgrl. (1)Login to primary & standby hosts and . oraenv to… Read more »