The Common Relationship Pool aspect which boosts Java apps functionality by decreasing the overhead and frequency of link overall health validation during major website traffic.
This function enhances the performance of client-facet encoding and decoding of binary XML by decreasing the improvements with the tokens that have to be reloaded all through encoding and decoding functions.
The existing Solid operate is Increased to return a user-specified benefit in the situation of the conversion error in lieu of raising an mistake.
Web services callout is a completely new utility that enables the invocation of external Internet services from within a database session (SQL, PL/SQL or Java). The Device can do the subsequent:
It is valuable to collect supplementary details for Association Procedures to help recognize the worth of each and every rule on the company.
DBAs not really have to manually regulate composite domain indexes which is especially advantageous for Oracle Textual content customers. Parallel load and parallel insert is now supported for domain indexes which is very helpful for Oracle XML DB customers.
An Oracle databases can now serve as a network file process (NFS) server. The database now responds to NFS requests from any NFS shopper and retailers equally the files as well as their metadata in the database.
A related consumer with a databases unknowingly must not let a definer's rights course of action proprietor on that databases to complete database operations with a remote database, logging in as that connected user. This new privilege should be explicitly granted to allow these kinds of functions.
People with multiple synchronous standby databases destination can reduce the impression of transient community failures by letting the main database to continue assuming that just one synchronous standby database has many of the redo.
This aspect supplies sizeable performance improvements involving parallelism and optimization enabling all algorithms to scale to data volumes found in major data and cloud use conditions.
There are very important top quality clients who make use of PL/SQL APIs to enqueue and dequeue JMS payload in unsharded queues thanks to simplicity-of-use and to stay away from shopper-server spherical journey time.
Oracle Active Info Guard allows a standby database to get opened in read-only method. This functionality allows enterprises to off-load generation reporting visit this website workloads from their Main databases to synchronized standby databases. So, you can now use the in-memory column keep on an Oracle Lively Data Guard standby database.
You can now generate PL/SQL courses so which the intention is self-apparent without the need of remarks. You can even change PL/SQL applications to reflect adjusted specifications by making improvements at considerably much less sites.
In former releases, the Oracle Details Guard broker lacked a ConfigurationWideServiceName configuration home shared by all users. Particularly, there was no ensure that you may use one connect identifier to image source connect with special info any databases within the configuration mainly because each database had its individual services running, which might or might not have experienced the identical service name.