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/
댓글 0
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
공지 | Guru's Article 게시판 용도 | ecrossoug | 2015.11.18 | 608 |
2 | New initialization parameters, data dictionary views & dynamic performance views in Oracle Database 19c | 명품관 | 2019.02.08 | 1913 |
» | New Features of Performance Tuning in Oracle Database 19c | 명품관 | 2019.02.08 | 918 |