Database

Get Involved. Join the Conversation.

Topic

    Hany Ezzat Hassan
    What to look for in brand new Oracle Database 19c
    Topic posted August 8, 2019 by Hany Ezzat HassanSilver Medal: 2,000+ Points 
    31 Views
    Title:
    What to look for in brand new Oracle Database 19c
    Summary:
    New features in Oracle Database 19c
    Content:

    Oracle database 19c builds on top of the innovation and improvements of previous releases such as Multitenant, In-memory, JSON object support for Developers, Sharding and many other features that enable Oracle’s Autonomous database cloud services .

    Oracle Database 19c is a long term support release of Oracle database 12c Family (which includes Oracle database 18c) .

    Oracle Database 19c is now available on (AIX , HP/UX , Windows ,zlinux , linux ) for you to download, but you can also retrieve ready

     

    • RAC & Grid infrastructure - Zero-Downtime Oracle Grid Infrastructure Patching: Zero-Downtime Oracle Grid Infrastructure Patching enables patching of Oracle Grid Infrastructure without interrupting database operations. Patches are applied out-of-place and in a rolling fashion, with one node being patched at a time, while the database instances on the node remain operational. Zero-downtime Oracle Grid Infrastructure Patching supports Oracle Real Application Clusters (Oracle RAC) databases on clusters with two or more nodes. Zero-Downtime Grid Infrastructure Patching significantly increases database availability by allowing customers to perform a rolling patch of Oracle Grid Infrastructure without interrupting database operations on the node being patched and without impacting capacity or performance on those database instances.
    • Performance - SQL Quarantine: SQL statements that are terminated by Oracle   Database Resource Manager due to their excessive consumption of CPU and I/O resources can be automatically quarantined. The execution plans associated with the terminated SQL statements are quarantined to prevent them from being executed again.This feature protects an Oracle database from performance degradation by preventing execution of SQL statements that excessively consume CPU and I/O resources.
    • Availability - Dynamically change Fast-Start Failover (FSFO) target : Currently the DBA must disable Fast_Start Failover in order to change the FSFO Target standby. With the arrival of multiple FSFO targets in Oracle Database 12.2.0.1, this becomes even more important. This new command allows the user to dynamically change the FSFO Target standby to another standby in the target list without requiring that FSFO be disabled.Forcing the user to disable FSFO to move to a new target standby exposes the configuration to a period where automatic failover cannot be used at all.
    • Application Development - REST Enabled SQL Support: As opposed to creating Database Links, Oracle Application Express installations that utilize Oracle REST Data Services (ORDS) 17.3 or later, can now execute any SQL through a REST endpoint. Developers can easily create REST Enabled SQL references by defining a name, the endpoint URL, and authentication information within Shared Components.

    Do you want to find more about what is New in Oracle database 19c such as Automatic Indexing, Secure Cluster Communication, Trace File Analyzer, Cluster health checks, Machine learning user interface (Data Miner), Security, Big data & Data warehousing ,Diagnosability and more.

    And feel free to contact us in case of upgrade/migration/adoption projects.https://blogs.oracle.com/imc