Posted by Mir Sayeed Hassan on September 17th, 2025
How to export the dumpfile backup in Pluggable Database(PDB) using expdp in 19C
Note: In Multitenant database., You will have the container database along with one or more PDB database.
Check the database status
SYS> select name, database_role, version from V$database, v$instance;
NAME DATABASE_ROLE VERSION
-------------------------------------
ORA19CDB...
Read more..
Posted in Datapump (Expdp/Impdp) | Comments Off on How to export the dumpfile backup in Pluggable Database(PDB) using expdp in 19C
Posted by Mir Sayeed Hassan on September 15th, 2025
How to generate the IOPS report in Oracle database 19c
Note: The report is created as per the requirement of the client from the databaase., Usually we should do it on regular basis for the analysis of the data.
Check the database
SYS> select name, open_mode, version from V$instance, v$database;
NAME OPEN_MODE VERSION
--------- --------------------...
Read more..
Posted in Performance Tuning(PT) | Comments Off on How to generate the IOPS report in Oracle database 19c
Posted by Mir Sayeed Hassan on March 30th, 2025
Find out the method to delete the existing/old log files automatically by using the ADRCI Utility in Oracle 19C Database.
Brief: To delete the existing/old log files from the database, there are 2 method to perform this operation
1-Manual
Traditional method to delete the old log files (alert, trace,.xml,.aud files) as discuss in below link.
Read more..
Posted in DBA Administration | Comments Off on Find out the method to delete the existing/old log files automatically by using the ADRCI Utility in Oracle 19C Database.
Posted by Mir Sayeed Hassan on March 30th, 2025
How big organizations maintain their data and Oracle Database Administrator tasks performed in it.
Here i have highlighter some of the major key points as per the requirement of the interview purpose for the candidates.
Large organizations handle vast amounts of data daily, and maintaining this data efficiently is crucial for operations, decision-making,...
Read more..
Posted in Interview Q & A | Comments Off on How big organizations maintain their data and Oracle Database Administrator tasks performed in it.
Posted by Mir Sayeed Hassan on March 9th, 2025
How to Manage the resource usage with concurrent job limit for each pluggable database using the Oracle Datapump in Oracle 19C
Brief: The parameter “max_datapump_jobs_per_pdb” is controls the maximum number of concurrent session in Data Pump jobs for each pluggable database.
Impact on this parameter: If you set this parameter to high value...
Read more..
Posted in Datapump (Expdp/Impdp) | Comments Off on How to Manage the resource usage with concurrent job limit for each pluggable database using the Oracle Datapump in Oracle 19C
Posted by Mir Sayeed Hassan on February 16th, 2025
How to Configure the Data Guard with Cascading Standby Database on Oracle 19C DB
Brief about this concept
– I would like to configure the data guard with the cascading standby database on Oracle Database 19C.
– To perform this we should have configure 1 Primary database, 2 Standby database
Flow should be like this
Posted in DataGuard (DR) | Comments Off on How to Configure the Data Guard with Cascading Standby Database on Oracle 19C DB
