The partition maintenance functions SPLIT PARTITION and SPLIT SUBPARTITION can now be executed as online operations for heap structured tables, permitting the concurrent DML operations with the continuing partition servicing Procedure.
More database capabilities can be utilized in the Data Redaction policy expressions. Normal database substring capabilities now are supported.
In addition to ON COMMIT and ON Need refresh, the materialized be part of views may be refreshed whenever a DML operation requires spot, with no must dedicate such a transaction. This is certainly predominantly suitable for star schema deployments.
Website services callout is a brand new utility that enables the invocation of exterior World-wide-web services from inside a database session (SQL, PL/SQL or Java). The Resource can perform the subsequent:
You'll be able to configure cluster nodes to implement both IPv4 or IPv6 dependent IP addresses on a private community, and more than one non-public network may be used for the cluster.
Oracle Sophisticated Analytics algorithms ended up enhanced to maximally exploit in-database parallel execution for equally design building and design application, provide improved extensibility, and make use of new computing strategies.
This attribute considerably expands the quantity of alternate Locations you can define. It provides greater flexibility to designate guidelines that determine priority, and it provides several selections for defining procedures in the failure point out.
You will find a new ROLLBACK parameter for the FINISH_REDEF_TABLE treatment that tracks DML over a freshly explanation redefined desk so that variations can be quickly synchronized with the original table utilizing the SYNC_INTERIM_TABLE course of action.
Populating try this the materialized values of commonly used query expressions in to the In-Memory Column Retailer considerably reduces the process assets required to execute queries and allows for much better scalability.
This enhancement decreases the volume of manual steps expected by directors to provision Kerberos authentication for Oracle databases, lowering setup time and reducing the danger for glitches.
Server excess weight-based mostly node eviction functions as a tie-breaker mechanism in conditions the place Oracle Clusterware really should evict a specific node or a gaggle of nodes from a cluster, during which all nodes represent an equal choice for eviction.
Developers can now control the procedure for handling overflowing LISTAGG aggregates. This enhances the efficiency and flexibility of this aggregation function.
Oracle Information pop over here Guard is a higher availability (HA) or Highest Availability Architecture (MAA) characteristic crucial for catastrophe recovery deployments. By enabling simpler and much more efficient strategies to enhance the DUPLICATE command to produce significantly sync standby aid and by allowing for generation of a regular databases, this characteristic increases the Positive aspects for deploying Oracle Information Guard by offloading processes for the standby databases.
Materialized views refresh figures may be collected in different degrees of granularity to deliver historical information for Assessment and reporting.