Oracle Database 19c Features

 Oracle Database 19c Features

Introduction

Oracle Database 19c is the long term release of the Oracle Database 12c and 18c family of products,it is available on all platformsWindows,Linux,Solaris,HP/UX and AIX as well as the Oracle cloud. Oracle Database 19c offers customers the best performance,scalibility,reliability, and security for all their operational and analytical workloads

Installation

Rpm based Installation install oracle 19c datbase using RPM method

Simlified image based installation of client as well

Upgrades

Auto Upgrade Utility for oracle Database

Docker Container for oracle 19c

Dryrun mode for Gridsetup in clusterware installation

General

Clear Flashback logs from time to time

Passwords removed from user accounts (default accounts)

Flush Metadata Cache for passwords

Multi-model partitioning with hybrid partioning allowing some partitions in database and some as external partitions even in HDFS

New ALTER SYSTEM  statement clause FLUSH PASSWORDFILE_METADATA_CACHE

Hybrid  Partitioned tables - to integerate internal partitions and external partitions  into a single partition table. partitions to reside in both oracle database segments and in external files and sources

Schema-only accounts -Passwords Removed from oracle database accounts  

Database Performance

SQL Quarantine - using Oracle's Resource manager tool is a great way to make sure SQL statements dont become resource hogs and slow down database performance everyone,if a system asks for more system resorces than the DBA allows ,Resources manager kills it,However in existing versions of oracle database,nothing stops users from executing problematic SQL statements again. In oracle 19C ,Resource manager can automatically quarantine the statements, user try to issue once again it wont be run at all

Automatic Indexing

This new feature puts oarcale automation capabilities to work.if oracle 19c thinks a database table would be benifit from an index,the system will automatically create the index and initially mark it as invisible so it cant be used .oracle 19c will then run SQL statements  from your application to see if the index improves query execution you can control this feature  with DBMS_AUTO_INDEX< a new PL?SQL package that's included in 19c

SQL Statement Diagnosability 

SQL Statement Diagnosability with SQL Advisor repair and SQL Test case for procedures

Automatic Database Diagnostic Monitor(ADDM)

ADDM supports for pluggable Database (PDB'S)

Realtime  Statastics For DML Operations

Oracle database 19c intoduces real time statastics which extend online support to conventional DML statements

Automatic Flashback of Standby Database

in prior versions DBA's wanted touse oracle flashback features to return  aprimary database to previous state,In oracle 19c ,a DBA can put the standby database in MOUNT mode with no managed recovery and then flashback the primary one ,the standby will aslo be reverted,thus keeping it in sync with the primary Statistics Collection on custom frequency automatically From 19c database onwards ,High frequency automatic optimizer statastics collection complements the standard statasticscollection job

DataPump

Oracle data pump test mode for transportable tablespace(TTS)

Oracle data pump allows tablespace to stay read -only during TTS import

Oracle data pump import supports more object store credentials

Oracle data pump ability to exclude ENCRYPTION clause on import-new transform  parameter OMIT_ENCRYPTION_CLAUSE

Oracle data pump support for resource usage limitations_new parameter MAX_DATAPUMP_PARALLEL_PER_JOB

Oracle data pump prevents inadvertent use of protected roles-new ENABLE_SECURE_ROLES parameter is available

Oracle data pump loads partitioned table data one operation-GROUP_PARTITION_TABLE_DATA,  new value for the import DATA_OPTIONS Command line paramaeter

Pluggable Databases

Create Duplicate of an oracle database create duplicatedb command , in DBCA silent mode

Ability to relocate a PDB to another CDB using DBCA in silent mode

Create a PDB by cloning a remote PDB using DBCA in silent mode

ADDM Analysis at PDB level

Data Guard

Replicate Restore points from primary to standby

Dynamically change  fast-start- failover (FSFO) target standby database to another standby database in the target list without disabling FSFO

Re-creation of broker configuration

Propagate restore points from primary to standby site

DML redirect to standby/ADG for read mostly applications

Simplified Dataguard broker parameter configurations

Observe only mode for data guard broker fast-satrt failover (FSFO)

Oracle dataguard multi-instance redo apply works with the in-memory column store

Finer granularity supplemental logging for logical standby databases

New Initialization Parameters in Oracle Database 19c 

"-optimizer_gather_stats_on_conventional_dml" and " _optimizer_use_stats_on_conventional_dml" which are true by default

-optimer_stats_on_conventional_dml_sample_rate(at 100%)

DATA_GUARD_MAX_IO_TIME

DATA_GUARD_MAX_LONGIO_TIME

MAX_DATAPUMP_JOBS_PER_PDB

THANKS FOR VIEWING MY BLOG FOR MORE UPDATES FOLLOW ME OR SUBSCRIBE ME