8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Articles » 19c » Here


Oracle 19c Articles

Oracle Database 19c : Miscellaneous Articles

Auditing Enhancements in Oracle Database 19c - This article gives an overview of the auditing enhancements in Oracle database 19c.

Automatic Indexing (DBMS_AUTO_INDEX) in Oracle Database 19c - Oracle database 19c introduced the automatic indexing feature, which lets you hand over some of the decisions about index management to the database.

Blockchain Tables in Oracle Database 19c and 21c - A blockchain table is a tamper-proof, insert-only table with an associated table-level and row-level retention period.

Data Guard Physical Standby Setup Using the Data Guard Broker in Oracle Database 19c - This article contains an example of setting up a physical standby database for Oracle 19c using the Data Guard Broker.

Data Pump (expdp, impdp) Enhancements in Oracle Database 19c - This article gives an overview of the Data Pump enhancements in Oracle Database 19c.

DBMS_CLOUD : Installation on 19c and 21c On-Prem Databases - This article describes how to install the DBMS_CLOUD package in on-prem 19c and 21c databases.

DBMS_CLOUD Package - This article describes the basic usage of the DBMS_CLOUD package.

DBMS_JOB Jobs Converted to DBMS_SCHEDULER Jobs in Oracle Database 19c - The DBMS_JOB package has been deprecated since 12cR2. Oracle 19c takes the demise of the DBMS_JOB package a step further by converting any DBMS_JOB jobs to DBMS_SCHEDULER jobs.

DBMS_XPLAN : Compare Execution Plans in Oracle Database 19c and 21c (COMPARE_PLANS, COMPARE_CURSORS and COMPARE_EXPLAIN) - This article demonstrates how to compare execution plans using the DBMS_XPLAN package in Oracle Database 19c and 21c.

Exclude ENCRYPTION Clause on Import in Oracle Database 19c - This article demonstrates how to use the OMIT_ENCRYPTION_CLAUSE of the import TRANSFORM parameter in Oracle database 19c.

Immutable Tables in Oracle Database 19c and 21c - An immutable table is a tamper-proof, insert-only table with an associated table-level and row-level retention period.

GeoJSON Data Support in Oracle Database 19c - In this article we demonstrate the support for GeoJSON data in Oracle Database 19c. Specifically the mapping between GeoJSON data and the Oracle Spatial SDO_GEOMETRY object type.

Gradual Database Password Rollover Time (PASSWORD_ROLLOVER_TIME) in Oracle Database 19c and 21c - From Oracle 21c onward we can define a password rollover time, which allows us to connect using both the old and the new passwords during the gradual rollover time period. This feature was backported to Oracle 19c in the 19.12 release update.

Hybrid Partitioned Tables in Oracle Database 19c - This article shows how to combine internal and external partitions into a single Hybrid Partitioned Table in Oracle Database 19c.

JSON Support Enhancements in Oracle Database 19c - Oracle 19c includes several enhancements to the JSON functionality in the database. This post acts as a links page to separate articles on each feature.

JSON_MERGEPATCH in Oracle Database 19c - The JSON_MERGEPATCH function is used to modify parts of a JSON document in select and update operations.

JSON_OBJECT Enhancements in Oracle Database 19c - The SQL/JSON function JSON_OBJECT got a whole lot easier to use in Oracle 19c.

JSON_SERIALIZE in Oracle Database 19c - The JSON_SERIALIZE function converts a JSON document from any supported data type to text.

LISTAGG DISTINCT in Oracle Database 19c - Oracle 19c includes the ability to remove duplicates from the LISTAGG results by including the DISTINCT keyword.

Mapping of JSON Data To and From SQL Object Types in Oracle Database 19c - Oracle database 19c allows JSON data to instantiate user-defined object type instances, and user defined object-type instances can be converted to JSON data.

Materialized View Support for Queries Containing JSON_TABLE in Oracle Database 19c - Oracle 19c can perform query rewrites of statements using some SQL/JSON functions (JSON_VALUE, JSON_EXISTS) to use a materialized view containing and appropriate JSON_TABLE call.

Multitenant : DBCA PDB Relocate in Oracle Database 19c - In Oracle 19c it's possible to perform a relocate of a pluggable database (PDB) using the Database Configuration Assistant (DBCA).

Multitenant : DBCA PDB Remote Clone in Oracle Database 19c - In Oracle 19c it's possible to perform a remote clone of a pluggable database (PDB) using the Database Configuration Assistant (DBCA).

Multitenant : Dynamic CPU Scaling - Resource Manager Control of CPU using CPU_COUNT and CPU_MIN_COUNT - Resource Manager can control CPU usage in PDBs using the CPU_COUNT and CPU_MIN_COUNT parameters. Oracle call this Dynamic CPU Scaling.

Multitenant : Upgrading to Oracle Database 19c - This article provides an overview of upgrading an existing multitenant database to Oracle 19c.

Oracle SQL and PL/SQL Enhancements in Oracle Database 19c - This page provides links to all the separate articles on SQL and PL/SQL enhancements in Oracle Database 19c.

SQL NESTED Clause Instead of JSON_TABLE in Oracle Database 19c - The SQL NESTED clause allows us to write the equivalent of the LEFT OUTER JOIN JSON_TABLE using a simplified syntax.

Real-Time Statistics in Oracle Database 19c - Oracle database 19c introduced real-time statistics to reduce the chances that stale statistics will adversely affect optimizer decisions when generating execution plans.

Scheduler (DBMS_SCHEDULER) Enhancements in Oracle Database 18c, 19c and 21c - This post summarises the enhancements to the scheduler in Oracle Database 18c, 19c and 21c.

SQL Quarantine in Oracle Database 19c - Oracle Database 19c introduced an extension of Runaway Query Management called SQL Quarantine.

Multitenant : New Features in 19c - A list of the Multitenant new features introduced in Oracle database 19c, with links.

Upgrading to Oracle Database 19c (Non-CDB) - This article provides an overview of upgrading an existing non-CDB database to Oracle 19c.

Oracle Database 19c : Installations

Minimal Viable Oracle Database 19c Installation on Oracle Linux 8 (OL8) - This article gives the least steps necessary to get a working Oracle 19c database on Oracle Linux 8 (OL8).

Oracle Database 19c Installation On Oracle Linux 7 (OL7) - This article describes the installation of Oracle Database 19c 64-bit on Oracle Linux 7 (OL7) 64-bit.

Oracle Database 19c Installation On Oracle Linux 8 (OL8) - This article describes the installation of Oracle Database 19c 64-bit on Oracle Linux 8 (OL8) 64-bit.

Oracle Database 19c Installation On Oracle Linux 9 (OL9) - This article describes the installation of Oracle Database 19c 64-bit on Oracle Linux 9 (OL9) 64-bit.

Oracle Database 19c RPM Installation On Oracle Linux 7 (OL7) and Oracle Linux 8 (OL8) - This article describes the RPM installation of Oracle Database 19c 64-bit on Oracle Linux 7 (OL7) 64-bit and Oracle Linux 8 (OL8) 64-bit.

Oracle Database 19c Installation On Fedora 29 (F29) - This article describes the installation of Oracle Database 19c 64-bit on Fedora 29 (F29).

Oracle Database 19c Installation On Fedora 30 (F30) - This article describes the installation of Oracle Database 19c 64-bit on Fedora 30 (F30).

Oracle Database 19c Installation On Fedora 31 (F31) - This article describes the installation of Oracle Database 19c 64-bit on Fedora 31 (F31).

Oracle Database 19c Installation On Fedora 32 (F32) - This article describes the installation of Oracle Database 19c 64-bit on Fedora 32 (F32).

Oracle Database 19c Installation On Fedora 33 (F33) - This article describes the installation of Oracle Database 19c 64-bit on Fedora 33 (F33).

Oracle Database 19c Installation On Fedora 34 (F34) - This article describes the installation of Oracle Database 19c 64-bit on Fedora 34 (F34).

Oracle Database 19c Installation On Fedora 35 (F35) - This article describes the installation of Oracle Database 19c 64-bit on Fedora 35 (F35).

Oracle Database 19c Installation On Fedora 36 (F36) - This article describes the installation of Oracle Database 19c 64-bit on Fedora 36 (F36).

Oracle Database 19c Installation On Fedora 37 (F37) - This article describes the installation of Oracle Database 19c 64-bit on Fedora 37 (F37).

Oracle Database 19c Installation On Fedora 38 (F38) - This article describes the installation of Oracle Database 19c 64-bit on Fedora 38 (F38).

Oracle Database 19c Installation On Fedora 39 (F39) - This article describes the installation of Oracle Database 19c 64-bit on Fedora 39 (F39).

Oracle Database 19c RAC On Oracle Linux 7 Using VirtualBox and Vagrant - This article describes the "hands-off" installation of Oracle Database 19c RAC on Oracle Linux 7 using VirtualBox and Vagrant with no additional shared disk devices.

Oracle Database 19c RAC On Oracle Linux 8 Using VirtualBox and Vagrant - This article describes the "hands-off" installation of Oracle Database 19c RAC on Oracle Linux 8 using VirtualBox and Vagrant with no additional shared disk devices.

Oracle Database 19c RAC On Oracle Linux 9 Using VirtualBox and Vagrant - This article describes the "hands-off" installation of Oracle Database 19c RAC on Oracle Linux 9 using VirtualBox and Vagrant with no additional shared disk devices.

External 19c Links

Documentation: Oracle Database 19c

livesql.oracle.com - LiveSQL is now running on Oracle 19c, so you can start trying it out now.

YouTube : Oracle Learning Channel