What’s New for Autonomous Transaction Processing on Shared Exadata Infrastructure

Here’s a summary of the noteworthy Oracle Autonomous Transaction Processing on shared Exadata infrastructure additions and enhancements over the past several months.

October 2020

Feature Description

Use Autonomous Database Events

Autonomous Database generates events that you can subscribe to with Oracle Cloud Infrastructure Events.

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 SEND_REQUEST

The DBMS_CLOUD SEND_REQUEST function supports long running requests with the additional parameters: async_request_url, wait_for_states, and timeout.

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 Transaction Processing 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.

See Upgrade an Autonomous Database Instance to Oracle Database 19c for more information.

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.

PUT_OBJECT Maximum File Transfer Size Increase

The DBMS_CLOUD.PUT_OBJECT procedure maximum size limit for file transfers to Oracle Cloud Infrastructure Object Storage is increased to 50 GB.

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 DBMS_CLOUD.EXPORT_DATA for more information.

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.

See Upgrade an Autonomous Database Instance to Oracle Database 19c for more information.

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 ORACLE_DATAPUMP access driver in External Tables.

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 ORACLE_DATAPUMP access driver in External Tables.

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 README File

The wallet file that contains client credentials (wallet files) for your Autonomous Database instance now also has a README file with wallet expiration information. Wallet files that were downloaded prior to April 2020 do not contain this file.

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 Transaction Processing 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 Data Warehouse 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.

See Upgrade an Autonomous Database Instance to Oracle Database 19c for more information.

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 an Autonomous Transaction Processing 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 Data Warehouse database.

See About Network Access Options for more information.

Oracle Database Vault

Oracle Database Vault implements powerful security controls for your Autonomous Transaction Processing 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 an Autonomous Transaction Processing 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 Autonomous Transaction Processing 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 Data Warehouse from a Backup for more information.

Check and set MAX_STRING_SIZE value

By default the Autonomous Transaction Processing database uses extended data types and the value of MAX_STRING_SIZE is set to the value EXTENDED. To support migration from older Oracle Databases or applications you can set MAX_STRING_SIZE to the value STANDARD.

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 Data Warehouse 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 DBMS_CLOUD REST API functions allow you to make HTTP requests using DBMS_CLOUD.SEND_REQUEST. These functions provide a generic API that lets you call REST APIs from supported cloud services.

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 UTL_SMTP.

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 UTL_HTTP, UTL_SMTP, and DBMS_NETWORK_ACL_ADMIN with restrictions.

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 an Autonomous Transaction Processing 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 DBMS_CLOUD.VALIDATE_EXTERNAL_PART_TABLE and DBMS_CLOUD.VALIDATE_HYBRID_PART_TABLE.

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 Autonomous Transaction Processing 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.

See Use an Access Control List with Autonomous Database for more information.

SQL Developer Web Data Loading

In SQL Developer Web in the Worksheet page, you can upload data from local files into an existing table.

See Load Data from Local Files with SQL Developer Web for more information.

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.

See Work with Oracle Machine Learning for Data Access, Analysis, and Discovery for more information.

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 DBMS_CLOUD.CREATE_EXTERNAL_PART_TABLE and DBMS_CLOUD.VALIDATE_EXTERNAL_TABLE statements.

See Query External Partitioned Data for more information.

Numeric Formats

With the numberformat and numericcharacters format options Autonomous Database supports formats to interpret numeric strings correctly.

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 Autonomous Data Warehouse 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 DBMS_CLOUD procedures. Public means the Object Storage service supports anonymous, unauthenticated access to the Object Store files.

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 data_pump_dir directory is available in an Autonomous Transaction Processing database. You can use CREATE DIRECTORY to create additional directories. To drop a directory, you can use the DROP DIRECTORY command.

See Creating and Managing Directories for more information.

July 2019

Feature Description
Performance Hub

Oracle Cloud Infrastructure console includes Performance Hub for Autonomous Transaction Processing. You can view real-time and historical performance data from the Performance Hub.

See Monitor Autonomous Transaction Processing with Performance Hub for more information.

Oracle Cloud Infrastructure Native Object Store Authentication

Autonomous Transaction Processing 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 an Autonomous Transaction Processing database to a different Oracle Cloud Infrastructure compartment.

See Move an Autonomous Transaction Processing 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 Transaction Processing 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 Transaction Processing.

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 an Autonomous Transaction Processing database

See Developing RESTful Services in Autonomous Database for more information.

Auto Scaling

Enabling auto scaling allows an Autonomous Transaction Processing 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.

See Use Auto Scaling for more information.

Azure object store with Data Pump

Autonomous Transaction Processing now supports Microsoft Azure cloud storage with Oracle Data Pump.

See Import Data Using Oracle Data Pump on Autonomous Transaction Processing for more information.

May 2019

Feature Description

Support for creating database links

You can create database links with DBMS_CLOUD_ADMIN.CREATE_DATABASE_LINK to access objects on another database.

See Using Database Links with Autonomous Transaction Processing 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 impdp, 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.

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 DBMS_CLOUD procedure that takes a URL to access files in the Oracle Cloud Infrastructure object store, without the need to create a credential.

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 Transaction Processing database.

See Restrictions for Oracle XML DB for more information.

Oracle Management Cloud support

Oracle Management Cloud allows you to monitor your Autonomous Transaction Processing database availability and performance.

See Using Oracle Database Management for Autonomous Databases for more information.

Modify CPU/IO Shares from Service Console

Autonomous Transaction Processing 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 Transaction Processing for more information.

April 2019

Feature Description

Support for Network Access Control Lists

Autonomous Transaction Processing now supports setting a network Access Control List (ACL) to restrict access to a specific Autonomous Transaction Processing 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 Set Access Control List with Autonomous Transaction Processing 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 with Autonomous Transaction Processing for more information.

Access Avro files in Object Stores

Autonomous Transaction Processing 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 DBMS_CLOUD

Now, when reading a file, by default DBMS_CLOUD tries to automatically find the correct newline character to use as the record delimiter, either for Windows, newline character "\r\n", or for UNIX/Linux newline character "\n". If DBMS_CLOUD finds one of these it sets the record delimiter for the file. You can specify the record delimiter explicitly if you want to override the default behavior.

See DBMS_CLOUD Package Format Options for more information.

Modify CPU/IO Shares

Autonomous Transaction Processing 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 Transaction Processing for more information.

March 2019

Feature Description
Clone a Database

Autonomous Transaction Processing provides cloning where you can choose to clone either the full database or only the database metadata.

See Cloning a Database with Autonomous Transaction Processing 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 Transaction Processing and Autonomous Data Warehouse 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 Transaction Processing. A service gateway allows connectivity to Autonomous Transaction Processing from private IP addresses in private subnets without requiring an Internet Gateway in your VCN.

See Access Autonomous Data Warehouse with Service Gateway and Access to Oracle Services: Service Gateway for more information.

Documentation changes

The procedure DBMS_CLOUD.DELETE_ALL_OPERATIONS is now documented.

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 Transaction Processing documentation includes a new chapter that describes moving data to other Oracle databases. See Moving Data from Autonomous Transaction Processing to Other Oracle Databases for more information.

January 2019

Feature Description

Access Parquet files in Object Stores

Autonomous Transaction Processing 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

November 2018

Feature Description

New predefined database service names available

When connecting to an Autonomous Transaction Processing database, you can now use the newly added tpurgent and tp predefined database service names. For details, see Predefined Database Service Names for Autonomous Transaction Processing.

October 2018

Feature Description

Oracle Cloud Infrastructure Console changes

The Autonomous Transaction Processing console has a new layout and provides new buttons that improve the usability of Autonomous Transaction Processing. These changes include a new DB Connection button that makes it easier to download client credentials.

September 2018

Feature Description

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 Managing Priorities on Autonomous Transaction Processing.

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.