Mir Sayeed Hassan – Oracle Blog

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

Archive for April, 2026

Oracle RMAN Configuration for Optimizing Backup and Recovery using the RMAN Utility.

Posted by Mir Sayeed Hassan on 25th April 2026

Oracle RMAN Configuration for Optimizing Backup and Recovery using the RMAN Utility. Overview: The RMAN configuration parameters are set to default rules for performing the backup and recovery in Oracle databases using CONFIGURE commands and they control retention, backup type, device usage, and automation. therefore this settings are ensure consistent… Read more..

Posted in RMAN | Comments Off on Oracle RMAN Configuration for Optimizing Backup and Recovery using the RMAN Utility.

Different Methodologies of Working with Data Pump scenarios in Oracle Database 19C

Posted by Mir Sayeed Hassan on 16th April 2026

Different Methodologies of Working with Data Pump scenarios in Oracle Database 19C Oracle Data Pump is a high-performance utility for performing the database data. This dumpfile can be used to import the same data and structures into same database or another Oracle database environment for migration purpose, making it a key tool for backup, migration, Read More

Posted in Datapump (Expdp/Impdp) | Comments Off on Different Methodologies of Working with Data Pump scenarios in Oracle Database 19C

Use Segment Advisor in Oracle Database for Space Management Optimization 

Posted by Mir Sayeed Hassan on 11th April 2026

Use Segment Advisor in Oracle Database for Space Management Optimization  Overview Segment Advisor in Oracle Database helps identify and reclaim unused space in database segments such as tables and indexes. It provides recommendations like segment shrink and reorganization to optimize storage… Read more..

Posted in DBA Administration | Comments Off on Use Segment Advisor in Oracle Database for Space Management Optimization 

Essential ASMCMD and CRSCTL Commands as Key Expertise for Oracle DBAs

Posted by Mir Sayeed Hassan on 9th April 2026

Essential ASMCMD and CRSCTL Commands as Key Expertise for Oracle DBAs Overview: ASMCMD is a command-line utility in Oracle Automatic Storage Management (ASM) used by Oracle DBAs to manage ASM disk groups and files. It provides a Linux-like interface to perform navigation, monitor storage, and execute file operations. List All ASM Disk… Read more..

Posted in ASM | Comments Off on Essential ASMCMD and CRSCTL Commands as Key Expertise for Oracle DBAs

Oracle 19c Upgrade from 12c with Migration Planning and Execution in Real-time

Posted by Mir Sayeed Hassan on 5th April 2026

Oracle 19c Upgrade from 12c with Migration Planning and Execution in Real-time. Overview  Upgrading from Oracle Database 12c to 19c is essential for improved performance, security, and long-term support. Oracle 19c, as the long-term release, provides enhanced stability, better resource management, and… Read more..

Posted in UPGRADATION | Comments Off on Oracle 19c Upgrade from 12c with Migration Planning and Execution in Real-time