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/
Comment 0
| No. | Subject | Author | Date | Views |
|---|---|---|---|---|
| Notice | Guru's Article 게시판 용도 | ecrossoug | 2015.11.18 | 607 |
| 8 | More New Features in Oracle Database 19c | 명품관 | 2019.02.08 | 6593 |
| 7 | New Features of Security in Oracle Database 19c | 명품관 | 2019.02.08 | 5049 |
| 6 | New Features of Data Guard in Oracle Database 19c | 명품관 | 2019.02.08 | 2004 |
| 5 | New initialization parameters, data dictionary views & dynamic performance views in Oracle Database 19c | 명품관 | 2019.02.08 | 1912 |
| 4 | New Features of RAC & ASM in Oracle 19c | 명품관 | 2019.02.08 | 952 |
| » | New Features of Performance Tuning in Oracle Database 19c | 명품관 | 2019.02.08 | 918 |
| 2 | New Features in Oracle Database 19c | 명품관 | 2019.02.02 | 544 |
| 1 | New Features of Backup & Recovery in Oracle Database 19c | 명품관 | 2019.02.07 | 432 |