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
Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Telegram Channel: https://t.me/helporacle
Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/
Joel Perez’s LinkedIn: Joel Perez’s Profile
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp
