Dear
DBA-Mates,
We would like
to share one of most important information as all the customer are upgrading to 19c.
Hope his will
be useful as reason why we need to upgrade 19c database from previous
version of database specially 12c which I am seeing/doing. So be Ready!!!
Reasons
to upgrade 19c:
1.Oracle
lifetime support policy only follows their latest version
2. OS
compatibilities as per DB versions
3. Security purpose as compared to old version.
Some
Older version History:
12c
(2014): Oracle
designed to work on the Cloud, the most notable features are the pluggable
databases and multitenant architecture.
18c
(2018): autonomous
database, this self-driving database is self-securing and self-repairing,
available for the Oracle cloud or on-site premises.
19c (Jan
2019): will be
supported through 2023, extended till 2026.
latest
version-19.3
Oracle
Version 19C
The latest Oracle
version, the 19C, was released in early January 2019. It's been noted as the
long- term release for the 12.2 product family of Oracle databases. This
particular version will be supported through 2023, with extended support
available until 2026.
Some
of the newest features in the 19C release include:
Query
Quarantine -
Unlike with
previous Oracle versions, 19C solves the problem of overloading system
resources with query requests. This version provides automatic query quarantine
to ensure that specific queries aren't running over and over.
JSON
Support -
This version
has simplified the syntax for JSON functions and allows users the capability to
do partial updates of JSON. In addition, it provides SODA APIs for Node.js, C,
Python, and Java.
Automatic
Indexing -
19C offers a
machine learning algorithm feature that provides constant index adjustment.
This algorithm leads to enhanced system performance and more cost savings.
After just a short amount of use, this database version will build indexes that
allow for more efficient plans for each dataset.
Hybrid
Partitioned Tables -
This 19C
feature permits database administrators to manage tables both inside and
outside the database with ease. The partitions inside the database can easily
be managed alongside partitions that are in read-only data stores outside of
the database on the premises or on the Cloud.
Active
Data Guard -
This new
feature works to prevent downtime and data loss during database repairs and
upgrades. It allows for incidental updates to be run while a synchronized
physical replica or standby is maintained.
Some more
useful link:
How to change database DB name using NID utility
Stuck Thread in WebLogic Error and solution
how to change weblogic password in 12.2.8
ReplyDelete