Oracle Database 19c

Database 19c

by Faulkner Staff

Docid: 00011503

Publication Date: 2212

Publication Type: PRODUCT


Oracle’s Database 19c is a database management system that
allows corporate IT departments to control their large-scale computing
environments and developers to create enterprise-wide data management
programs and applications. Released in February 2019, it is the final
“long term support” release of the Oracle 12c family of products,
which also includes Oracle 18c. Currently, the company plans to
end support of the database in April 2027, and is currently offering
Oracle Database 21c as an “innovation release,” providing early
insight into the enhancements and new capabilities planned for the

Report Contents:


[return to top of this

Oracle Company

Oracle’s Database 19c database-management system was created for
corporate IT departments to help them better manage large-scale computing
environments. The product allows each database plugged into the
multitenant architecture to look and feel like a standard Oracle database
to applications, allowing existing applications to run unchanged.



500 Oracle Parkway
Redwood Shores, CA 94065
(650) 506-7000
(800) 672-2531
(650) 506-7200
Type of Vendor: Application, development, and
database software provider
Founded: 1977
Service Areas: Global
Stock Symbol: ORCL (NASDAQ)

The open source system is Oracle’s flagship offering. It allows for
consolidation onto database clouds and engineered systems such as Oracle
Exadata and Oracle’s Database Appliance.

Database 19c offers database administration productivity
features for organizations looking to consolidate databases onto the cloud
without the need to modify or create new applications. It builds upon
previous releases and offers additional functionality for typical customer
use cases, including traditional transactions, real-time analytics, JSON
document stores, and Internet of Things (IoT) applications. It is also
designed for analytical database applications such as traditional and
real-time data warehouses and data marts, big data lakes, and graph
analytics. Database 19c lets users send write requests to the
standby, which are then redirected to the primary database, and then the
changes are shipped back to the standby.

New features offered in the release include an improved create
application wizard, REST-enabled SQL support, Web source modules, an
improved create page wizard, a new REST workshop, social sign-in
authentication, SQL quarantine, and workload capture and replay in a PDB,
among other features.

19c features:

  • Application development
  • Incremental capabilities in the areas of performance, security, and
    high availability
  • Business intelligence and data warehousing
  • Compression and archiving
  • Oracle RAC and grid infrastructure
  • Security
  • Spatial and graph representation
  • Unstructured data analysis

Oracle Database 19c is available in three main on-premise
editions for enterprise use – Standard Edition 2, Enterprise,
and Enterprise Edition on Engineered Systems.
Each is compatible with the other editions and shares the same database
engine architecture. This allows organizations to upgrade database
platforms as necessary. NOTE: Oracle Standard Edition
and Oracle Standard Edition One are no longer available for purchase.

Table 1 compares Oracle’s Database 19c editions.

Table 1. Database 19c Comparison
Edition Standard Two Enterprise Enterprise on
Engineered Systems
Description Includes features necessary
to develop workgroup, department-level, and Web applications.
Provides performance,
availability, scalability, and security for developing
applications such as high-volume online transaction processing
(OLTP) applications, query-intensive data warehouses, and
demanding Internet applications.
Oracle Database Enterprise
Edition software installed on an on-premises engineered system
(Oracle Exadata Database Machine or Oracle Database Appliance).
Availability Features
Fail Safe Y Y N
Fast-Start Fault Recovery N Y Y
Flashback Table, Database,
and Transaction Query
Application Continuity N Y Y
Performance and
Scalability Features
Real Application Clusters N Option Option
Query Results Cache N Y Y
Adaptive Execution Plans N Y Y
Automatic Workload Management Option Option Option
Oracle In-Memory Database Cache N Option Option
In-Memory Aggregation N Option Option
Security Features
Data Masking N Y Y
Real Application Security N Y Y
Oracle Database Vault N Option Option
Oracle Advanced Security N Option Option
Oracle Label Security N Option Option
Enterprise User Security N Y Y
Virtual Private Database N Y Y
Fine Grained Auditing N Y Y
Redaction N Option Option
Transparent Data Encryption N Option Option
Real Application Testing N Option Option
SQL Plan Management Y Y Y
Database Resource Manager N Y Y
I/O Resource Management N N Y
Instance Caging Y Y Y
Data Warehouse and
Business Intelligence Features
Advanced Compression N Option Option
OLAP N Option Option
Partitioning N Option Option
Oracle Machine Learning Y Y Y
Automatic Data Optimization N Y Y
Parallel Statistics Gathering N Y Y
Summary Management N Y Y
Integration Features
Database Gateways Y Y Y
Messaging Gateway N Y Y
AQ Sharded Queues Y Y Y
Spatial and Graph
Oracle Spatial and Graph Y Y Y
Property Graph and RDF Graph
Parallel Spatial Index Builds N Y Y
Multimaster Replication of SDO_GEOMETRY
Partitioned Spatial Indexes N Y Y

Figure 1 shows Database 19c enterprise architecture.

Figure 1. Database 19c Enterprise Architecture

Figure 1. Database 19c Enterprise Architecture

Source: Oracle

Figure 2 depicts the new Active Standby DML Redirect offered in Database

Figure 2. Database 19c Active Standby DML

Figure 2. Database 19c Active Standby DML Redirect

Source: Oracle

Oracle also offers many different options to extend Database 19c
to meet specific performance, availability, security, compliance, data
warehousing, and manageability requirements. Some of Database 19c‘s
options are listed in Table 2.

Table 2. Database 19c Features
Feature Description
Active Data Guard Offloads resource-intensive activities,
from a production database to one or more synchronized standby
Advanced Compression Delivers compression rates of 2-4X,
across all data and application types.
Advanced Security Helps comply with privacy and regulatory
Database In-Memory Automatically synchronizes data between
the cache and the Oracle Database to ensure data consistency.
Database Vault Addresses regulatory mandates and
increase the security of existing applications.
Label Security Classifies data and mediating access to
data, based on classification.
Multitenant Consolidates data and code from multiple
databases without altering existing data or applications.
OLAP Calculates engine that supports advanced
analytical applications, including planning, budgeting,
forecasting, sales, and marketing, to identify key business trends
and model business scenarios.
Partitioning Offers methods including interval,
reference, list, and range, and provides composite partitions of
two methods, such as order data (range) and region (list), or
region (list) and customer type (list).
Real Application Clusters Allows a single database to run across a
cluster of servers, providing fault tolerance, performance, and
scalability without having to change applications.
Real Application Clusters One Node Offers a single-node version of Real
Application Clusters for standardizing on a single deployment
Real Application Testing Combines workload capture and replay
with a SQL performance analyzer, to test changes against real-life
workloads, then fine tune changes before putting them into
TimesTen Application-Tier Database Cache Caches subsets of the database to
improve response time in the application tier.


[return to top of this

Oracle’s support options include training, consulting, and outsourced IT
services. Online support services include a FAQ section, tutorials,
documentation, e-mail support, and a telephone directory. Numerous
independent user groups for Oracle Database 19c also exist.


[return to top of this

The costs for Oracle’s Database 19c products are
configuration-dependent. Oracle should be contacted directly regarding all
price inquiries by e-mailing
Customers can upgrade to 19c‘s new multitenant architecture or
upgrade with the current architecture. Customers have a choice of upgrade
paths and tools depending on what release they currently have.


[return to top of this

Oracle’ database-management systems market competition includes IBM DB2,
SAP database technology, and Teradata Integrated Data Warehouses, among

[return to top of this

[return to top of this