19c 新特性-1

1.Application Express（APEX组件）--没有验证

General

2.Application Continuity for Java  --没有验证

Application Continuity向应用屏蔽了数据库中断，好处是应用不会因为数据库问题导致执行失败。有限制

Note: You must use Transaction Guard for using this feature.

Application Continuity is a feature of the Oracle JDBC Thin driver and is not supported by JDBC OCI driver.

For applications using an XA data source, the connection initialization callback is registered on the XA replay data source. The callback is executed every time when both of the following happen:

• A connection is borrowed from the connection pool.

• The replay XA data source gets a new physical connection at failover.

$ srvctl add service -db codedb -service GOLD -preferred serv1 -available serv2 -clbgoal SHORT -rlbgoal SERVICE_TIME -failover_restore AUTO -failoverretry 30 -failoverdelay 10 -commit_outcome TRUE -failovertype AUTO -replay_init_time 1800 -retention 86400 -notification TRUE

$ srvctl add service -db codedb -service GOLD -preferred serv1 -available serv2 -clbgoal SHORT -rlbgoal SERVICE_TIME -failover_restore LEVEL1 -failoverretry 30 -failoverdelay 10 -commit_outcome TRUE -failovertype TRANSACTION -replay_init_time 1800 -retention 86400 -notification TRUE

the DBA must grant KEEP privileges to the user who invokes the function.

Grant KEEP DATE TIME, KEEP SYSGUID to [custom user]; Grant KEEP DATE TIME, KEEP SYSGUID to [apps user];

3.Easy Connect Plus

Starting with Oracle Database 19c release, the Easy Connect syntax that applications use to connect to Oracle Database has improved functionality. The new version is called Easy Connect Plus.

Easy Connect Plus simplifies Oracle Database application configuration and deployment for common use cases. With Easy Connect Plus, you no longer need to configure Oracle Net parameter files such as tnsnames.ora and sqlnet.ora. Easy Connect Plus also no longer requires you to set the TNS_ADMIN environment variable.

salesserver1:1521/sales.us.example.com?sdu=16384 <=>

(DESCRIPTION= (SDU=16384) (ADDRESS=(PROTOCOL=tcp)(HOST=saleserver1)(PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=sales.us.example.com)))

11g：

Default

NAMES.DIRECTORY_PATH=(tnsnames, ldap, ezconnect)

连接方式变了。

4.Oracle Network Log File Segmentation

限制文件大小

SQL*Net: Auto-Detection of Support for Out-of-Band Breaks

JSON

Materialized View Support for Queries Containing JSON_TABLE

Queries with JSON_EXISTS, JSON_VALUE, and other functions can now utilize a materialized view created over a query that uses JSON_TABLE function.

JSON Update Operations

SQL/JSON Syntax Simplifications

JSON Object Mapping

New SQL/JSON Function JSON_SERIALIZE and JSON Data Guide Support for GeoJSON Data

SQL

DISTINCT Option for LISTAGG Aggregate

11g：

19c：

默认是加all：