Oracle Database 19c was released back in January 2019 on Oracle Live SQL and is the final release of the Oracle Database 12c product family. Oracle Database 19c comes with four years of premium support and a minimum of three extended support. It also forms a foundation for Oracle’s next phase of autonomous database optimizations.
This article talks about the top new features implemented in Oracle Database 19c for companies to evaluate the value of upgrading their current versions to 19c.
ORACLE DATABASE 19C NEW FEATURES
Oracle Database 19c builds upon the innovations of previous releases like: Multitenant, In-Memory, JSON support, Sharding and many other features that enable Oracle’s Autonomous Database Cloud Services.
This latest release introduces new functionality, providing customers with a multi-model enterprise-class database for all their typical use cases, including:
- Operational database use cases such as; traditional transactions, real-time analytics, JSON document stores and Internet of Things (IoT) applications
- Analytical database use cases such as; traditional and real-time data warehouses and data marts, big data lakes and graph analytics.
Here are some of the top new features:
- Automatic Indexing. This feature uses machine learning (ML) algorithms to create and constantly adjust indexes to improve performance and cost savings. This means you can start the database without any, or with very few, indexes, and over a short period of time, the database will look at the way the data is queried and build indexes to provide efficient access plans for that dataset.
- Active Data Guard DML Redirect. Oracle launched Oracle Active Data Guard back in Oracle Database 11g, to help customers get more use from that standby database by running reports and backups against it. In Oracle Database 19c, Oracle adds an important twist on this feature which enables you to do transactions against the standby database.
- Hybrid Partitioned Tables. This feature enables database administrators to manage a table between partitions inside the database and partitions held on low-cost read-only datastores outside the database. These datastores can reside on premises or in the cloud.
- JSON Support. Support for JSON gets improved. Oracle improved and simplified the syntax for our JSON functions and introduced the capability to do a partial JSON update. In addition, Oracle Database 19c includes new Simple Oracle Document Access (SODA) APIs for Java, Python, C, and Node.js.
- Query Quarantine. The overall performance of a data mart or a data warehouse can suffer when a user runs a query that consumes an excessive amount of I/O and compute resources. Oracle Database 19c can automatically quarantine those queries and ensure that they don’t run again, resulting in consistent performance for all database users.
To learn more about these and other features in Oracle Database 19c, check out Oracle’s documentation here or at My Oracle Support, Document ID 742060.1.
NEED HELP MAXIMIZING YOUR ORACLE EBS INVESTMENT?
ITC can help you define your ERP Modernization roadmap plan. We provide unbiased advice to determine the best roadmap for you, whether that is upgrading your On-Prem E-Business Suite, migrating to Cloud SaaS applications or going with a Coexistence (Hybrid) model. Our assessment methodology takes into account your current business processes and IT footprint, to establish the effort and fit of these options and ultimately, recommend a clear path to innovation.
Request our assessment and take things at your own pace.