Yes nice new features
Sent from a mobile device please ignore potential spelling mistakes
On 14 Feb 2019, at 13:51, johan vanden bossche
<johan.vanden.bossche@xxxxxxxxxx> wrote:
Hello All,
https://blogs.oracle.com/oracle-database/oracle-database-19c-now-available-on-oracle-exadata
Oracle Database 19c is now available on Oracle Exadata!
Initially released on LiveSQL.oracle.com, Oracle Database 19c is the final
and therefore 'long term support' release (previously referred to as a
'terminal release') of the Oracle Database 12c and 18c family of products.
'Long term support' means that Oracle Database 19c comes with 4 years of
premium support (to end of January 2023) and at least 3 years of extended
support (to end of January 2026). This extended support window is critical to
many of our customers as they plan their upgrade strategy from prior
releases. For the latest Oracle Support schedule see Document ID 742060.1 on
My Oracle Support (login required).
Aims of Oracle Database 19c
Oracle Database 19c is the release that the majority of customers will target
their upgrades towards, and Oracle has made stability the core aim of
this release. In Oracle Database 19c, developers have focused on fixing known
issues, rather than adding new functionality. This has resulted in hundreds
of man years worth of testing and thousands of servers running tests 24 hours
a day. This focus on stability goes further than just the core database; it
also covers all aspects of the technology stack from the installer to the
utilities and tools that make up the product offering. This approach, plus
the changes we've made to the patching process will greatly reduce the burden
on patching in the upcoming years for our customers.
All That's Gone Before
Before we discuss some of the changes in Oracle Database 19c, it's important
to remember that Oracle Database has been the cornerstone of enterprise
systems for the last 40 years. Over that time, we've added a multitude of
features under the guidance of our customer community; from row level
locking and scalable read consistency, to the ability to logically break
tables up into smaller partitions for scanning billions of rows a second
using parallel query. Many of these features and their implementation are
industry leading, and in many instances remain unique to Oracle Database.
Data is of little value to enterprise users when it's not accessible, and
Oracle Database has ensured that it always is. Whether it's as simple as make
sure the database is consistent on restart after an unexpected server outage.
Or, by offering disaster recovery, Oracle Database can provide synchronous
(or asynchronous) replication of data over large distances whilst making it
available for reporting and backups. Oracle Real Application Clusters (RAC)
has meant that Oracle Database is found in nearly every mission critical
system where any server outage could have serious implications. RAC enables
customers to scale their Oracle Databases to extraordinary levels of
throughput and concurrency without having to change their applications.
Oracle Database is widely acknowledged one of the most secure repositories
for data in the industry. No other database solution has the breath of
capabilities or depth of implementation. Whether it's our implementation of
simple access controls or the classification of data down to the row level.
We encrypt data throughout it's life cycle be it at rest or in flight and we
do it in the database itself ensuring that malicious access is minimized.
And More Recently
Oracle Database 18c and the previously released Oracle Database 12c family
introduced hundreds of new features and improvements. Some of the more
significant include:
Multitenant Oracle's strategic container architecture for the cloud
introduced the concept of a pluggable database (PDB), enabling users to plug
and unplug databases and move between containers, either locally or in the
cloud. This architecture enables massive consolidation with the ability to
efficiently share memory and processor resources and manage many databases as
one (e.g. for backups, patching and upgrades).
JSON Support Provides developers with a more flexible approach to defining
their persisted schema-less data model. As well as just being able to store
JSON in the database, developers can use SQL and all of Oracle's advanced
analytical capabilities to query it. To ease the burden of processing large
JSON data collections, Oracle Database also enables parallel scanning and or
update. For developers looking to build applications and preferring to use a
simple NoSQL API, Oracle Database provides SODA (Simple Object Data Access)
APIs for C, Java, PL/SQL, Python, Node and REST.
Database In-Memory Enables users to perform lighting fast analytics against
their operational databases without being forced to acquire new hardware or
make compromises in processing their data. Oracle Database features a dual
in-memory model where OLTP data is held both as rows, enabling it to be
efficiently updated, and in a columnar form, enabling it to be scanned and
aggregated much faster. Reports that used to take hours can now be executed
in seconds. In addition, Oracle can store JSON documents in the in-memory
column store for lightening fast analysis of semi structured data.
Sharding Provides OLTP scalability and fault isolation for customers that
want to scale outside of the confines of a typical SMP server. It also
supports use cases where data needs to be placed in geographic location
because of performance or regularity reasons. Oracle Sharding provides
superior run-time performance and simpler life-cycle management compared to
home-grown deployments that use a similar approach to scalability. Users can
automatically scale up the shards to reflect increases in workload making
Oracle the one of the most capable and flexible approaches to web scale work
loads for the enterprise today.
New in Oracle Database 19c
While stability is the focus of Oracle Database 19c, that's not to say there
aren't some new few features and enhancements worth mentioning, such as:
Automatic Indexing Without the relevant experience, optimizing database
performance can be a challenge for many customers. Figuring out what columns
in a table require an index to benefit not just a single query but
potentially thousands of variants requires a deep understanding of the data
model, performance-related features of Oracle Databases and the underlying
hardware. In Oracle Database 19c, we're introducing Automatic indexing which
continually evaluates the executing SQL and the underlying tables to
determine which indexes to create and which ones to potentially remove. It
does this via an expert system which verifies the improvements an index might
make, and after it's creation, validates the assumptions made. It then uses
reinforcement learning to ensure it doesn't make the same mistake again. Most
importantly, Oracle Database 19c is able to adapt over time as the data model
and access paths change.
Active Standby DML Redirect A popular feature of Active Data Guard is its
ability to make use of standby databases for reporting and backups. With
basic Data Guard, the standby database continuously recovers redo information
shipped from a primary database. While the ability to 'sweat' the standby,
through Active Data Guard, is a big improvement in fully utilizing an
enterprises resource, many reporting applications require the ability to
persist some data, such as logging information for auditing purpose. In
Oracle Database 19c we now allow users to send such write requests to the
standby. These writes are then transparently redirected to the primary
database and written there first (to ensure consistency) and then the changes
are shipped back to the standby. This approach allows applications to use the
standby for moderate write workloads without requiring any application
changes.
Hybrid Partitioned Tables Breaking larger tables into smaller chunks or
partitions makes them easier to manage and can improve performance by
focusing operations on only the pieces of data they would be applicable to.
Oracle Database supports multiple models for partitioning data as well as
online operations for partition management. But, as enterprise data continues
to inextricably increase in size and complexity and regulatory requirements
mandate that it continues to always be online we need to look at new models
for managing it. With Hybrid Partitioned Tables, DBAs can now break data into
manageable partitions as before, however DBAs can now select which partitions
should be held in the database for fast querying and updating, and which
partitions can be made read only and stored in external partitions. These
external partitions can be held on on-premises in standard files systems or
on low cost HDFS. DBAs can also choose to place the data in cloud-based
object stores, thereby 'stretching' tables to the cloud.
JSON Enhancements There are a number of incremental enhancement to JSON
support in Oracle Database 19c, from the simplification of SQL functions to
the ability to partially update a JSON document.
Memoptimized Rowstore This features enables fast data inserts into Oracle
Database 19c from applications, such as Internet of Things (IoT), which
ingest small, high volume transactions with a minimal amount of transactional
overhead. The insert operations that use fast ingest functionality
temporarily buffer the data in the large pool before writing it to disk in
bulk in a deferred, asynchronous manner.
Quarantine SQL Statements Runaway SQL statements terminated by Resource
Manager due to excessive consumption of processor and I/O resources can now
be automatically quarantined. This prevents these runaway SQL statements from
executing again, and thereby protects Oracle Database 19c from a common
source of performance degradation.
Real Time Statistics Modern query optimizers require detailed statistics of
the structure and make of data in tables to enable them to make the 'optimal'
decision on how to execute complex queries. The problem with this is that
statistic collection can be resource intensive and take some period of time.
For most recent 'always on' applications, finding a window to run a batch
process to collect this data is difficult. In Oracle Database 19c, statistics
can now be collected as operations insert, update or delete data in real
time. Now, there's no need for customers to compromise between the quality of
the statistics that the optimizer depends upon and finding the right time for
statistics maintenance.
For the complete list of new features in Oracle Database 19c, check out the
latest documentation set or try the new Database Feature Application Guide
here https://apex.oracle.com/database-features/. ;
Also check out Maria Colgan's blog with a few more details.
For the latest Oracle Database 19c availability on other platforms, both
on-premises and in Oracle Cloud (including Autonomous Database Cloud
Services), check out Document ID 742060.1 on My Oracle Support (login
required).
--
Oracle Belgium
Johan Vanden Bossche
Tel 32 (0)2 719 58 91
This transmission is intended only for the use of the addressee and may
contain confidential or legally privileged information. If you are not the
intended recipient, you are notified that any retransmission, dissemination,
disclosure or other use of, or taking any action in reliance upon, this
communication is strictly prohibited. If you have received this transmission
in error please notify us immediately and delete all copies of this
transmission together with any attachments.
“The statements and opinions expressed here are my own and do not necessarily
represent those of Oracle Corporation.”