Mir Sayeed Hassan – Oracle Blog

Oracle DBA – Tips & Techniques | Learn with real-time examples

  • Translate

  • It’s Me






  • My Certificates

  • Links

    My Acclaim Certification : Credly Profile
    My Oracle ACE Pro Profile

  • Achievements

    Awarded Top 100 Oracle Blogs from Worldwide - #RANK 39
  • VISITORS COUNT

  • Verified International Academic Qualification from World Education Service (WES)

    Verified International Academic Qualification from World Education Service (WES)

  • Jobs

Archive for March, 2025

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 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 »

How big organizations maintain their data and Oracle Database Administrator tasks performed in it.

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 »

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 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