The following are changes in Oracle Database Performance Tuning for Oracle Database Release 19c.
- Memoptimized
Rowstore – Fast Ingest - Automatic Database Diagnostic Monitor (ADDM) support for pluggable databases (PDBs)
The following are changes in Oracle Database In-Memory for Oracle Database release 19.
- Database In-Memory wait on populate
- Big Data and performance enhancements for In-Memory external tables
- Hybrid partitioned tables
- Oracle Database Resource Manager automatically enabled for Database In-Memory
- Oracle Data Guard Multi-Instance Redo Apply supports the IM column store
The following are changes in Oracle Database SQL Tuning for Oracle Database release 19c.
- Automatic resolution of SQL plan regressions
- Reporting on hint usage
- Plan comparison function
- High-frequency automatic optimizer statistics collection
- Statistics maintenance enhancements
- Real-time SQL monitoring for developers
- Statistics-based query transformation
- Quarantine for runaway SQL statements
- Automatic indexing
No comments:
Post a Comment