메뉴 건너뛰기

Korea Oracle User Group

Guru's Articles

New Features of Performance Tuning in Oracle Database 19c

 

The following are changes in Oracle Database Performance Tuningfor 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

출처 : http://oracle-help.com/oracle-19c/new-features-of-performance-tuning-in-oracle-database-19c/

위로