When enabled, this feature offers the databases and replication directors with extra element about the rational adjust information staying processed.
DBAs now not must manually take care of composite domain indexes which is particularly useful for Oracle Textual content consumers. Parallel load and parallel insert is now supported for area indexes which is particularly beneficial for Oracle XML DB consumers.
The characteristic enhances join and failover occasions for person connections and system spawn times for history processes.
This characteristic allows easier and speedier loading of XML documents that are concatenated into bigger XML files.
This feature enables uncomplicated aggregation of data and reporting throughout shards. Additionally, it enables the flexibleness for just about any database software to execute SQL statements (which include Pick and DML) in techniques exactly where tables are sharded or replicated.
These enhancements result in less handbook steps demanded by an administrator to provision Oracle Databases consumers, minimizing set up time and lowering the chance of mistakes.
This can be a housekeeping action to scrub up undesired or obsolete backups of sparse databases which are not needed. Retention guidelines may affect the categorization standing of backups to mark as out of date.
As well as current logs, which might be primarily focused on reporting error cases, the cluster useful resource activity log incorporates information about resource activity through the cluster.
Prior to this release, the only real method of State-of-the-art index compression was small compression. Now you can also specify significant compression. Substantial compression provides even extra space savings than minimal compression.
An administrator can validate that a standby database will not comprise silent corruptions launched independently via the I/O stack at a standby database. Oracle Info Guard by now anonymous performs validation on scorching details (information currently being read through or modified) at both the first or standby database, but this new tool gives in depth validation, including cold info that has not been read through or altered by Oracle Facts Guard.
Each time a node fails, JDBC deprioritizes it and doesn't attempt to allocate connections from that host for another 10 minutes (the default expiry time). For example, if you will discover 3 nodes A, B, C, and A is down at some point in time, then Extra resources connections are allotted from nodes B and C, initial, then eventually to node A.
Oracle ACFS presents a file defragging tool On this launch. It is possible to run the defragging Instrument over a Stay Oracle ACFS file system using the acfsutil command.
An Oracle databases can now serve as a community file procedure (NFS) server. The databases now responds to NFS requests from any NFS consumer and retailers equally the documents as well as from this source their metadata within the database.
Users with more than one synchronous standby database vacation spot can lessen the impact of transient network failures by enabling the principal database to continue provided that a person synchronous standby databases has many of the redo.