Oracle DBA Features in 12C 18C and 19C
Oracle 12C Features:
1. Online migration of an active data file
2. Online table partition or sub-partition migration
3. Invisible column
4. Multiple indexes on the same column
5. DDL logging
6. Temporary undo in- and- outs
7. New backup user privilege
8. How to execute SQL statement in RMAN
9. Table level recovery in RMAN
10. Restricting PGA size
Oracle 18C Features:
1. Integration with Microsoft Active Directory
2. Schema Only Accounts
3. Server Draining Ahead of Planned Maintenance
4. Automatic In-Memory
5. SQL Cancel
Oracle 19C Features:
1. Automatic Indexing.
2. Real-Time Statistics.
3. Active Data Guard DML Redirection.
4. Automatic Resolution of SQL Plan Regressions.
5. Finer granularity Supplemental Logging.
6. Dry-Run Validation of Clusterware Upgrade.
7. AutoUpgrade for oracle database.
8. Oracle network log file segmentation.
This comment has been removed by the author.
ReplyDelete