Your search did not match any results.
We suggest you try the following to help find what you’re looking for:
Oracle Autonomous Database is Oracle's new, fully managed database tuned and optimized for both data warehouse and transaction processing workloads with the market-leading performance of Oracle Database. It delivers a completely new, comprehensive cloud experience for data warehousing and transaction processing workloads that is easy, fast, and elastic.
This page lists the new features and updates added to Autonomous Database.
Last Updated September 2021.
To watch previous recordings of our new feature webcasts, head over to our OTube channel!
(Shared Infrastructure Only)
Two specific improvements relating to how Data Pump dump files can be used with ADB:
Autonomous Data Warehouse is now available in the Sydney data center.
Autonomous Data Warehouse is now available in the Zurich data center.
Customers can now get a real-time and historical view of performance data directly on the OCI console using Performance Hub. This new page contains the following:
These features provides a simple one-click way to access the same information as found in EM Express, Oracle Management Cloud (OMC), and SQL Developer Web. The most likely target audience for this new feature will be cloud DBAs who manage a range of ADB instances within a single tenant and need a simple and fast way to monitor the performance of individual ADB instances directly from within the OCI Console.
You can select auto scaling during provisioning or later using the Scale Up/Down button on the Oracle Cloud Infrastructure console.
When you select auto scaling Autonomous Database can use up to three times more CPU and IO resources than specified by the number of OCPUs currently shown in the Scale Up/Down dialog. When auto scaling is enabled, if your workload requires additional CPU and IO resources the database automatically uses the resources without any manual intervention required.
Autonomous Database is now available in the Tokyo data center.
you can now quickly and easily change the licensing for your Autonomous Database from BYOL to a new cloud subscription or vice-versa.
Oracle Cloud Infrastructure Console and the Oracle Cloud Infrastructure APIs for Autonomous Data Warehouse and Autonomous Transaction Processing have converged to a single, unified framework. These changes allow you to more easily manage both types of Autonomous Databases.
There is a new a new Workload Type field on the console showing values of either “Transaction Processing” or “Data Warehouse”, depending on the type of database you are viewing. You can also select a Workload Type when you provision an Autonomous Database.
Application Continuity masks outages from end users and applications by recovering the in-flight work for impacted database sessions following outages.
Application Continuity performs this recovery beneath the application so that the outage appears to the application as a slightly delayed execution.
It is used to improve the user experience when handling both unplanned outages and planned maintenance. Application Continuity enhances the fault tolerance of systems and applications that use an Oracle database.
Autonomous Data Warehouse is now available in the Toronto data center.
Autonomous Data Warehouse is now available in the London region.
The documentation page for Autonomous Data Warehouse, Getting Started now includes new role-based topic links:
The idle timeout of 60 minutes is now lifted. Idle sessions that do not hold resources required by other sessions will not be terminated after 60 minutes now.
For more information, see the section headed "Managing Concurrency and Priorities on Autonomous Data Warehouse" in the documentation guide.
The Oracle Cloud Infrastructure page has a new option Autonomous Transaction Processing. The sign in for Oracle Cloud Infrastructure now lists the new product, Oracle Autonomous Transaction Processing, in addition to Oracle Autonomous Data Warehouse.
SQL Developer 18.2.0 and later now allows for setting up connections without the need for keystore passwords.
The documentation, videos, and examples are updated on the Oracle Help Center to include the procedures to create and control Autonomous Data Warehouse instances with the Oracle Cloud Infrastructure Console.
new Related Resources page shows related resources including the Autonomous Data Warehouse Forum.
The idle timeouts for three database services, high, medium, and low, have now been relaxed. The previous idle timeout setting of 5 minutes will now apply to only idle sessions that hold resources needed by other active users. See Managing Concurrency and Priorities on Autonomous Data Warehouse.
The term "Swift Password" has been replaced with the term "Auth token" in the documentation and UI.
You can now list files residing on the local file system on Autonomous Data Warehouse, see LIST_FILES Function.
You can also remove files from the local file system. See DELETE_FILE Procedure.