Skip to menu

검색창 닫기

Korea Oracle User Group

Guru's Articles

New Features of Performance Tuning in Oracle Database 19c

명품관 2019.02.08 09:46 Views : 918

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/

, , , , , I want to
List
No. Subject Author Date Views
Notice Guru's Article 게시판 용도 ecrossoug 2015.11.18 607
43 Troubleshooting Another Complex Performance Issue – Oracle direct path inserts and SEG$ contention file ecrossoug 2015.11.16 100
42 Brief about Workload Management in Oracle RAC file ecrossoug 2015.11.18 514
41 NOUG Session: How Cache Fusion Works file ecrossoug 2015.11.18 137
40 How many checkpoints in Oracle database ? [1] file 명품관 2015.11.20 283
39 Parallel Execution 12c New Features Overview file 명품관 2015.11.23 111
38 On Invokers and Outs file 명품관 2015.11.23 102
37 Top 5 SQL Monitor Features file 명품관 2015.12.01 780
36 Oracle Enterprise Manager Cloud Control 13c Release 1 (13.1.0.0) Installation on Oracle Linux 6 and 7 명품관 2015.12.23 203
35 Oracle 12c SQL – Using JSON 명품관 2015.12.29 2583
34 Upgrade a Pluggable Database in Oracle 12c 명품관 2015.12.30 174
33 (유투브) KISS series on Analytics: Dealing with null - Connor McDonald 명품관 2016.01.05 155
32 How do I capture a 10053 trace for a SQL statement called in a PL/SQL package? 명품관 2016.01.06 264
31 Why You Can Get ORA-00942 Errors with Flashback Query 명품관 2016.02.01 453
30 What is an In-Memory Compression Unit (IMCU)? 명품관 2016.02.24 181
29 Hybrid Columnar Compression Common Questions 명품관 2016.03.04 191
28 Parameter Recommendations for Oracle Database 12c - Part I 명품관 2016.03.07 844
27 Parameter Recommendations for Oracle Database 12c - Part II 명품관 2016.03.18 354
26 Oracle Linux 6.7 with Oracle 11.2.0.4 RAC 명품관 2016.04.15 9694
25 Quick tip on Function Based Indexes 명품관 2016.04.19 191
Write Tag
Up