Oracle Performance Tuning
A complete production-ready SOP for Oracle Database real-time performance tuning. Covers AWR, ADDM, ASH report generation and analysis, wait event analysis, SQL…
A complete production-ready SOP for Oracle Database real-time performance tuning. Covers AWR, ADDM, ASH report generation and analysis, wait event analysis, SQL…
A complete production-ready SOP for upgrading Oracle Database from 11g/12c/18c to 19c on Linux. Covers pre-upgrade checks, preupgrade utility, upgrade methods, post-upgrade…
A complete production-ready SOP for Oracle RMAN backup and recovery on Linux. Covers RMAN configuration, full and incremental backups, archivelog backups, backup…
A complete production-ready SOP for configuring Oracle Transparent Data Encryption (TDE) on Linux from scratch. Covers wallet creation, master encryption key generation,…
A complete production-ready SOP for installing and configuring Oracle Enterprise Manager Cloud Control 19c on Linux from scratch. Covers OMS prerequisites, repository…
A complete production-ready SOP for installing and configuring Oracle GoldenGate 19c on Linux from scratch. Covers GoldenGate architecture, source and target preparation,…
A complete production-ready SOP for patching Oracle Data Guard 19c on Linux. Covers the rolling patch method using the standby-first approach, Grid…
A complete production-ready SOP for configuring Oracle Data Guard 19c from scratch. Covers primary database preparation, standby database creation using RMAN active…
A complete production-ready SOP for patching Oracle RAC 19c on Linux. Covers both rolling and non-rolling patch methods, Grid Infrastructure patching, ASM…