Oracle Database 19c is the final long-term support release of the 19c family. Following proven best practices ensures better performance, security, stability, and easier maintenance.
1. Architecture & Installation Best Practices
- Always use Multitenant Architecture (CDB + PDB) for new deployments.
- Separate Oracle Home from data files and FRA (Fast Recovery Area).
- Enable Automatic Memory Management (AMM) or use appropriate SGA/PGA settings.
- Install latest RU (Release Update) / RUR patches regularly.
2. Database Configuration Best Practices
-- Enable key parameters
ALTER SYSTEM SET db_flashback_retention_target=1440 SCOPE=BOTH; -- 1 day
ALTER SYSTEM SET undo_retention=3600 SCOPE=BOTH;
ALTER SYSTEM SET enable_ddl_logging=TRUE SCOPE=BOTH;
ALTER SYSTEM SET diagnostic_dest='/u01/app/oracle/diag' SCOPE=BOTH;- Use Automatic Undo Management and set proper undo tablespace size.
- Enable Force Logging for GoldenGate / Data Guard setups.
- Configure proper REDO log size (minimum 1GB per group) and multiple groups.
- Turn on Automatic Statistics Gathering (default in 19c).
3. Security Best Practices
- Use Oracle Unified Auditing (recommended over traditional auditing).
- Implement Database Vault and Label Security where required.
- Enforce strong password policies and profile limits.
- Regularly rotate passwords and use Oracle Wallet for TDE (Transparent Data Encryption).
- Apply least privilege principle – avoid granting DBA role unnecessarily.
4. Performance Tuning Best Practices
- Regularly gather system statistics and fixed object statistics.
- Use AWR, ADDM, and ASH reports for performance analysis.
- Implement Index usage monitoring and rebuild indexes when needed.
- Use Real Application Testing (RAT) before major changes.
- Enable In-Memory Column Store for analytical workloads.
5. High Availability & GoldenGate Best Practices
- Use Data Guard for disaster recovery (Maximum Performance mode for most cases).
- For GoldenGate:
- Always enable supplemental logging at database and table level.
- Use dedicated GoldenGate tablespaces.
- Implement Checkpoint Table.
- Monitor lag using
LAG EXTRACT *and set alerts. - Use Parallel Extract/Replicat for high volume environments.
6. Backup & Recovery Best Practices
-- Configure RMAN
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;- Take consistent RMAN full + incremental backups.
- Test your recovery regularly (validate backups).
- Use FRA for archived logs and control file autobackups.
7. Monitoring & Maintenance
- Configure Enterprise Manager 13c or use Oracle Autonomous Health Framework.
- Set up alert notifications for ORA- errors, tablespace full, etc.
- Schedule regular purging of audit trails and trace files.
- Review alert log daily using ADRCI tool.
Conclusion
Implementing these Oracle 19c best practices will significantly improve your database reliability, performance, and security. Always test changes in a non-production environment first and refer to the latest Oracle documentation for your specific environment.
This post is for educational purposes. Best practices may vary based on workload and business requirements.
Tags: Oracle 19c, Oracle Database Best Practices, Oracle Performance, Oracle Security, GoldenGate, Data Guard, Multitenant