What’s new in Oracle Database 19c and other #OOW18 feedback

Long Term Support and Beta Program

  • test 19c in Oracle Cloud as soon as available. You may use more options than what you have on-premises for those tests, such as the Performance Analyzer.

Oracle Code One, Ground Breakers and XE

#codeone

Oracle XE 18c is out (18.4)

19c new Optimizer features

The best you can do for the optimizer is providing accurate statistics. Daily gathering on stale tables is not sufficient, and dynamic statistics overload parse activity too much. We will have two new features:

  • Real-Time Statistics: some statistics (like high/low value) are maintained during DML. This can be great to avoid Out-of-Range problems with linear decay from obsolete statistics.

Other Database new features

  • Fast ingest support for IoT: in conjunction with middle tier to stream data continuously to the database. The inserts are buffered in memory to benefit from asynchronous bulk inserts.
  • Partitioned Hybrid Tables: the idea is to accept different organization (Heap/External) for partitions. Maybe have some old partitions in a read-only tablespace on Object Store?
  • The multitenant main focus is bug fixes as the goal is to abandon non-CDB for the next main release (20c). 19c should allow RAT and ADDM at PDB level.
  • Data Guard: the re-creation of broker configuration is a long-awaited feature. FSFO will be able to allow data loss, and dynamically change the target
  • ASM is not required anymore for Voting disks and OCR so we can get rid if the ASM instance when using dNFS

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Franck Pachot

Franck Pachot

502 Followers

Developer Advocate at Yugabyte, Open Source distributed SQL database 🚀 Also Oracle ACE Director, Oracle Certified Master, AWS Data Hero, OakTable member