Posted by Mir Sayeed Hassan on 30th March 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.
Posted in DBA Administration | No Comments »
Posted by Mir Sayeed Hassan on 30th March 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 | No Comments »
Posted by Mir Sayeed Hassan on 9th March 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