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

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.