Oracle 19C 91个新特性全记录

Oracle Database 19C一共发布91个新特性，这里做了分类，详细记录如下，
[quote]Install[/quote]
1、Ability to Create a Duplicate of an Oracle Database Using DBCA in Silent Mode
You can now create a duplicate of an Oracle database by using the createDuplicateDB command of DBCA in silent mode.

2、Root Scripts Automation Support for Oracle Database Installation
Starting with Oracle Database 19c, the database installer, or setup wizard, provides options to set up permissions to run the root configuration scripts automatically, as required, during a database installation. You continue to have the option to run the root configuration scripts manually.

3、Simplified Image Based Oracle Database Client Installation
Starting with Oracle Database 19c, the Oracle Database Client software is available as an image file for download and installation. You must extract the image software into a directory where you want your Oracle home to be located, and then run the runInstaller script to start the Oracle Database Client installation. Oracle Database Client installation binaries continue to be available in the traditional format as non-image zip files.

[quote]Pluggable Databases[/quote]
1、Ability to Create a PDB by Cloning a Remote PDB Using DBCA in Silent Mode
You can now create a PDB by cloning a remote PDB using the createFromRemotePDB parameter of the createPluggableDatabase command of DBCA in silent mode.

2、Ability to Relocate a PDB to Another CDB Using DBCA in Silent Mode
You can now relocate a PDB to another CDB by using the relocatePDB command of DBCA in silent mode.

3、Automated PDB Relocation
In Oracle Grid Infrastructure, you can use Fleet Patching and Provisioning to automate relocation of a PDB from one CDB to another.

4、PDB Recovery catalog
Pluggable databases (PDBs) are supported as a target database and a virtual private catalog (VPC) user can be used to more granularly control permissions to perform backup and restore operations at a PDB level. Metadata view is also limited, so a VPC user can view only data for which the user has been granted permission. In previous releases, connections to the recovery catalog when the target database is a PDB was not supported.

5、Workload Capture and Replay in a PDB
Oracle Real Application Testing was designed to capture and replay multitenant databases at the root container database (CDB) level. Starting with Oracle Database Release 19c, you can capture and replay the workload from within an individual pluggable database (PDB).

[quote]Core Security[/quote]
1、Ability to Grant or Revoke Administrative Privileges to and from Schema-Only Accounts
Administrative privileges such as SYSOPER and SYSBACKUP can now be granted to schema-only (passwordless) accounts.

2、New ALTER SYSTEM Clause FLUSH PASSWORDFILE_METADATA_CACHE
The ALTER SYSTEM clause FLUSH PASSWORDFILE_METADATA_CACHE refreshes the metadata cache with the latest details of the database password file. The latest details of the database password file can be retrieved by querying the V$PASSWORDFILE_INFO view.

3、Passwords Removed from Oracle Database Accounts
Most of the Oracle Database supplied schema-only accounts now have their passwords removed to prevent users from authenticating to these accounts.This enhancement does not affect the sample schemas. Sample schemas are still installed with their default passwords.Administrators can still assign passwords to the default schema-only accounts. Oracle recommends changing the schemas back to a schema-only account afterward.

4、Support for Host Name-Based Partial DN Matching for Host Certificates
This new support for partial DN matching adds the ability for the client to further verify the server certificate.The earlier ability to perform a full DN match with the server certificate during the Secure Sockets Layer (SSL) handshake is still supported. The client supports both full and partial DN matching. If the server DN matching is enabled, then partial DN matching is the default.

[quote]Data Guard[/quote]
1、Active Data Guard DML Redirection
Active Data Guard DML Redirection allows for incidental DML to be issued on an Active Data Guard standby database. When DML is executed, the update is passed to the Primary database where it is executed and the resulting redo of the transaction will update the standby after which control will be returned to the application. The DML is executed preserving all ACID properties of the transaction.

2、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.

3、Finer granularity Supplemental Logging
Supplemental logging was designed and implemented for Logical Standby or full database replication requirements. This adds unnecessary overhead in environments where only a subset of tables is being replicated. Fine-grained supplemental logging provides a way for partial database replication users to disable supplemental logging for uninteresting tables so that even when supplemental logging is enabled in database or schema level, there is no supplemental logging overhead for uninteresting tables.

4、Flashback Standby database when Primary database is flashed back
Flashback Database moves the entire database to an older point in time and opens the database with RESETLOGS. In a Data Guard setup, if the primary database is flashed back, the standby site is no longer in sync with the primary. In previous releases, getting the secondary to the same point in time as the primary requires a manual procedure to flash back standby databases. A new parameter is introduced which enables the standby database to be flashed back automatically when Flashback Database is performed on the primary database.

5、New Parameters for tuning automatic outage resolution with Data Guard
Oracle Data Guard has several processes on the Primary and Standby databases that handle redo transport and archiving which communicate with each other over the network. In certain failure situations, network hangs, disconnects, and disk I/O issues, these processes can hang potentially causing delays in redo transport and gap resolution. Data Guard has an internal mechanism to detect these hung processes and terminate them allowing the normal outage resolution to occur. In Oracle Database 19c, the DBA can tune the amount of wait time for this detection period by using two new parameters, DATA_GUARD_MAX_IO_TIME and DATA_GUARD_MAX_LONGIO_TIME. These parameters allow the waits times to be tuned for a specific Data Guard configuration based on the user network and Disk I/O behavior.

6、Observe only mode for Broker's Fast_Start Failover (FSFO)
When a database administrator configures Oracle Data Guard Broker's Fast Start Failover (FSFO) capability, they can now configure it to Observe only creating a test mode to see when a failover or other interaction would have occurred during normal production processing. This allows the user to tune the FSFO properties more precisely and to discover what circumstances in their environment would cause an automatic failover to occur. This makes it easier to justify using automatic failovers to reduce the recovery time for failovers.

7、Oracle Data Guard Multi-Instance Redo Apply works with the In-Memory Column Store
The Oracle Database In-Memory Column Store and Data Guard Multi-Instance Redo Apply can now be enabled at the same time on an Active Data Guard standby. Previously the two features were mutually exclusive.

8、Propagate Restore Points from Primary to Standby site
Normal restore points or guaranteed restore points can be defined at the primary site to enable fast point-in-time recovery in the event of any logical corruption issues. However, this restore point is stored in the control file and is not propagated to the standby database. In the event of a failover, the standby becomes the primary and the restore point information is lost. This feature ensures that the restore point is propagated from the primary to standby sites, so that the restore point is available even after a failover event.

9、Simplified Database Parameter Management in a Broker Configuration
Users can now manage all Data Guard related parameter settings using the SQL*Plus ALTER SYSTEM commands or in DGMGRL with the new EDIT DATABASE ... SET PARAMETER command. Parameter changes made in the DGMGRL interface are immediately executed on the target database. In addition this new capability allows the user to modify a parameter on all databases in a Data Guard configuration using the ALL qualifier, eliminating the requirement to attach to each database and execute an ALTER SYSTEM command or set a Broker property for each database with multiple EDIT PROPERTY commands. The SHOW command has also been updated to show the current setting of a parameter in the target database.

[quote]Application Continuity[/quote]
1、Application Continuity for Java: Declarative Request Demarcation
With the introduction of this feature, when Application Continuity for Java is configured in AUTO mode (that is service FAILOVER_TYPE=AUTO), the JDBC driver injects a beginRequest call at runtime, after the creation of a JDBC connection with the Replay Datasource.

2、Application Continuity for Java: New States Management
This feature introduces new session states including AL8KW_ERR_OVLAP, AL8KW_EDITION, AL8KW_SQL_TXLP, and AL8KW_ROW_ARCHIVAL, which are saved during normal activity and restored at failover, when FAILOVER_RESTORE is set and FAILOVER equals AUTO.

[quote]Real Application Clusters[/quote]
1、Automated Transaction Draining for Oracle Grid Infrastructure Upgrades
Automated Transaction Draining for Oracle Grid Infrastructure Upgrades provides automatic draining of transactions against the database instances, one node at a time, in a rolling fashion, according to the database service configurations. Transaction draining capabilities are an integral part of the database service design and are now automatically integrated into the application of rolling Oracle Grid Infrastructure patches.

2、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.

3、Support for Dry-Run Validation of Oracle Clusterware Upgrade
Starting with Oracle Grid Infrastructure 19c, the Oracle Grid Infrastructure installation wizard (gridSetup.sh) enables you to perform a dry-run mode upgrade to check your system's upgrade readiness.

[quote]Addm[/quote]
1、Automatic Database Diagnostic Monitor (ADDM) Support for Pluggable Databases (PDBs)
You can now use ADDM analysis for PDBs in a multitenant environment.

[quote]Indexes[/quote]
1、Automatic Indexing
The automatic indexing feature automates index management tasks, such as creating, rebuilding, and dropping indexes in an Oracle database based on changes in the application workload.

[quote]Sql Plan Management[/quote]
1、Automatic Resolution of SQL Plan Regressions
SQL plan management searches for SQL statements in the Automatic Workload Repository (AWR). Prioritizing by highest load, it looks for alternative plans in all available sources, adding better-performing plans to the SQL plan baseline. Oracle Database also provides a plan comparison facility and improved hint reporting.

[quote]Active Directory[/quote]
1、Automatic Support for Both SASL and Non-SASL Active Directory Connections
Starting with this release, both Simple Authentication and Security Layer (SASL) and Transport Layer Security (TLS) binds are supported for Microsoft Active Directory connections.For centrally managed users, the Oracle database initially tries to connect to Active Directory using SASL bind. If the Active Directory server rejects the SASL bind connection, then the Oracle database automatically attempts the connection again without SASL bind but still secured with TLS.

[quote]In-Memory Column Store[/quote]
1、Big Data and Performance Enhancements for In-Memory External Tables
In-Memory external tables add support for ORACLE_HIVE and ORACLE_BIGDATA drivers, parallel query, Oracle Real Application Clusters, Oracle Active Data Guard, and on-demand population.

2、Database In-Memory Wait on Populate
The DBMS_INMEMORY_ADMIN.POPULATE_WAIT function waits until objects at the specified priority have been populated to the specified percentage.

3、Resource Manager Automatically Enabled for Database In-Memory
When INMEMORY_SIZE is greater than 0, Oracle Database Resource Manager is automatically enabled.

[quote]SQL[/quote]
1、Bitmap based count distinct SQL Function
New bitvector SQL operators can be used to speed up COUNT DISTINCT operations within a SQL query. To compute COUNT(DISTINCT) for numeric expressions, you can create a bitvector representation of the expressions and aggregate them before the final bit count. The resulting bitvector can be materialized, such as in a materialized view.You can construct bitvectors by further grouping on a larger set of GROUP BY keys than targeted queries, so that one materialized view can be used to rewrite multiple GROUP BY queries with COUNT(DISTINCT) expressions by using ROLLUP.

2、DISTINCT option for LISTAGG aggregate
The LISTAGG aggregate function now supports duplicate elimination by using the new DISTINCT keyword.

[quote]Flashback[/quote]
1、Clear Flashback logs periodically for increased FRA size predictability
Customers have many databases that all use the Fast Recovery Area (FRA). They usually subscribe to FRA by using the recovery_dest_size initialization parameter. Difficulties arise when flashback logs are not cleared until space pressure requires it. In many cases, the only remedy is to turn off flashback logging and turn it back on. This feature makes flashback space usage become predictable from a storage management perspective, since flashback uses no more space than is required by retention. This feature also allows users to control cumulative space pressure by adjusting the flashback retention.

[quote]Database Vault[/quote]
1、Database Vault Command Rule Support for Unified Audit Policies
You can now create Oracle Database Vault command rules for unified audit policies.

2、Database Vault Operations Control for Infrastructure Database Administrators
In a multitenant database, you can now use Oracle Database Vault to block common users (infrastructure DBAs, for example) from accessing local data in pluggable databases (PDBs).

[quote]Sharding[/quote]
1、Generation of Unique Sequence Numbers Across Shards
Before Oracle Database 19c, if you needed a unique number across shards you had to manage it yourself. In Oracle Database 19c, Oracle Sharding allows you to generate globally unique sequence numbers across shards. You can use this functionality to generate globally unique sequence numbers for non-primary key columns with unique constraints, or any other case in which a Sequence object must be a single logical object across all shards of a sharded database.

2、Multiple Table Family Support for System-Managed Sharding
The Oracle Sharding feature for Oracle Database 18c supported only one table family (a set of related tables sharing the same sharding key) for each sharded database. In Oracle Database 19c, Oracle Sharding allows a sharded database to support multiple table families, each of which can be sharded with a different sharding key. Data from different table families reside in the same chunks. This feature applies to system-managed sharded databases only.

3、Support for Multi-Shard Query Coordinators on Shard Catalog Standby Databases
Before Oracle Database 19c, only the primary shard catalog database could be used as the multi-shard query coordinator. In Oracle Database 19c, you can also enable the multi-shard query coordinator on the shard catalog's Oracle Active Data Guard standby databases.

4、Support for Multiple PDB Shards in the Same CDB
Oracle Sharding with Oracle Database 18c supported one pluggable database (PDB) shard in a CDB. In Oracle Database 19c, Oracle Sharding enables you to use more than one PDB in a CDB for shards or shard catalog databases, with certain restrictions. For example, this feature allows a CDB to contain shard PDBs from different sharded databases, each with its own separate shard catalog database.

5、Propagation of Parameter Settings Across Shards
Before Oracle Database 19c, database administrators had to configure ALTER SYSTEM parameter settings on each shard in a sharded database.

[quote]Optimizer[/quote]
1、High-Frequency Automatic Optimizer Statistics Collection
You can configure a lightweight, high-frequency automatic task that periodically gathers optimizer statistics for stale objects.

2、Real-Time Statistics
Oracle Database automatically gathers online statistics during conventional DML operations.

[quote]Partitioning[/quote]
1、Hybrid Partitioned Tables
The Hybrid Partition Tables feature extends Oracle Partitioning by enabling partitions to reside in both Oracle Database segments and in external files and sources. This feature significantly enhances the functionality of partitioning for Big Data SQL where large portions of a table can reside in external partitions.

[quote]Application Express[/quote]
1、Improved Create Application Wizard
The completely revamped Create Application Wizard provides the following:An all new low-code method of creating applications.A new and improved user experience for creating applications.Simpler and modernized wizards for creating pages.The ability to create more advanced pages such as Dashboards and Master-Detail.Support for adding common frameworks or features when creating an application such as access control, activity reporting, or theme selection.The ability to customize user interface options such as Theme Style, the application icon, and page icons.

2、Improved Create Page Wizard
The revamped Create Page Wizard includes the following improvements:New page type: Side by Side Master Detail - The left panel allows searching on the master record. The right panel displays the master record using a value pair report, and up to four detail reports using classic reports.New page type: Dashboard - Select from different chart layouts that are based on sample data. The generated charts can easily be updated in Page Designer post-generation.The ability to add common frameworks or features to an existing application, such as access control, activity reporting, theme selection, and more (providing the application is utilizing the Universal Theme).The ability to add Email Reporting and Job Reporting (providing jobs are defined in the default schema).The ability to create an Administration page for features, or select an existing page.

3、New REST Workshop
Before release 18.1, the definitions of RESTful services created within Application Express were stored within the metadata tables of the core Application Express schema. Now Oracle Application Express can utilize the Oracle REST Data Services (ORDS) repository, provided that Application Express is using ORDS 17.4 or above. Oracle recommends the migration of all RESTful services to the Oracle REST Data Services (ORDS) repository.Existing Application Express-based REST services can readily be migrated to the new ORDS repository. The Application Express-based REST services continue to work, however, you cannot create new or edit existing Application Express based RESTful services.

4、Web Source Modules
Oracle Application Express introduces a new data source type called Web Source Modules, a declarative method to define references to external REST APIs and generic JSON data feeds. Web Source Modules store additional metadata about how to parse response data and map it as a virtual table with rows and columns. A module can contain one or many Web Source Operations which are the references to a concrete external web service.Web Source Modules can also include post-processing SQL which modifies the data before being processed by the Oracle Application Express component. This SQL can be used to apply functions, aggregations, or join with local tables.Web Source Modules can be used as the basis for all report types, such as interactive reports and classic reports, but not Interactive Grid regions. These modules can also be used with Calendars, JET Charts, Trees, and PL/SQL Processes.

5、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.Oracle Application Express passes the SQL or PL/SQL query to ORDS over REST, and a self-describing JSON response is returned. The JSON object contains result set metadata, the result data, and pagination details.REST Enabled SQL references can be used as the basis for all report types, such as interactive reports and classic reports, but not Interactive Grid regions. References can also be used with Calendars, JET Charts, Trees, and PL/SQL Processes.

6、Social Sign-In Authentication
Social Sign-In preconfigured authentication scheme supports authentication with Google, Facebook, and other social network that supports OpenIDConnect or OAuth2 standards.

[quote]JSON[/quote]
1、JSON Update Operations
You can now update a JSON document declaratively using the new SQL function json_mergepatch. You can apply one or more changes to multiple documents by using a single statement.

2、JSON-Object Mapping
This feature enables the mapping of JSON data to and from SQL object types and collection types.

3、Materialized View Support for Queries containing JSON_TABLE
Materialized views query rewriting has been enhanced so that queries with JSON_EXISTS, JSON_VALUE and other functions can utilize a materialized view created over a query that contains a JSON_TABLE function.

4、New SQL/JSON Function JSON_SERIALIZE and JSON Data Guide Support for GeoJSON Data
You can use the new SQL/JSON function json_serialize to serialize JSON data to text or to UTF-encoded BLOB data. The json_dataguide SQL aggregate function can now detect GeoJSON geographic data in your documents.

5、SQL/JSON Syntax Simplifications
Syntax simplifications are offered for SQL/JSON path expressions, SQL/JSON generation with the json_object function, and field projection with the SQL/JSON nested clause.

[quote]Java[/quote]
1、Java Library for Reactive Streams Ingestion
This feature describes the new Java library for high speed ingestion of data streams with non-blocking back pressure.Java applications that use the provided APIs may continuously receive and ingest data from a large group of clients.The ingestion process is non-blocking and extremely fast through the direct path load into the database tables.Through the Universal Connection Pool (UCP), the ingestion process inherits Oracle RAC and Sharded database support, and furnishes high availability and scalability.

[quote]Encryption[/quote]
1、Key Management of Encrypted Oracle-Managed Tablespaces in Transparent Data Encryption
In this release, a closed TDE encryption keystore has no impact on internal operations to Oracle-managed tablespaces.

2、Transparent Online Conversion Support for Auto-Renaming in Non-Oracle-Managed Files Mode
Starting with this release, in a Transparent Data Encryption online conversion in non-Oracle-managed files mode, you are no longer forced to include the FILE_NAME_CONVERT clause in the ADMINISTER KEY MANAGEMENT SQL statement. The file name retains its original name.

3、Support for Additional Algorithms for Offline Tablespace Encryption
In previous releases, only the AES128 encryption algorithm was supported for offline tablespace encryption. This release adds support for the AES192 and AES256 encryption algorithms, as well as for the ARIA, GOST, and 3DES encryption algorithms for offline tablespace encryption.

[quote]In-Memory Row Store[/quote]
1、Memoptimized Rowstore - Fast Ingest
The Memoptimized Rowstore's fast ingest functionality enables fast data inserts into an Oracle database from applications, such as Internet of Things (IoT) applications that ingest small, high volume transactions with a minimal amount of transactional overhead. The insert operations that use fast ingest temporarily buffer the data in the large pool before writing it to disk in bulk in a deferred, asynchronous manner.

[quote]Audit[/quote]
1、New EVENT_TIMESTAMP_UTC Column in the UNIFIED_AUDIT_TRAIL View
The new EVENT_TIMESTAMP_UTC column appears in the UNIFIED_AUDIT_TRAIL view. Query the UNIFIED_AUDIT_TRAIL view based on the EVENT_TIMESTAMP_UTC column in the WHERE clause. The new column helps partition pruning, improving the read performance of the UNIFIED_AUDIT_TRAIL view.

2、New PDB_GUID Audit Record Field for SYSLOG and the Windows Event Viewer
The audit record fields for SYSLOG and the Windows Event Viewer now include a new field, PDB_GUID, to identify the pluggable database associated with a unified audit trail record.

3、Unified Auditing Top-Level Statements
The unified auditing top-level statements feature enables you to audit top-level user (direct user) activities in the database without collecting indirect user activity audit data.

[quote]Data Pump[/quote]
1、Oracle Data Pump Test Mode for Transportable Tablespaces
Test Mode for Transportable Tablespaces performs a metadata-only export test using Transportable Tablespaces or Full Transportable Export/Import. It also removes the requirement for the source database tablespaces to be in read-only mode.

2、Oracle Data Pump Ability to Exclude ENCRYPTION Clause on Import
A new transform parameter, OMIT_ENCRYPTION_CLAUSE is introduced that causes Data Pump to suppress any encryption clauses associated with objects using encrypted columns.

3、Oracle Data Pump Allows Tablespaces to Stay Read-Only During TTS Import
A new option allows the user to restore pre-12.2 default behavior, such that tablespace data files can be read-only during the Transportable Tablespace (TTS) import process. The benefit is that this allows a tablespace data file to be mounted on two databases, so long as it remains read-only. However, using this option requires that the source and target databases have exactly the same daylight savings time (DST) version because TIMESTAMP WITH TIMEZONE data will not be adjusted upon import. Also, if this parameter is specified then the database does not automatically rebuild tablespace bitmaps to reclaim space during import. This can make the import process faster at the expense of regaining free space within the tablespace datafiles.

4、Oracle Data Pump Allows Wildcards for Dumpfile in Object Store
Oracle Data Pump simplifies importing multiple dumpfiles into Oracle Autonomous Database by allowing wildcards for URL-based dumpfile names.

5、Oracle Data Pump Prevents Inadvertent Use of Protected Roles
Oracle Data Pump prevents inadvertent use of protected roles during export and import with the new command-line parameter ENABLE_SECURE_ROLES.

6、Oracle Data Pump Support for Resource Usage Limitations
Two new parameters, MAX_DATAPUMP_JOBS_PER_PDB and MAX_DATAPUMP_PARALLEL_PER_JOB are introduced to give DBAs more control over the number of jobs that can be started in a multitenant container database environment, and over the number of parallel workers that can be used for an individual Data Pump job, respectively.

7、Oracle Data Pump import supports more object store credentials
Oracle Data Pump import supports object store credentials beyond the default_credential with a new CREDENTIAL parameter for Oracle Autonomous Database.

[quote]Diagnosibility[/quote]
1、Oracle Cluster Health Advisor Integration into Oracle Trace File Analyzer
Oracle Trace File Analyzer now integrates with Oracle Cluster Health Advisor and consumes the problem events that Oracle Cluster Health Advisor detects. When Oracle Cluster Health Advisor detects a problem event, Oracle Trace File Analyzer automatically triggers the relevant diagnostic collection and sends an email notification. You can configure email notification through the standard Oracle Trace File Analyzer notification process.

2、Oracle ORAchk and Oracle EXAchk Now Show Only the Most Critical Checks by Default
By default, only the most critical checks are shown in the report output. The critical checks are those that Oracle judges to have the most severe potential effect. All other checks are still run and are available in the report. You can view them by selecting the appropriate option under the Show checks with the following status control.

3、Oracle ORAchk and Oracle EXAchk REST Support
Oracle ORAchk and Oracle EXAchk now include REST support, allowing invocation and query over HTTPS. To facilitate this REST support, Oracle REST Data Services (ORDS) is included within the installation.

4、Oracle ORAchk and Oracle EXAchk Support for Encrypting Collection Files
Oracle ORAchk and Oracle EXAchk diagnostic collection files may contain sensitive data. Starting in this release, you can encrypt and decrypt diagnostic collection ZIP files and protect them with a password. This feature is available only on Linux and Solaris platforms.

5、Oracle ORAchk and Oracle EXAchk Support for Remote Node Connections without Requiring Passwordless SSH
In earlier releases, remotely running Oracle ORAchk or Oracle EXAchk required configuration of passwordless SSH between the remote nodes. Starting in this release, you can configure Oracle ORAchk and Oracle EXAchk to autogenerate the private key files for the remote nodes. Alternatively, you can provide a private key.

6、Oracle Trace File Analyzer REST API Support
Oracle Trace File Analyzer now includes REST support, allowing invocation and query over HTTPS. To help develop and test this REST support, Oracle REST Data Services (ORDS) are included within the installation. REST supports printing details, starting a diagnostic collection, and downloading collections.

7、Oracle Trace File Analyzer Search Extended to Support Metadata Searches
In earlier releases, Oracle Trace File Analyzer's search function was limited to log and trace file strings. Starting in this release, all metadata stored in the Oracle Trace File Analyzer index is searchable using tfactl. Oracle Trace File Analyzer searches log and trace file metadata using JSON-formatted name-value pairs representing datatypes and events.

8、Oracle Trace File Analyzer Support for Using an External SMTP Server for Notifications
In earlier releases, Oracle Trace File Analyzer required monitored hosts to have local sendmail or SMTP support in order to deliver email notifications of alerts. Starting in this release, you can configure an external SMTP server to receive these notifications from Oracle Trace File Analyzer and alert the administrators.

9、Oracle Trace File Analyzer Supports New Service Request Data Collections
Service Request Data Collections (SRDCs) simplify the collection of required logs and data for specific issues. This release adds additional database SRDCs that cover more ORA errors and problems in infrastructure such as Oracle Automatic Storage Management (ASM), Oracle Automatic Storage Management Cluster File System (ACFS), Listeners, auditing, and Recovery Manager (RMAN).

[quote]Networking[/quote]
1、Oracle Network Log File Segmentation
The maximum size and number of text log files can be configured for Oracle Network components such as Oracle Net Listener, CMAN and GSM.

2、SQL*Net: Auto-Detection of Support for Out-of-Band Breaks
Out-of-band breaks were enabled by default for UNIX platforms in past releases. However, this configuration causes numerous problems when network devices on the path between the client and the server do not allow out-of-band data to pass through. This data may either be dropped or inlined leading to server-side problems such as TNS errors or data corruption. These problems are often very hard to diagnose. The solution is to turn off usage of out-of-band data manually by setting a sqlnet.ora parameter.

3、Support for Oracle Native Encryption and SSL Authentication for Different Users Concurrently
In previous releases, Oracle Database prevented the use of Oracle native encryption (also called Advanced Networking Option or ANO encryption) and Secure Sockets Layer (SSL) authentication together.

[quote]Patching[/quote]
1、Oracle Restart Patching and Upgrading
Use Fleet Patching and Provisioning to patch and upgrade Oracle Restart. In previous releases, Oracle Restart environments required the user to perform patching and upgrade operations, often involving manual intervention. Fleet Patching and Provisioning automates these procedures.

[quote]ASM[/quote]
1、Parity Protected Files
The REDUNDANCY file type property specifies the redundancy for a file group. The PARITY value specifies single parity for redundancy. The parity setting is intended for write-once files, such as archive logs and backup sets.

[quote]Privilege Analysis[/quote]
1、Privilege Analysis Now Available in Oracle Database Enterprise Edition
Privilege analysis is now available as part of Oracle Database Enterprise Edition.

[quote]SQL Performance[/quote]
1、SQL Diagnostics and Repair Enhancements
The SQL diagnostics and repair tools, such as SQL Test Case Builder and SQL Repair Advisor have been enhanced to provide better diagnosis and repair capabilities for managing problematic SQL statements.

2、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.

3、Real-Time SQL Monitoring for Developers
Database users without SELECT_CATALOG_ROLE can generate and view SQL Monitor reports for their own SQL statements, including the execution plans and performance metrics.

[quote]Lobs/Securefiles[/quote]
1、Signature-Based Security for LOB Locators
Starting with this release, you can configure signature-based security for large object (LOB) locators.

更多内容请关注墨天轮DBHUB [url=https://cs.enmotech.com/topic/5]19C专题[/url]
[code]2019-02-16 09:24:28 | 19C EM Express
2019-02-16 08:59:47 | Oracle 19C ADG DML操作重定向测试
2019-02-16 03:09:59 | New search function for Oracle database features
2019-02-15 23:09:03 | Oracle 19C 91个新特性全记录
2019-02-15 10:34:20 | 官宣：Oracle数据库19c在Oracle Exadata上发布啦！
2019-02-15 00:05:12 | 抢鲜体验：Oracle 19C单实例数据库安装步骤详解
2019-02-14 21:26:34 | Oracle Database 19c requires OL7, RHEL7 or SLES12 or newer
2019-02-14 18:30:00 | Oracle 19C_Install_for_CentOS Linux release 7.5
2019-02-14 11:26:53 | Oracle 19C官方文档公布
2019-02-14 10:31:02 | 快讯：Oracle Database 19c 已发布提供公开下载
2019-02-14 06:26:19 | Oracle Database 19c Now Available on Oracle Exadata
2019-02-14 03:26:02 | Oracle 19c and my favorite list
2019-02-14 03:25:45 | Oracle Database 19.2 for Exadata is now available for download
2019-02-13 21:23:17 | Oracle 19c 新特性：ANY_VALUE 函数和 LISTAGG 的增强
2019-02-12 18:02:28 | 快讯：Oracle 19c 新特性及官方文档抢鲜下载
2019-02-11 22:08:01 | Oracle 19c 新特性：ADG的自动DML重定向增强读写分离
2019-01-21 13:06:07 | Oracle 19C率先在LiveSQL发布
2018-12-23 09:21:03 | 圣诞快乐：Oracle Database 19c 的10大新特性一览
2018-12-21 03:28:25 | Oracle Database 19c Beta Program
2018-12-07 10:26:08 | Oracle Database 19c: The best upcoming features..!![/code]