Oracle HCM Cloud Placements and Training
Uncategorized

Oracle Database 19c New Features and Enhancements in SQL & PLSQL

Pinterest LinkedIn Tumblr

Oracle Database 19c stands as the paramount long-term edition, delivering unparalleled stability in releases along with the most extended period for obtaining support and rectifying errors. Oracle Database 19c, Release 19.13, now features AE (“all edition”) analytic views. While the Oracle 19c software can be downloaded at no cost, its deployment in a production setting necessitates obtaining a proper license. It’s important to note, an Oracle account is a requirement for the download process.

Unleash Power & Efficiency: A Deep Dive into Oracle Database 19c New Feature

This section highlights the novel functionalities introduced in the Oracle Database 19c New features through its Release Updates (RUs).

1. Update for Release 19.4: No novel functionalities were added in this update.

2. Update for Release 19.5: This update does not feature any new additions.

3. Update for Release 19.6: No innovations were introduced in this update.

4. Update for Release 19.7

  • SQL Macros (SQM)

5. Update for Release 19.8

  • Base Level for Database In-Memory
  • CellMemory Level

6. Update for Release 19.9

  • SwitchHome in Oracle Grid Infrastructure
  • Asymmetric Key Operations now supported by DBMS\_CRYPTO

7. Update for Release 19.10

  • Integration of Multiple Kerberos Principals with a Single Database Client
  • Introduction of DBMS\_CLOUD Package
  • New Initialization Parameters for Database Resident Connection Pooling (DRCP)
  • Introduction of Oracle Blockchain Table
  • Support for Oracle Instant Client on Linux for ARM
  • Per-PDB Capture now supported for Oracle Autonomous Database
  • Support updated for Micro Edition Suite (MES) for FIPS 140.2 compliance

8. Update for Release 19.11

  • Application Continuity Protection Check
  • Introduction of Immutable Tables
  • New Initialization Parameter for DRCP
  • Zip Copy Image Transfer in Oracle Fleet Patching and Provisioning

9. Update for Release 19.12

  • Gradual Rollover of Database Password for Applications
  • Oracle Memory Speed now supports PMEM Devices

10. Update for Release 19.13: This update did not introduce any new functionalities.

11. Update for Release 19.14: There were no new features added in this update.

12. Update for Release 19.15: No new functionalities were added.

13. Update for Release 19.16

  • Improvements in Identity and Access Management Integration within Oracle Database Environments
  • Redo Decryption by Oracle Data Guard for Hybrid Disaster Recovery configurations

14. Update for Release 19.17: No new functionalities were introduced.

15. Update for Release 19.18

  • Inclusion of All Time Zone Files (DST) in Release Updates (Rus)

16. Update for Release 19.19: This update saw no new features.

17. Update for Release 19.20

  • In-Memory Eligibility Test

18. Update for Release 19.21

  • AutoUpgrade now automates Data Guard Operations during Database Upgrade among other enhancements

19. Update for Release 19.22.0.0

  • Activation of Scrambled Dequeues and Dequeue Flow Control

Enhancements in Oracle SQL and PL/SQL in Version 19c

SQL Enhancements:

  • Support for GeoJSON Data
  • JSON Handling Enhancements
  • Implementation of JSON\_MERGEPATCH
  • Enhancements to JSON\_OBJECT
  • Addition of JSON\_SERIALIZE
  • Introduction of LISTAGG DISTINCT
  • Conversion of JSON Data To and From SQL Object Types
  • Support for Materialized View in Queries Using JSON\_TABLE
  • Usage of SQL NESTED Clause as an Alternative to JSON\_TABLE
  • Implementation of SQL Quarantine

PL/SQL Enhancements:

  • Few PL/SQL innovations were originally introduced in 19c, with some features from 21c being back-ported.
  • DBMS\_CLOUD now installable on both 19c and 21c On-Prem Databases
  • Introduction and enhancements in DBMS\_XPLAN

FAQ

  1. What is Multitenant Architecture in Oracle 19c 

Oracle Database 19c completes the Database 12c series, marking a significant enhancement in Multitenant technology by offering comprehensive functionalities. As 2019 unfolds, bringing the launch of 19c, it’s rewarding to reflect on the progression of Multitenant technology, which debuted with Oracle Database 12c in 2012 and has since evolved into a fully developed, stable, and recognized solution.

The “c” in “19c” represents Cloud, indicating that Multitenant is at the heart of Oracle’s Cloud Database Architecture. The mission statement for the Cloud, “isolation and agility alongside economies of scale”, perfectly captures the vision. Our ambition has consistently been to achieve this vision, in line with the statement detailed in this White Paper.

  1. Benefits of Oracle Multitenant Architecture Include:
  • Isolation of access among individual Pluggable Databases (PDBs) within the same Container Database (CDB)
  • Simplification in management of multiple databases through handling a single CDB that encompasses numerous PDBs. This approach minimizes the complexity by requiring fewer steps in administration tasks like backup, upgrade, or disaster recovery setup of the CDB rather than applying similar procedures to multiple standalone databases.
  • Efficient sharing of system resources to decrease CAPEX, along with the capability to adjust resource limits for elements such as memory and I/O at the level of individual PDBs
  • Enhanced flexibility for operating on a singular PDB, for instance, relocating a PDB to a different container and upgrading only that specific PDB
  • Quick cloning and provisioning processes
  • Seamless integration with Oracle RAC
  1. Primary Advantages of the Multitenant Approach:

1. Reduction in Capital Expenditures

    a. Hosting more applications per server

2. Lower Operational Expenses

    a. Unified management approach

    b. Standardization of procedures and services

    c. Enabling provision of self-service

3. Increased Flexibility

    a. Swift provisioning capabilities

    b. Pluggability enhances portability

    c. Scalability facilitated by RAC

4. Ease of Use

    a. No application modifications are needed for adoption

    b. SQL (and srvctl) serve as the user interfaces.

    The traditional models of consolidation often resulted in a trade-off between achieving scale economies and maintaining adaptability.

4. Minimum RAM Requirement for Oracle 19c

For both physical and virtual machine installations of Oracle 19c, it is imperative that the system meets the underlisted minimum requirements:

  • Processor: Must be AMD64 or Intel EM64T.
  • Physical RAM: A least 2 GB is necessary.
  • Swap (virtual memory): Should be minimum the equal of the physical memory (2 GB minimum).

5. The Function of Oracle 19c

Being a versatile database, Oracle Database 19c caters to both relational and non-relational data types including JSON, XML, text, as well as spatial and graph data, providing comprehensive support.

Conclusion:

IQ Stream delivers corporate training on various Oracle technologies to your workforce. Reach out to us now! Our expert trainers possess the necessary expertise to ensure a smooth and efficient implementation process that’s not only speedy and dependable but also enhances efficiency throughout every department within your company. For further information, kindly get in touch @+91- 9071449888(link to call)

Write A Comment

Enquiry Now
close slider

    Enquiry1

    captcha

    Call Now