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 | 607 |
12 | Hybrid Columnar Compression Common Questions | 명품관 | 2016.03.04 | 191 |
11 | New Features in Oracle Database 19c | 명품관 | 2019.02.02 | 544 |
10 | Parameter Recommendations for Oracle Database 12c - Part I | 명품관 | 2016.03.07 | 841 |
» | New Features of Performance Tuning in Oracle Database 19c | 명품관 | 2019.02.08 | 918 |
8 | New Features of RAC & ASM in Oracle 19c | 명품관 | 2019.02.08 | 952 |
7 | Patch conflicts | 명품관 | 2019.02.07 | 970 |
6 | New initialization parameters, data dictionary views & dynamic performance views in Oracle Database 19c | 명품관 | 2019.02.08 | 1912 |
5 | New Features of Data Guard in Oracle Database 19c | 명품관 | 2019.02.08 | 2004 |
4 | New Features of Security in Oracle Database 19c | 명품관 | 2019.02.08 | 5049 |
3 | More New Features in Oracle Database 19c | 명품관 | 2019.02.08 | 6593 |
2 | SQL Tuning Workshop | 명품관 | 2020.02.20 | 8157 |
1 | Oracle Linux 6.7 with Oracle 11.2.0.4 RAC | 명품관 | 2016.04.15 | 9687 |