What’s New for Oracle Autonomous Database on Shared Exadata Infrastructure
Here’s a summary of the noteworthy Oracle Autonomous Database additions and enhancements.
January 2021
Feature | Description |
---|---|
Private Endpoint Support for Tools (Oracle Machine Learning Notebooks are supported with Private Endpoints) |
You can access Oracle Application Express, Oracle SQL Developer Web, Oracle REST Data Services, and Oracle Machine Learning Notebooks with Private Endpoints. See Configuring Network Access with Private Endpoints for more information. |
2020 What's New
December 2020
Feature | Description |
---|---|
Replicate Data and Capture Data with Oracle GoldenGate |
Using Oracle GoldenGate you can capture changes from an Oracle Autonomous Database and replicate to any target database or platform that Oracle GoldenGate supports, including another Oracle Autonomous Database. See Oracle GoldenGate Capture for Oracle Autonomous Database for more information. |
Oracle APEX Application Development |
Oracle APEX Application Development (APEX Service) is a low cost Oracle Cloud service offering convenient access to the Oracle Application Express platform for rapidly building and deploying low-code applications. See Oracle APEX Application Development for more information. |
Oracle Database 21c with Always Free Autonomous Database |
Oracle Database 21c is available with Always Free Autonomous Database. See the following for more information: |
Oracle APEX 20.2 |
Autonomous Database uses Oracle Application Express 20.2. See Creating Applications with Oracle Application Express in Autonomous Database for more information. |
November 2020
Feature | Description |
---|---|
Amazon S3 Presigned URLs |
You can use a presigned URL in any
See Amazon S3 Compatible URI Format for more information. |
Azure Blob Storage Shared Access Signatures (SAS) URLs |
You can use Shared Access Signatures (SAS) URL in any
See Azure Blob Storage URI Format for more information. |
October 2020
Feature | Description |
---|---|
User-Defined Profiles Minimum Password Length |
If you create a user-defined profile with a Password Verification Function (PVF), then the minimum password length can be 8 characters. See Manage Password Complexity on Autonomous Database for more information. |
PL/SQL SDK for Oracle Cloud Infrastructure Resources |
PL/SQL SDK for Oracle Cloud Infrastructure enables you to write code to manage Oracle Cloud Infrastructure resources. The PL/SQL SDK is on all Autonomous Databases using shared Exadata infrastructure. See PL/SQL SDK for more information. |
Documentation Addition: Oracle Database Actions User Management |
You can quickly create users and modify account settings for users with Oracle Database Actions. See Create Users on Autonomous Database for more information. |
Autonomous Database Events |
Autonomous Database generates events that you can subscribe to with Oracle Cloud Infrastructure Events. Subscribing to Autonomous Database events allows you to create automation and to receive notifications when the events occur. See Use Autonomous Database Events for more information. |
September 2020
Feature | Description |
---|---|
Private Endpoint Support for Tools |
You can access Oracle Application Express, Oracle SQL Developer Web, and Oracle REST Data Services with Private Endpoints. See Configuring Network Access with Private Endpoints for more information. |
Read-Only and Restricted Modes |
You can select an Autonomous Database operation mode. The default mode is Read/Write. If you select Read-Only mode users can only run queries. In addition, for either mode you can restrict access to only allow privileged users to connect to the database. See Change Autonomous Database Mode to Read/Write or Read-Only for more information. |
Refreshable Clones |
Autonomous Database provides cloning where you can choose to create a full clone of the active instance, create a metadata clone, or create a refreshable clone. With a refreshable clone the system creates a clone that can be easily updated with changes from the source database. See Using Refreshable Clones with Autonomous Database for more information. |
Documentation Addition: Auditing Autonomous Database |
This new chapter describes the auditing features that allow you to track, monitor, and record activity on your database. Auditing can help you detect security risks and improve regulatory compliance for your database. See Auditing Autonomous Database for more information. |
August 2020
Feature | Description |
---|---|
Autonomous JSON Database |
If your database version is Oracle Database 19c or higher, you can provision an Autonomous JSON Database. Autonomous JSON Database is an Oracle Cloud service that is specialized for developing NoSQL-style applications that use JavaScript Object Notation (JSON) documents. See About Autonomous JSON Database for more information. |
Amazon S3-Compatible Object Stores |
Autonomous Database supports Amazon S3-Compatible object stores, such as Oracle Cloud Infrastructure Object Storage, Google Cloud Storage, and Wasabi Hot Cloud Storage. See Load Data from Files in the Cloud for more information. |
Asynchronous Requests using
|
The See SEND_REQUEST Function for more information. |
Rename Database |
If your database version is Oracle Database 19c or higher, you can rename your Autonomous Database. See Rename Autonomous Database for more information. |
July 2020
Feature | Description |
---|---|
Oracle Application Express Release 20.1 |
Autonomous Database supports Oracle Application Express Release 20.1. See Creating Applications with Oracle Application Express in Autonomous Database for more information. If your Autonomous Database instance is on Oracle Database 18c, to use APEX 20.1 you must upgrade to Oracle Database 19c. After you upgrade to Oracle Database 19c, APEX is automatically upgraded to APEX 20.1. |
Use a Standby Database |
Autonomous Database provides the Autonomous Data Guard feature to enable a standby (peer) database to provide data protection and disaster recovery for your Autonomous Database instance. See Using a Standby Database with Autonomous Database for more information. |
Create and Alter User Profiles |
You can create and alter database user profiles. See Manage User Profiles with Autonomous Database for more information. |
Manage Time Zone File Versions |
The time zone files are periodically updated to reflect the latest time zone specific changes. Autonomous Database automatically picks up the updated time zone files. See Manage Time Zone File Version on Autonomous Database for more information. |
Network Access Changes |
If your Autonomous Database network access is configured to use a private endpoint you can change the configuration to use a public endpoint. Likewise, if your Autonomous Database instance is configured to use a public endpoint, you can change the configuration to use a private endpoint. Autonomous Database network access changes from a public to a private endpoint, or from a private to a public endpoint are only supported with database versions Oracle Database 19c onwards. See Configuring Network Access with Access Control Rules (ACLs) and Private Endpoints for more information. |
Use Database Links to Access Non-Oracle Databases |
You can create database links from an Autonomous Database to an Oracle Database Gateway to access Non-Oracle databases. See Create Database Links to an Oracle Database Gateway to Access Non-Oracle Databases for more information. |
June 2020
Feature | Description |
---|---|
ORC Format and Complex Types |
Autonomous Database supports loading and querying data in object store in ORC format, in addition to Avro and Parquet. Also, for ORC, Avro, and Parquet structured file types you can load and query complex data types. Support for ORC format and complex types requires Oracle Database 19c. See Load Data from Files in the Cloud and Query External Data with ORC, Parquet, or Avro Source Files for more information. |
|
The See PUT_OBJECT Procedure for more information. |
Customer Managed Oracle REST Data Services |
You can use a customer managed environment to run Oracle REST Data Services (ORDS) if you want to control the configuration and management of ORDS. Installing and configuring a customer managed environment for ORDS allows you to run ORDS with configuration options that are not possible using the default Oracle managed ORDS available with Autonomous Database. See About Customer Managed Oracle REST Data Services on Autonomous Database for more information. |
May 2020
Feature | Description |
---|---|
Move Selective Data to Object Store |
You can export data to Oracle Data Pump dump files on Object Store by specifying a query to select the data to export. See Move Selective
Data to Object Store Using |
Obtain Tenancy Details for a Service Request |
When you file a service request for Autonomous Database, you need to provide the tenancy details for your instance. Tenancy details for the instance are available on the Oracle Cloud Infrastructure console or you can obtain these details by querying the database. See Obtain Tenancy Details to File a Service Request for more information. |
Upgrade Autonomous Database to Oracle Database 19c |
If your Autonomous Database instance is on Oracle Database 18c, you can upgrade to Oracle Database 19c by clicking Upgrade to 19c. |
April 2020
Feature | Description |
---|---|
SODA Documents and Collections |
Autonomous Database supports loading and using Simple Oracle Document Architecture (SODA) documents and collections. SODA allows you to store, search, and retrieve document collections, typically JSON documents, without using SQL. You can also access document collections with SQL/JSON operators, providing you with the simplicity of a document database but with the power of a relational database. See Using JSON Documents with Autonomous Database for more information. |
Load Data with Oracle Data Pump Access Driver Dump Files |
You can use Oracle Data Pump dump files in the Cloud
as source files to load your data. The files for this load type
must be exported from the source system using the
See Create Credentials and Load Data Pump Dump Files into an Existing Table for more information. |
Create External Tables and Query Data with Oracle Data Pump Access Driver Dump Files |
You can query Oracle Data Pump dump files in the Cloud by
creating an external table. The source files to create this type
of external table must be exported from the source system using
the See Query External Data Pump Dump Files for more information. |
Oracle Extensions for IDEs |
You can use Oracle extensions for IDEs to develop applications on Autonomous Database. Extensions are available for Eclipse, Microsoft Visual Studio, and Microsoft Visual Studio Code (VS Code). These extensions enable you to connect to, browse, and manage Autonomous Databases in Oracle Cloud directly from the IDE. See Use Oracle Extensions for IDEs to Develop Applications for more information. |
Per-Second Billing |
Autonomous Database instance CPU and storage usage is billed by the second, with a minimum usage period of 1 minute. Previously Autonomous Database billed in one-hour minimum increments and partial usage of an hour was rounded up to a full hour. |
Stateful Rule Support in Private Endpoints |
When you configure a private endpoint you define a security rule(s) in a Network Security Group (NSG); this creates a virtual firewall for your Autonomous Database and allows connections to the Autonomous Database instance. The NSG can now be configured with stateful rules. See Configure Private Endpoints with Autonomous Database for more information. |
Wallet zip File Contains |
The wallet file that contains client credentials
(wallet files) for your Autonomous Database instance now also has a
See Download Client Credentials (Wallets) for more information. |
March 2020
Feature | Description |
---|---|
Restart Autonomous Database instance |
Use Restart to restart an Autonomous Database instance. See Restart Autonomous Database for more information. |
Oracle Data Pump Direct Export to Object Store |
Depending on your cloud object store, you can use Oracle Data Pump to directly export to your object store to move data between Autonomous Database and other Oracle databases. See Move Data with Data Pump Export to Object Store for more information. |
Oracle Data Pump Pre-authenticated URLs for Dump Files |
If your source files reside on Oracle Cloud Infrastructure Object Storage, you can use pre-authenticated URLs with Oracle Data Pump. See Import Data Using Oracle Data Pump on Autonomous Database for more information. |
Documentation Addition: Upgrade Autonomous Database to Oracle Database 19c |
Provides information on upgrading to Oracle Database 19c if your Autonomous Database instance is on Oracle Database 18c. |
Oracle Database Versions by Region |
Depending on the region where you provision or clone your database, Autonomous Database supports one or more Oracle Database versions. Oracle Database 19c is available in all commercial regions. |
Oracle Application Express Release 19.2 |
Autonomous Database supports Oracle Application Express Release 19.2. See Creating Applications with Oracle Application Express in Autonomous Database for more information. |
February 2020
Feature | Description |
---|---|
Private Endpoints |
This configuration option assigns a private endpoint, private IP and hostname, to a database and allows traffic only from the VCN you specify; access to the database from all public IPs or VCNs is blocked. This allows you to define security rules at the Network Security Group (NSG) level and to control traffic to your Autonomous Database. See About Network Access Options for more information. |
Oracle Database Vault |
Oracle Database Vault implements powerful security controls for your database. These unique security controls restrict access to application data by privileged database users, reducing the risk of insider and outside threats and addressing common compliance requirements. See Using Oracle Database Vault with Autonomous Database for more information. |
Oracle Application Express Release 19.2 |
If your database instance is an Always Free Autonomous Database or is a database with Oracle Database release 19c, then your database has Oracle Application Express Release 19.2. See Creating Applications with Oracle Application Express in Autonomous Database for more information. |
Database Resident Connection Pool (DRCP) |
Using DRCP provides you with access to a connection pool in your database that enables a significant reduction in key database resources required to support many client connections. See Use Database Resident Connection Pooling with Autonomous Database for more information. |
January 2020
Feature | Description |
---|---|
Clone from a backup |
Clone from a backup lets you create a clone by selecting a backup from a list of backups, or with a timestamp for a point-in-time to clone. See Clone Autonomous Database from a Backup for more information. |
Check and set MAX_STRING_SIZE
value
|
By default the database uses extended data types and
the value of See Checking and Setting MAX_STRING_SIZE for more information. |
Number of concurrent statements increased depending on the service you use |
The maximum number of concurrent statements is increased, depending on the connection service you are using. See Predefined Database Service Names for Autonomous Database for more information. |
Documentation addition showing available Oracle Database versions |
The documentation shows the Oracle Database version available with Autonomous Database by region. See Oracle Database Version Availability by Region for more information. |
DBMS_CLOUD REST API functions
|
The See DBMS_CLOUD REST APIs for more information. |
Documentation addition to describe sending mail with
UTL_SMTP |
The documentation is updated to provide the steps and
sample code for sending email using
See Sending Mail with Email Delivery on Autonomous Database for more information. |
Use ACLs to control access for Autonomous Database tools |
You can now use Virtual Cloud Network, Virtual Cloud Network (OCID), IP address, or CIDR block ACLs to control access to Oracle Application Express (APEX), RESTful services, and SQL Developer Web. See Use an Access Control List with Autonomous Database for more information. |
2019 What's New
December 2019
Feature | Description |
---|---|
Support for UTL_HTTP and
UTL_SMTP PL/SQL Packages with
restrictions
|
Autonomous Database supports the Oracle Database PL/SQL packages
See Restrictions for Database PL/SQL Packages for more information. |
Microsoft Active Directory Users |
You can configure Autonomous Database to authenticate and authorize Microsoft Active Directory users. This allows Active Directory users to access a database using their Active Directory credentials. See Use Microsoft Active Directory with Autonomous Database for more information. |
Validate external partitioned tables and hybrid partitioned tables |
You can validate individual partitions of an
external partitioned table or a hybrid partitioned table with
the procedures See Validate External Partitioned Data and Validate Hybrid Partitioned Data for more information. |
Use ACL IP address or CIDR block settings to control access for Autonomous Database tools |
You can now use IP address and CIDR based ACLs to control access to Oracle Application Express (APEX), RESTful services, and SQL Developer Web. See Use an Access Control List with Autonomous Database for more information. |
Use Oracle Data Safe |
Oracle Data Safe provides features that help you protect sensitive and regulated data in your database. See Safeguard Your Data with Data Safe on Autonomous Database for more information. |
November 2019
Feature | Description |
---|---|
Use ACLs to specify Oracle Cloud Infrastructure VCNs |
Use ACLs to specify Oracle Cloud Infrastructure VCNs that can connect to your Autonomous Database. |
SQL Developer Web Data Loading |
In SQL Developer Web in the Worksheet page, you can upload data from local files into an existing table. |
Access APEX from Oracle Cloud Infrastructure Console |
The Tools Tab provides access to APEX from Oracle Cloud Infrastructure Console. See Access Oracle Application Express Administration Services for more information. |
Access SQL Developer Web from Oracle Cloud Infrastructure Console | The Tools Tab provides access to SQL Developer Web
from Oracle Cloud
Infrastructure Console.
See Access SQL Developer Web as ADMIN for more information. |
Access Oracle Machine Learning from Oracle Cloud Infrastructure Console | The Tools Tab provides access to Oracle Machine Learning User Administration from Oracle Cloud Infrastructure Console. |
View Maintenance Schedule from Oracle Cloud Infrastructure Console | The Autonomous Database Information tab shows the schedule for upcoming
maintenance.
See About Autonomous Database Maintenance Windows for more information. |
New fields with LIST_FILES and
LIST_OBJECTS |
The functions DBMS_CLOUD.LIST_FILES and DBMS_CLOUD.LIST_OBJECTS
produce additional metadata for files and objects.
See LIST_FILES Function and LIST_OBJECTS Function for more information. |
October 2019
Feature | Description |
---|---|
Preview Version for Autonomous Database |
Oracle periodically provides a preview version of Autonomous Database that allows you to test your applications and to become familiar with features in the next release of Autonomous Database. See Preview Versions for Autonomous Database for more information. |
Download database specific instance wallets or regional wallets |
You can download database specific instance wallets or regional wallets. See Download Client Credentials (Wallets) for more information. |
Rotate database specific instance wallets or regional wallets |
You can rotate database specific instance wallets or regional wallets. See Rotate Wallets for Autonomous Database for more information. |
Create partitioned external tables with DBMS_CLOUD
|
You can create and validate external partitioned
tables with the See Query External Partitioned Data for more information. |
Numeric Formats |
With the See DBMS_CLOUD Package Format Options for more information. |
September 2019
Feature | Description |
---|---|
Always Free Autonomous Database |
You have the option to create a limited number of Always Free Autonomous Databases that do not consume cloud credits. Always Free databases can be created in Oracle Cloud Infrastructure accounts that are in a trial period, have paying status, or are always free. See Always Free Autonomous Database for more information. |
Autonomous Database Metrics |
You can monitor the health, capacity, and performance of your databases with metrics, alarms, and, notifications. You can use Oracle Cloud Infrastructure console or Monitoring APIs to view metrics. See Monitor Performance with Autonomous Database Metrics for more information. |
Object Store Using Public URL |
If your source files reside on an Object Store that
provides public URLs, you can use public URLs with
See URI Format Using Public URL for more information. |
Work Requests |
Work Requests are available in the Oracle Cloud Infrastructure console. Work Requests let you track progress of database lifecycle management operations such as creating, terminating, backing up (manual), restoring, scaling, and cloning an Autonomous Database. Work requests allow you to track the progress and steps completed in a database operation. See About Work Requests for more information. |
August 2019
Feature | Description |
---|---|
Create Directory and Drop Directory commands |
The See Creating and Managing Directories for more information. |
July 2019
Feature | Description |
---|---|
Performance Hub |
Oracle Cloud Infrastructure console includes Performance Hub for Autonomous Database. You can view real-time and historical performance data from the Performance Hub. See Monitor Autonomous Database with Performance Hub for more information. |
Oracle Cloud Infrastructure Native Object Store Authentication |
Autonomous Database supports native authentication with Oracle Cloud Infrastructure Object Store. Using native authentication you can use key based authentication to access the Object Store (instead of using a username and password). See CREATE_CREDENTIAL Procedure for more information. |
Move to a different Compartment |
You can move a database to a different Oracle Cloud Infrastructure compartment. See Move an Autonomous Database to a Different Compartment for more information. |
June 2019
Feature | Description |
---|---|
Application Express (APEX) |
Oracle Application Express (APEX) is a low-code development platform that enables you to build scalable, secure enterprise applications with world-class features that can be deployed anywhere. Each Autonomous Database instance includes a dedicated instance of Oracle Application Express; you can use this instance to create multiple workspaces. A workspace is a shared work area where you can build applications. See About Oracle Application Express for more information. |
SQL Developer Web |
Oracle SQL Developer Web provides a provides a development environment and a data modeler interface for Autonomous Database. See About SQL Developer Web for more information. |
Oracle REST Data Services (ORDS) |
You can develop and deploy RESTful Services with native Oracle REST Data Services (ORDS) support on a database See Developing RESTful Services in Autonomous Database for more information. |
Auto Scaling |
Enabling auto scaling allows a database to use up to three times more CPU and IO resources than the currently specified CPU Core Count. 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. |
Azure object store with Data Pump |
Autonomous Database now supports Microsoft Azure cloud storage with Oracle Data Pump. See Import Data Using Oracle Data Pump on Autonomous Database for more information. |
May 2019
Feature | Description |
---|---|
Support for creating database links |
You can create database links with See Use Database Links with Autonomous Database for more information. |
Oracle Spatial and Graph with limitations |
See Restrictions for Oracle Spatial and Graph for more information. |
Oracle Text with limitations |
See Restrictions for Oracle Text for more information. |
Oracle Cloud Infrastructure Native URI Format Supported with Oracle Data Pump |
For importing data from Data Pump files using
See DBMS_CLOUD Package File URI Formats for more information. |
Oracle Cloud Infrastructure Pre-Authenticated URI
Format Supported with DBMS_CLOUD |
If your source files reside on the Oracle Cloud Infrastructure
Object Storage you can use the Oracle Cloud Infrastructure
Pre-Authenticated URIs. When you create a pre-authenticated
request, a unique URL is generated. You can use a
pre-authenticated URL in any See DBMS_CLOUD Package File URI Formats for more information. |
Oracle XML DB with limitations |
Oracle XML DB is a high-performance, native XML storage and retrieval technology that is delivered as a part of Oracle Database. Limitations apply to Oracle XML DB with Autonomous Database database. See Restrictions for Oracle XML DB for more information. |
Oracle Management Cloud support |
Oracle Management Cloud allows you to monitor your Autonomous Database database availability and performance. See Using Oracle Database Management for Autonomous Databases for more information. |
Modify CPU/IO Shares from Service Console |
Autonomous Database comes with predefined CPU/IO shares assigned to different consumer groups. You can modify predefined CPU/IO shares if your workload requires different CPU/IO resource allocations.You can change CPU/IO shares from the Service Console or using a PL/SQL package. See Manage CPU/IO Shares on Autonomous Database for more information. |
April 2019
Feature | Description |
---|---|
Support for Network Access Control Lists |
Autonomous Database now supports setting a network Access Control List (ACL) to restrict access to a specific Autonomous Database database. When you set a network ACL the database only accepts connections from addresses specified on the ACL and rejects all other client connections. See Configuring Network Access with Access Control Rules (ACLs) for more information. |
Support for Updating License Type |
You can now update your license type from the Oracle Cloud Infrastructure console Actions list. See Update License Type on Autonomous Database for more information. |
Access Avro files in Object Stores |
Autonomous Database allows you to directly query and load data stored as Apache Avro format files (Apache Parquet format files are also supported). You can create external tables for Parquet or Avro format data files. See DBMS_CLOUD Package Format Options for Parquet and Avro and CREATE_EXTERNAL_TABLE Procedure for Parquet or Avro Files for more information. |
Enhanced newline handling for file record delimiter
with |
Now, when reading a file, by default
See DBMS_CLOUD Package Format Options for more information. |
Modify CPU/IO Shares |
Autonomous Database comes with predefined CPU/IO shares assigned to different consumer groups. You can modify these predefined CPU/IO shares if your workload requires different CPU/IO resource allocations. See Manage CPU/IO Shares on Autonomous Database for more information. |
March 2019
Feature | Description |
---|---|
Clone Your Database |
Autonomous Database provides cloning where you can choose to clone either the full database or only the database metadata. See Cloning a Database with Autonomous Database for more information. |
Oracle Cloud
Infrastructure Native URI Format Supported with
DBMS_CLOUD |
If your source files reside on the Oracle Cloud Infrastructure Object
Storage you can use the Oracle Cloud
Infrastructure native URIs in addition to the Swift URIs.
See DBMS_CLOUD Package File URI Formats for more information. |
UI/API Unification and Workload Type field |
Oracle Cloud Infrastructure Console and the Oracle Cloud Infrastructure APIs for Autonomous Data Warehouse and Autonomous Transaction Processing are converged to a single, unified framework. These changes allow you to more easily manage both types of Autonomous Databases. There is 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. See Workload Types for more information. |
Service Gateway |
You can now set up a Service Gateway with Autonomous Database. A service gateway allows connectivity to Autonomous Database from private IP addresses in private subnets without requiring an Internet Gateway in your VCN. See Access Autonomous Database with Service Gateway and Access to Oracle Services: Service Gateway for more information. |
Documentation changes |
The procedure See DELETE_ALL_OPERATIONS Procedure for more information. |
February 2019
Feature | Description |
---|---|
Application Continuity |
You can now enable and disable Application Continuity. 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. See Enabling and Disabling Application Continuity for more information. |
Documentation changes |
Autonomous Database documentation includes a new chapter that describes moving data to other Oracle databases. See Moving Data from Autonomous Database to Other Oracle Databases for more information. |
January 2019
Feature | Description |
---|---|
Access Parquet files in Object Stores |
Autonomous Database allows you to directly query and load data stored as parquet files in object stores. You can also create external parquet format tables in object stores. See COPY_DATA Procedure for Parquet Files and CREATE_EXTERNAL_TABLE Procedure for Parquet Files for more information. |
2018 What's New
October 2018
Feature | Description |
---|---|
Oracle Cloud Infrastructure Console changes |
The Autonomous Database console has a new layout and provides new buttons that improve the usability of Autonomous Database. These changes include a new DB Connection button that makes it easier to download client credentials. |
September 2018
Feature | Description |
---|---|
Table compression methods |
In addition to Hybrid Columnar Compression all table compression types are now available in Autonomous Database. For more information, see Managing DML Performance and Compression. |
Partitioned tables, indexes, and materialized views |
Autonomous Database now allows users to create partitioned tables, indexes, and materialized views. For more information, see Managing Partitions, Indexes, and Materialized Views. |
Idle timeout changes |
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 Manage Concurrency and Priorities on Autonomous Database. |
August 2018
Feature | Description |
---|---|
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 Database. |
July 2018
Feature | Description |
---|---|
SQL Developer 18.2.0 and later without Keystore Password field for connections |
When you connect to Autonomous Database with SQL Developer 18.2.0 or later, you do not need to supply a keystore password. The keystore pasword was required in previous SQL Developer versions. |
June 2018
Feature | Description |
---|---|
New management interfaces |
Autonomous Database is now provisioned and managed using the native Oracle Cloud Infrastructure. This provides a more intuitive user interface to make managing your Autonomous Database instances easier with additional capabilities including sorting and filtering. For more information, see Oracle Help Center. |
Better authorization management |
With OCI Identity and Access Management (IAM) you can better organize and isolate your Autonomous Database instances using Compartments and control what type of access a user or group of users have. |
Built-in auditing |
The OCI Audit service records use of Autonomous Database application programming interface (API) endpoints as log events in JSON format. You can view, copy, and analyze audit events with standard log analysis tools or using the Audit service Console, the Audit APIs, or the Java SDK. |
Availability of the Phoenix region |
Autonomous Database is now available in the Phoenix region in addition to Ashburn and Frankfurt regions. |
User Assistance changes |
The documentation, videos, and examples are updated on the Oracle Help Center to include the procedures to create and control Autonomous Database instances with the Oracle Cloud Infrastructure Console. A new Related Resources page shows related resources including the Autonomous Data Warehouse Forum . |
Idle timeouts in database services |
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 Manage Concurrency and Priorities on Autonomous Database. |
May 2018
Feature | Description |
---|---|
Oracle Cloud Infrastructure Object Storage Credentials |
The name Swift Password is now Auth token. Use of Swift password in the documentation is now replaced with Auth token. |
April 2018
Feature | Description |
---|---|
Microsoft Azure Blob Storage integration |
Autonomous Database now supports Microsoft Azure Blob Storage for data loading and querying external data. You can load data from or run queries on files residing on Azure Blob Storage. See Loading Data from Files in the Cloud. |
Manage files on the local file system |
You can now list files residing on the local file system on Autonomous Database, see LIST_FILES Function. You can also remove files from the local file system. See DELETE_FILE Procedure. |
Documentation Accessibility
For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.
Access to Oracle Support
Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.
Oracle Cloud What's New for Oracle Autonomous Database on Shared Exadata Infrastructure
F38081-01
January 2021
Copyright © 2020, 2021, Oracle and/or its affiliates.
This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.
The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.
If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:
U.S. GOVERNMENT END USERS: Oracle programs (including any operating system, integrated software, any programs embedded, installed or activated on delivered hardware, and modifications of such programs) and Oracle computer documentation or other Oracle data delivered to or accessed by U.S. Government end users are "commercial computer software" or "commercial computer software documentation" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, reproduction, duplication, release, display, disclosure, modification, preparation of derivative works, and/or adaptation of i) Oracle programs (including any operating system, integrated software, any programs embedded, installed or activated on delivered hardware, and modifications of such programs), ii) Oracle computer documentation and/or iii) other Oracle data, is subject to the rights and limitations specified in the license contained in the applicable contract. The terms governing the U.S. Government’s use of Oracle cloud services are defined by the applicable contract for such services. No other rights are granted to the U.S. Government.
This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.
Intel and Intel Inside are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Epyc, and the AMD logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.
This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.