No results found

Your search did not match any results.

We suggest you try the following to help find what you're looking for:

  • Check the spelling of your keyword search.
  • Use synonyms for the keyword you typed, for example, try “application” instead of “software.”
  • Try one of the popular searches shown below.
  • Start a new search.

 

Trending Questions

What's New in Autonomous Database

What's New in Autonomous Database

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

November 2019

OCI Console - Shortcut to Built-in Tools (SQL Developer Web, APEX, OML Admin)

(Serverless only)

 

The UI for the Oracle Cloud Infrastructure Console has been updated with the addition of a new tools tab alongside the existing tabs for information and tags. The new Tools tab provides a simpler way for Cloud Admins to access and manage the built-in development tools such as SQL Developer Web, APEX and Oracle Machine Learning.

ADB Logo
 

SQL Developer Web - Data Loading

(Serverless only)

 

The ORDS tier portion of Oracle Autonomous Database (Serverless) has been updated to version 19.2.1.

This covers both the commercial and Always Free versions of both Data Warehouse and Transaction Processing shapes.

This had two significant impacts on the user interface for SQL Developer Web:

  • Easier sign-in process for users other than ‘admin’
  • Ability to load data from a file on your machine to a table


ADB Logo
 

October 2019

Database-Specific Wallet

 

On the Database Connection form, it is now possible to select type of wallet that will be generated:

  • Instance Wallet - provides a database-specific wallet with access to a single database only.
     
  • Regional Wallet - contains connection details for all ADBs within a given tenant-region.

Note that the instance (database-specific) wallet is the recommended option for applications where the connection is to only one system.

ADB Logo

External Partitioned Tables

(Serverless only)

 

This new feature, external partitioned table, creates the ability to query multiple data files in the Object Store as a single external table where the Object Store files can be represented as multiple logical partitions.

The key benefit of using external partitioning tables is improved query performance - when the external data is partitioned into separate slices/parts, query response time is faster when processing only a small part of the data instead of having to scan the entire data set.

Hybrid Partitioned Tables

(Serverless 19c Preview only)

 

Hybrid partitioned tables allows a query to access both internal data and multiple data files in the Object Store as single logical table.

Autonomous Database takes advantage of the partitioning information, ensuring that the query only accesses the relevant internal data and/or data files in the Object Store.

19c Preview

(Serverless only)

 

With 19c Preview version of Oracle Autonomous Database customers and partners will be able to test their applications, workloads, and 3rd party tools on upcoming features of Oracle Autonomous Database prior to general rollout of this new production version. Preview allows customers/partners to either create new ADB instances using Oracle Database 19c or to clone existing instances to the 19c Preview version.

Image of 19c Preview Collateral

More Data Loading Options For Numeric Formats

 

With the addition of numberformat and numericcharacters format options Autonomous Database now supports a wider range of formats for interpreting numeric strings during data loading operations. It is now possible to:

Specify the characters to use as the group separator and decimal character.

  • decimal_character: The decimal separates the integer portion of a number from the decimal portion.
  • group_separator: The group separator separates integer groups (that is, thousands, millions, billions, and so on).

Specify the number format model. A number format model is composed of one or more number format elements and is used in combination with numericcharacters.

Updated Schema Advisor Tool

 

The ADB Schema Advisor is a light-weight utility that analyzes on-premise or cloud Oracle Database schemas for the suitability of migration to Oracle Autonomous Database. The Advisor has been updated and is available for download via the Oracle Support website. This latest version includes support for ADW Dedicated, analyzing user defined objects placed in SYS/SYSTEM schemas and the ability to run multiple schemas from the command line.

September 2019

ADW Dedicated

 

Announcing the General Availability (GA) of dedicated deployment choice for Autonomous Data Warehouse.

As with Autonomous Transaction Processing, Autonomous Data Warehouse now offers both Serverless (ADW-S) and Dedicated (ADW-D) deployment choices.

Serverless is a simple and elastic deployment choice. Oracle autonomously operates all aspects of the database life cycle from database placement to backup and updates. Dedicated is a private cloud in public cloud deployment choice. A completely dedicated compute, storage, network and database service for only a single tenant. Dedicated deployment provides for the highest levels of security isolation and governance. The customer has customizable operational policies for Autonomous Operations for workload placement, workload optimization, update scheduling, availability level, over provisioning and peak usage.

ADB dedicated customers can now deploy a mix of ADW-D and ATP-D instances on the same Exadata Infrastructure rack.

Always Free Service

 

ADB now offers 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 accounts that are in a trial period, paying status, or are always free.

Data Safe for ADB

 

Data Safe is a unified control center for your Oracle Databases which helps you understand the sensitivity of your data, evaluate risks to data, mask sensitive data, implement and monitor security controls, assess user security, monitor user activity, and address data security compliance requirements. Data Safe with Oracle Autonomous Database delivers essential data security capabilities as a service on Oracle Cloud Infrastructure.

Integration with OCI Work Requests

 

Many Autonomous Database operations do not take effect immediately. For example, when you create a new instance, it might take a few minutes for the instance to transition from the provisioning state to running. When you launch some longer-running operations, ADB now generates an OCI work request. A work request is an activity log that enables you to track each step in the operation's progress.

If an operation fails, a work request can help you determine which step of the process had an error.

OCI Metrics for ADB

 

You can monitor the health, capacity, and performance of your Autonomous Databases with metrics, alarms and notifications. You can use Oracle Cloud Infrastructure console or Monitoring APIs to view specific metrics metrics.

Using Public URLs with DBMS_CLOUD

 

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. Check your specific cloud object storage service for details on how to make an object public in a supported object store.

Note:Carefully assess the business requirement and the security ramifications of using public URLs. When you use public URLs, due to the file content not being authenticated, make sure this is appropriate for your use.

You can use a public URL in any DBMS_CLOUD procedure that takes a URL to access files in your object store, without the need to create a credential. You need to either specify the credential_name parameter as NULL or not supply a credential_name parameter.

Availability of the Sao Paulo data center

 

Autonomous Data Warehouse is now available in the Sao Paulo data center.

Availability of the Sydney data center

 

Autonomous Data Warehouse is now available in the Sydney data center.

August 2019

Integration with OCI Events Services

 

The OCI Events Service now covers Autonomous Databases (Serverless and Dedicated). OCI Events lets you subscribe to changes in your cloud resources and respond to them by using OCI Notifications, OCI Streaming and Oracle Functions.

Autonomous Database instances generate events for the following resources;

  • Autonomous Database
  • Autonomous Container Database
  • Autonomous Exadata Infrastructure

and covers events such as start of backup, end of backup, create instance-start, create instance-end and maintenance reminders. The full list of supported event types is provided in the presentation listed below in the section headed "DEMO".

Support for Directory Objects

 

ADB now supports multiple directories which makes it even easier for customers to migrate their existing applications to ADB. For example this simplifies the migration process for customers who have existing ETL jobs that create and drop specific database directories that are used to hold temporary data pump files as part of a data loading workflow.

To create additional directories within an ADB instance cloud administrators and applications can use the standard CREATE DIRECTORY and DROP DIRECTORY commands. The DBMS_CLOUD.LIST_FILES procedure can be used to list the contents of a directory.

Availability of the Mumbai data center

 

Autonomous Data Warehouse is now available in the Mumbai data center.

Availability of the Zurich data center

 

Autonomous Data Warehouse is now available in the Zurich data center.

July 2019

OCI VCN Transit Routing to Oracle Cloud Services

 

On-premises instances/applications no longer need a public IP address, NAT or FastConnect public peering to access the business-critical Oracle services in the Oracle Services Network

This means that on-premise private workloads can initiate connections to Oracle services. Traffic to the Oracle Services is sent via FastConnect peering connection (or VPN Connect) to the DRG in the hub VCN. DRG will then direct the Oracle services traffic to the SGW in the same VCN.

Moving instances between compartments

 

A compartment is allocated when a new ADB instance is created. Previously it has not been possible to move the instance to another compartment. With the launch of this feature, it is now possible to move an Autonomous Database from one compartment to another without interrupting the service.

Resetting Resource Management Rules to the defaults

 

The service console has a UI utility called "Set Resource Management Rules" to specify run-away criteria (query run-time and amount of IO) and CPU/IO shares for each consumer group.

The resource management UI now has a simple button called "Load Default Values" next to the "Save Changes" button. When clicked, the values of the active tab (either 'CPU/IO shares' or 'Run-away criteria') will be reset to their default, out-of-the-box, values.

Native Object Store Authentication for DBMS_CLOUD

 

Now DBMS_CLOUD offers native authentication and uses native APIs as an alternative to the Swift API. The previous Swift authentication (auth tokens) will remain for backward compatibility, however, we recommend customers and partners switch to using the new native API-based approach.

Simplified Service Console UI

 

The ADB Service console used to have several administration-related and development-related operations stacked under the "Administration" tab. In order to provide a better separation between these roles, the UI has been updated with an additional tab called "Development":

ISO-27001, 27017 and 27018 certifications

 

The GRC team has announced that Autonomous Database (ADW and ATP) has achieved ISO/IEC 27001, ISO/IEC 27017 and ISO/IEC 27018 certifications. For more information visit the OCI GRC Portal home page.

ODI on OCI Marketplace

 

Oracle Product Management and Development are pleased to announce ODI image on the OCI Marketplace. This image provides fast and easy ways to deploy full instance of Oracle Data Integrator on OCI. It contains pre-built ODI repository and ODI agent which is ready for you to start creating data flow mappings. The image also simplifies Autonomous Database configuration in the ODI repository to provide quick start to ADW data loading projects.

The Marketplace image contains a pre-built ODI repository and is pre-patched with all the latest patches, and include all the connectors for Oracle Autonomous Database, Fusion Application sources, databases, files and much more.

OCI Performance Hub

 

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:

  • Time Range field and time slider
  • Active Session History (ASH) Analytics tab
  • SQL Monitor tab

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.

June 2019

Application Express

 

Autonomous Database now includes Oracle's premiere low-code development platform: Application Express (APEX). This provides a low-code development environment that enables customers and partners to build stunning, scalable, secure apps with world-class features fully supported by Autonomous Database.

SQL Developer Web

 

Oracle SQL Developer Web provides a browser-based integrated development environment and administration interface for Oracle Autonomous Database. It provides a subset of the features available in the desktop product.

Support for Oracle REST Data Services

 

Oracle Rest Data Services (ORDS) is now included with Autonomous Database. ORDS maps HTTP(S) verbs (GET, POST, PUT, DELETE, etc.) to database operations and returns any results formatted using JSON. This means it is now extremely easy to develop modern REST interfaces for relational and JSON data in the Oracle Autonomous Database.

Support for SODA for REST

 

Autonomous Data Warehouse supports Simple Oracle Document Access (SODA) for REST. SODA is a set of NoSQL-style APIs that let you create and store collections of documents in Oracle Database, retrieve them, and query them, without needing to know Structured Query Language (SQL) or how the data in the documents is stored in the database. You can use this API to perform create, read, update, and delete (CRUD) operations on documents of any kind, and you can use it to query JSON documents.

Azure Object Store Support in Data Pump Import

 

This latest update means that Data Pump Import now lets you import data from Data Pump files residing on Micrososft Azure's object store.

Auto Scaling

 

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.

May 2019

Support for Oracle Spatial

 

Autonomous Data Warehouse has enabled the core set of Spatial functionality including the native spatial type, index, and associated core analysis operators and functions. These support the management and analysis of basic geometries; points such as GPS locations, lines such as roads, and polygons such as countries, proximity and containment queries, spatial aggregation, spatial joins, distance/area calculations and much more..

Support for Oracle Text

 

Autonomous Data Warehouse now supports Oracle Text. This makes it possible to perform linguistic analysis using a variety of strategies including keyword searching, context queries, Boolean operations, pattern matching and mixed thematic queries.

Support For Outgoing Database Links

 

It is now possible to create a database link from an ADW instance to any database that is accessible from an ADW including other ADW/ATP instances.

HIPAA

 

The Health Insurance Portability and Accountability Act (HIPAA) is a US law passed by Congress in 1996. Among other requirements, the act establishes privacy and security rules for protected health information (PHI) and aims to make electronic health records (EHR) widely adopted.

Autonomous Database demonstrates its HIPAA fitness through an additional attestation prepared in accordance with AICPA SSAE 18, AT-C sections 205 and 315.

Set CPU/IO Shares

 

Autonomous Data Warehouse now allows customers to change the CPU/IO shares for the consumer groups within their ADW instance (high, medium, low). This allows for use cases where, for example, a workload running in the LOW resource group requires a greater share of CPU and IO resources than HIGH and MEDIUM.

Availability in the Seoul data center

 

Autonomous Database is now available in the Seoul data center.

Integration with Oracle Management Cloud

 

Oracle Management Cloud now supports monitoring Autonomous Databases via its Oracle Database Management console. This provides both monitoring and alerting for your Autonomous Database instances. The Performance Hub page provides both high-level and detailed performance metrics for your Autonomous Database instances. Use of Oracle Management Cloud is included as part of your Autonomous Data Warehouse and Autonomous Transaction Processing services.

Support for pre-authenticated URLs

 

If source files reside on the Oracle Cloud Infrastructure Object Storage it is now possible to use Oracle Cloud Infrastructure pre-authenticated URIs. When a pre-authenticated request is created, a unique URL is generated. This unique URL can then be provided to users, partners, or third parties to access the Object Storage resource target identified in the pre-authenticated request.

Support for XML

 

Oracle XML DB features are now supported in Autonomous Database. This enables existing customers who currently use XML DB to more easily migrate to Autonomous Database. These features also enables all Autonomous Database customers to easily query and access XML data. Please note that some Oracle XML DB features are restricted so refer to the documentation for a complete list of supported features.

Native URL support in Data Pump

 

In Oracle Data Pump, if your source files reside on the Oracle Cloud Infrastructure Object Storage you can now use the Oracle Cloud Infrastructure native URIs. Note that Swift-style URIs are still supported, which means that your existing scripts will continue to work.

Availability of the Tokyo data center

 

Autonomous Database is now available in the Tokyo data center.

April 2019

Support for Network ACLs

 

A simple way to secure your autonomous database instances using network access control lists. Specifying an access control list blocks all IP addresses that are not in the list from accessing the database. Once an access control list is set that specific Autonomous Data Warehouse database only accepts connections from addresses on the access control list and rejects all other client connections

Support for Avro files

 

Avro is a common data format in big data solutions. One of its key benefits is that it enables efficient data exchange between applications and services. Using a similar approach to accessing parquet files, Autonomous Database can now read Avro files and parse the schema within the file to create the columns with the appropriate Oracle Database data types. Avro files may include complex types – like arrays, structs, maps and more; ADW supports avro files that contain Oracle data types.

Change License Type

 

you can now quickly and easily change the licensing for your Autonomous Database from BYOL to a new cloud subscription or vice-versa.

March 2019

Data Warehouse Cloning

 

Autonomous Data Warehouse provides cloning where you can choose to clone either the full database or only the database metadata. So it's now possible with just a few simple mouse-clicks to provision a perfect clone of your existing autonomous data warehouse instance. This is the perfect way to provision new environments such as sandboxes, QA, training, testing etc to support your data warehouse project.

ADB Gains SOC Compliance

 

Autonomous Data Warehouse has achieved SOC 1 and SOC 2 compliance. SOC was created because of the rise of cloud computing and outsourcing of functions to service organizations. Liability concerns caused a demand in assurance of confidentiality and privacy of information processed in the cloud.

Enhanced, Faster Connectivity Options

 

Oracle Cloud Infrastructure FastConnect provides an easy way for you to connect your on-premises network to Autonomous Data Warehouse using FastConnect Public Peering. FastConnect provides higher-bandwidth options, and a more reliable and consistent networking experience compared to internet-based connections.

UI and API Unification for Autonomous Database

 

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.

February 2019

Application Continuity Support

 

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.

January 2019

Parquet File Support

 

Parquet is a file format that is commonly used by the Hadoop ecosystem. Unlike CSV, parquet is really a database file type. Embedded metadata describe a file's contents and data is stored in compressed, columnar format and has been designed for efficient data access.

Parquet provides predicate pushdown (i.e. extract data based on a filter expression), column pruning and other optimizations.

Autonomous Data Warehouse now supports simplified table creation, querying and loading data from parquet files stored in object stores and takes advantage of these query optimizations.

Availability of the Toronto data center

 

Autonomous Data Warehouse is now available in the Toronto data center.

August 2019

Integration with OCI Events Services

 

The OCI Events Service now covers Autonomous Databases (Serverless and Dedicated). OCI Events lets you subscribe to changes in your cloud resources and respond to them by using OCI Notifications, OCI Streaming and Oracle Functions.

Autonomous Database instances generate events for the following resources;

  • Autonomous Database
  • Autonomous Container Database
  • Autonomous Exadata Infrastructure

and covers events such as start of backup, end of backup, create instance-start, create instance-end and maintenance reminders. The full list of supported event types is provided in the presentation listed below in the section headed "DEMO".

Support for Multiple Directories

 

ADB now supports multiple directories which makes it even easier for customers to migrate their existing applications to ADB. For example this simplifies the migration process for customers who have existing ETL jobs that create and drop specific database directories that are used to hold temporary data pump files as part of a data loading workflow.

To create additional directories within an ADB instance cloud administrators and applications can use the standard CREATE DIRECTORY and DROP DIRECTORY commands. The DBMS_CLOUD.LIST_FILES procedure can be used to list the contents of a directory.

Availability of the Mumbai data center

 

Autonomous Data Warehouse is now available in the Mumbai data center.

Availability of the Zurich data center

 

Autonomous Data Warehouse is now available in the Zurich data center.

July 2019

OCI VCN Transit Routing to Oracle Cloud Services

 

On-premises instances/applications no longer need a public IP address, NAT or FastConnect public peering to access the business-critical Oracle services in the Oracle Services Network

This means that on-premise private workloads can initiate connections to Oracle services. Traffic to the Oracle Services is sent via FastConnect peering connection (or VPN Connect) to the DRG in the hub VCN. DRG will then direct the Oracle services traffic to the SGW in the same VCN.

Moving instances between compartments

 

A compartment is allocated when a new ADB instance is created. Previously it has not been possible to move the instance to another compartment. With the launch of this feature, it is now possible to move an Autonomous Database from one compartment to another without interrupting the service.

Resetting Resource Management Rules to the defaults

 

The service console has a UI utility called "Set Resource Management Rules" to specify run-away criteria (query run-time and amount of IO) and CPU/IO shares for each consumer group.

The resource management UI now has a simple button called "Load Default Values" next to the "Save Changes" button. When clicked, the values of the active tab (either 'CPU/IO shares' or 'Run-away criteria') will be reset to their default, out-of-the-box, values.

Native Object Store Authentication for DBMS_CLOUD

 

Now DBMS_CLOUD offers native authentication and uses native APIs as an alternative to the Swift API. The previous Swift authentication (auth tokens) will remain for backward compatibility, however, we recommend customers and partners switch to using the new native API-based approach.

Simplified Service Console UI

 

The ADB Service console used to have several administration-related and development-related operations stacked under the "Administration" tab. In order to provide a better separation between these roles, the UI has been updated with an additional tab called "Development":

ISO-27001, 27017 and 27018 certifications

 

The GRC team has announced that Autonomous Database (ADW and ATP) has achieved ISO/IEC 27001, ISO/IEC 27017 and ISO/IEC 27018 certifications. For more information visit the OCI GRC Portal home page.

ODI on OCI Marketplace

 

Oracle Product Management and Development are pleased to announce ODI image on the OCI Marketplace. This image provides fast and easy ways to deploy full instance of Oracle Data Integrator on OCI. It contains pre-built ODI repository and ODI agent which is ready for you to start creating data flow mappings. The image also simplifies Autonomous Database configuration in the ODI repository to provide quick start to ADW data loading projects.

The Marketplace image contains a pre-built ODI repository and is pre-patched with all the latest patches, and include all the connectors for Oracle Autonomous Database, Fusion Application sources, databases, files and much more.

OCI Performance Hub

 

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:

  • Time Range field and time slider
  • Active Session History (ASH) Analytics tab
  • SQL Monitor tab

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.

June 2019

Application Express

 

Autonomous Database now includes Oracle's premiere low-code development platform: Application Express (APEX). This provides a low-code development environment that enables customers and partners to build stunning, scalable, secure apps with world-class features fully supported by Autonomous Database.

SQL Developer Web

 

Oracle SQL Developer Web provides a browser-based integrated development environment and administration interface for Oracle Autonomous Database. It provides a subset of the features available in the desktop product.

Support for Oracle REST Data Services

 

Oracle Rest Data Services (ORDS) is now included with Autonomous Database. ORDS maps HTTP(S) verbs (GET, POST, PUT, DELETE, etc.) to database operations and returns any results formatted using JSON. This means it is now extremely easy to develop modern REST interfaces for relational and JSON data in the Oracle Autonomous Database.

Support for SODA for REST

 

Autonomous Data Warehouse supports Simple Oracle Document Access (SODA) for REST. SODA is a set of NoSQL-style APIs that let you create and store collections of documents in Oracle Database, retrieve them, and query them, without needing to know Structured Query Language (SQL) or how the data in the documents is stored in the database. You can use this API to perform create, read, update, and delete (CRUD) operations on documents of any kind, and you can use it to query JSON documents.

Azure Object Store Support in Data Pump Import

 

This latest update means that Data Pump Import now lets you import data from Data Pump files residing on Micrososft Azure's object store.

Auto Scaling

 

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.

May 2019

Support for Oracle Spatial

 

Autonomous Data Warehouse has enabled the core set of Spatial functionality including the native spatial type, index, and associated core analysis operators and functions. These support the management and analysis of basic geometries; points such as GPS locations, lines such as roads, and polygons such as countries, proximity and containment queries, spatial aggregation, spatial joins, distance/area calculations and much more..

Support for Oracle Text

 

Autonomous Data Warehouse now supports Oracle Text. This makes it possible to perform linguistic analysis using a variety of strategies including keyword searching, context queries, Boolean operations, pattern matching and mixed thematic queries.

Support For Outgoing Database Links

 

It is now possible to create a database link from an ADW instance to any database that is accessible from an ADW including other ADW/ATP instances.

HIPAA

 

The Health Insurance Portability and Accountability Act (HIPAA) is a US law passed by Congress in 1996. Among other requirements, the act establishes privacy and security rules for protected health information (PHI) and aims to make electronic health records (EHR) widely adopted.

Autonomous Database demonstrates its HIPAA fitness through an additional attestation prepared in accordance with AICPA SSAE 18, AT-C sections 205 and 315.

Set CPU/IO Shares

 

Autonomous Data Warehouse now allows customers to change the CPU/IO shares for the consumer groups within their ADW instance (high, medium, low). This allows for use cases where, for example, a workload running in the LOW resource group requires a greater share of CPU and IO resources than HIGH and MEDIUM.

Availability in the Seoul data center

 

Autonomous Database is now available in the Seoul data center.

Integration with Oracle Management Cloud

 

Oracle Management Cloud now supports monitoring Autonomous Databases via its Oracle Database Management console. This provides both monitoring and alerting for your Autonomous Database instances. The Performance Hub page provides both high-level and detailed performance metrics for your Autonomous Database instances. Use of Oracle Management Cloud is included as part of your Autonomous Data Warehouse and Autonomous Transaction Processing services.

Support for pre-authenticated URLs

 

If source files reside on the Oracle Cloud Infrastructure Object Storage it is now possible to use Oracle Cloud Infrastructure pre-authenticated URIs. When a pre-authenticated request is created, a unique URL is generated. This unique URL can then be provided to users, partners, or third parties to access the Object Storage resource target identified in the pre-authenticated request.

Support for XML

 

Oracle XML DB features are now supported in Autonomous Database. This enables existing customers who currently use XML DB to more easily migrate to Autonomous Database. These features also enables all Autonomous Database customers to easily query and access XML data. Please note that some Oracle XML DB features are restricted so refer to the documentation for a complete list of supported features.

Native URL support in Data Pump

 

In Oracle Data Pump, if your source files reside on the Oracle Cloud Infrastructure Object Storage you can now use the Oracle Cloud Infrastructure native URIs. Note that Swift-style URIs are still supported, which means that your existing scripts will continue to work.

Availability of the Tokyo data center

 

Autonomous Database is now available in the Tokyo data center.

April 2019

Support for Network ACLs

 

A simple way to secure your autonomous database instances using network access control lists. Specifying an access control list blocks all IP addresses that are not in the list from accessing the database. Once an access control list is set that specific Autonomous Data Warehouse database only accepts connections from addresses on the access control list and rejects all other client connections

Support for Avro files

 

Avro is a common data format in big data solutions. One of its key benefits is that it enables efficient data exchange between applications and services. Using a similar approach to accessing parquet files, Autonomous Database can now read Avro files and parse the schema within the file to create the columns with the appropriate Oracle Database data types. Avro files may include complex types – like arrays, structs, maps and more; ADW supports avro files that contain Oracle data types.

Change License Type

 

you can now quickly and easily change the licensing for your Autonomous Database from BYOL to a new cloud subscription or vice-versa.

March 2019

Data Warehouse Cloning

 

Autonomous Data Warehouse provides cloning where you can choose to clone either the full database or only the database metadata. So it's now possible with just a few simple mouse-clicks to provision a perfect clone of your existing autonomous data warehouse instance. This is the perfect way to provision new environments such as sandboxes, QA, training, testing etc to support your data warehouse project.

ADB Gains SOC Compliance

 

Autonomous Data Warehouse has achieved SOC 1 and SOC 2 compliance. SOC was created because of the rise of cloud computing and outsourcing of functions to service organizations. Liability concerns caused a demand in assurance of confidentiality and privacy of information processed in the cloud.

Enhanced, Faster Connectivity Options

 

Oracle Cloud Infrastructure FastConnect provides an easy way for you to connect your on-premises network to Autonomous Data Warehouse using FastConnect Public Peering. FastConnect provides higher-bandwidth options, and a more reliable and consistent networking experience compared to internet-based connections.

UI and API Unification for Autonomous Database

 

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.

February 2019

Application Continuity Support

 

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.

January 2019

Parquet File Support

 

Parquet is a file format that is commonly used by the Hadoop ecosystem. Unlike CSV, parquet is really a database file type. Embedded metadata describe a file's contents and data is stored in compressed, columnar format and has been designed for efficient data access.

Parquet provides predicate pushdown (i.e. extract data based on a filter expression), column pruning and other optimizations.

Autonomous Data Warehouse now supports simplified table creation, querying and loading data from parquet files stored in object stores and takes advantage of these query optimizations.

Availability of the Toronto data center

 

Autonomous Data Warehouse is now available in the Toronto data center.

June 2019

Application Express

 

Autonomous Database now includes Oracle's premiere low-code development platform: Application Express (APEX). This provides a low-code development environment that enables customers and partners to build stunning, scalable, secure apps with world-class features fully supported by Autonomous Database.

SQL Developer Web

 

Oracle SQL Developer Web provides a browser-based integrated development environment and administration interface for Oracle Autonomous Database. It provides a subset of the features available in the desktop product.

Support for Oracle REST Data Services

 

Oracle Rest Data Services (ORDS) is now included with Autonomous Database. ORDS maps HTTP(S) verbs (GET, POST, PUT, DELETE, etc.) to database operations and returns any results formatted using JSON. This means it is now extremely easy to develop modern REST interfaces for relational and JSON data in the Oracle Autonomous Database.

Support for SODA for REST

 

Autonomous Data Warehouse supports Simple Oracle Document Access (SODA) for REST. SODA is a set of NoSQL-style APIs that let you create and store collections of documents in Oracle Database, retrieve them, and query them, without needing to know Structured Query Language (SQL) or how the data in the documents is stored in the database. You can use this API to perform create, read, update, and delete (CRUD) operations on documents of any kind, and you can use it to query JSON documents.

Azure Object Store Support in Data Pump Import

 

This latest update means that Data Pump Import now lets you import data from Data Pump files residing on Micrososft Azure's object store.

Auto Scaling

 

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.

May 2019

Support for Oracle Spatial

 

Autonomous Data Warehouse has enabled the core set of Spatial functionality including the native spatial type, index, and associated core analysis operators and functions. These support the management and analysis of basic geometries; points such as GPS locations, lines such as roads, and polygons such as countries, proximity and containment queries, spatial aggregation, spatial joins, distance/area calculations and much more..

Support for Oracle Text

 

Autonomous Data Warehouse now supports Oracle Text. This makes it possible to perform linguistic analysis using a variety of strategies including keyword searching, context queries, Boolean operations, pattern matching and mixed thematic queries.

Support For Outgoing Database Links

 

It is now possible to create a database link from an ADW instance to any database that is accessible from an ADW including other ADW/ATP instances.

HIPAA

 

The Health Insurance Portability and Accountability Act (HIPAA) is a US law passed by Congress in 1996. Among other requirements, the act establishes privacy and security rules for protected health information (PHI) and aims to make electronic health records (EHR) widely adopted.

Autonomous Database demonstrates its HIPAA fitness through an additional attestation prepared in accordance with AICPA SSAE 18, AT-C sections 205 and 315.

Set CPU/IO Shares

 

Autonomous Data Warehouse now allows customers to change the CPU/IO shares for the consumer groups within their ADW instance (high, medium, low). This allows for use cases where, for example, a workload running in the LOW resource group requires a greater share of CPU and IO resources than HIGH and MEDIUM.

Availability in the Seoul region

 

Autonomous Database is now available in the Seoul region data center.

Integration with Oracle Management Cloud

 

Oracle Management Cloud now supports monitoring Autonomous Databases via its Oracle Database Management console. This provides both monitoring and alerting for your Autonomous Database instances. The Performance Hub page provides both high-level and detailed performance metrics for your Autonomous Database instances. Use of Oracle Management Cloud is included as part of your Autonomous Data Warehouse and Autonomous Transaction Processing services.

Support for pre-authenticated URLs

 

If source files reside on the Oracle Cloud Infrastructure Object Storage it is now possible to use Oracle Cloud Infrastructure pre-authenticated URIs. When a pre-authenticated request is created, a unique URL is generated. This unique URL can then be provided to users, partners, or third parties to access the Object Storage resource target identified in the pre-authenticated request.

Support for XML

 

Oracle XML DB features are now supported in Autonomous Database. This enables existing customers who currently use XML DB to more easily migrate to Autonomous Database. These features also enables all Autonomous Database customers to easily query and access XML data. Please note that some Oracle XML DB features are restricted so refer to the documentation for a complete list of supported features.

Native URL support in Data Pump

 

In Oracle Data Pump, if your source files reside on the Oracle Cloud Infrastructure Object Storage you can now use the Oracle Cloud Infrastructure native URIs. Note that Swift-style URIs are still supported, which means that your existing scripts will continue to work.

Availability of the Tokyo region

 

Autonomous Database is now available in the Tokyo region data center.

April 2019

Support for Network ACLs

 

A simple way to secure your autonomous database instances using network access control lists. Specifying an access control list blocks all IP addresses that are not in the list from accessing the database. Once an access control list is set that specific Autonomous Data Warehouse database only accepts connections from addresses on the access control list and rejects all other client connections

Support for Avro files

 

Avro is a common data format in big data solutions. One of its key benefits is that it enables efficient data exchange between applications and services. Using a similar approach to accessing parquet files, Autonomous Database can now read Avro files and parse the schema within the file to create the columns with the appropriate Oracle Database data types. Avro files may include complex types – like arrays, structs, maps and more; ADW supports avro files that contain Oracle data types.

Change License Type

 

you can now quickly and easily change the licensing for your Autonomous Database from BYOL to a new cloud subscription or vice-versa.

March 2019

Data Warehouse Cloning

 

Autonomous Data Warehouse provides cloning where you can choose to clone either the full database or only the database metadata. So it's now possible with just a few simple mouse-clicks to provision a perfect clone of your existing autonomous data warehouse instance. This is the perfect way to provision new environments such as sandboxes, QA, training, testing etc to support your data warehouse project.

ADB Gains SOC Compliance

 

Autonomous Data Warehouse has achieved SOC 1 and SOC 2 compliance. SOC was created because of the rise of cloud computing and outsourcing of functions to service organizations. Liability concerns caused a demand in assurance of confidentiality and privacy of information processed in the cloud.

Enhanced, Faster Connectivity Options

 

Oracle Cloud Infrastructure FastConnect provides an easy way for you to connect your on-premises network to Autonomous Data Warehouse using FastConnect Public Peering. FastConnect provides higher-bandwidth options, and a more reliable and consistent networking experience compared to internet-based connections.

UI and API Unification for Autonomous Database

 

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.

February 2019

Application Continuity Support

 

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.

January 2019

Parquet File Support

 

Parquet is a file format that is commonly used by the Hadoop ecosystem. Unlike CSV, parquet is really a database file type. Embedded metadata describe a file's contents and data is stored in compressed, columnar format and has been designed for efficient data access.

Parquet provides predicate pushdown (i.e. extract data based on a filter expression), column pruning and other optimizations.

Autonomous Data Warehouse now supports simplified table creation, querying and loading data from parquet files stored in object stores and takes advantage of these query optimizations.

Availability of the Toronto region

 

Autonomous Data Warehouse is now available in the Toronto region.

November 2018

Availability of the London region

 

Autonomous Data Warehouse is now available in the London region.

October 2018

Oracle Cloud Infrastructure Console Changes

 

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

Documentation changes

 

The documentation page for Autonomous Data Warehouse, Getting Started now includes new role-based topic links:

  • Business Analyst
  • Cloud Administrator
  • Cloud Architect
  • Data Warehouse Developer

September 2018

Table compression methods

 

In addition to Hybrid Columnar Compression all table compression types are now available in Autonomous Data Warehouse.

For more information, see the section headed "Managing DML Performance and Compression" in the documentation guide.

Partitioned tables, indexes, and materialized views

 

Autonomous Data Warehouse 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 the section headed "Managing Concurrency and Priorities on Autonomous Data Warehouse" in the documentation guide.

August 2018

Launch of Autonomous Transaction Processing

 

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.

July 2018

SQL Developer - new connection process

 

SQL Developer 18.2.0 and later now allows for setting up connections without the need for keystore passwords.

June 2018

New management interfaces

 

Autonomous Data Warehouse is now provisioned and managed using the native Oracle Cloud Infrastructure. This provides a more intuitive user interface to make managing your Autonomous Data Warehouse instances easier with additional capabilities including sorting and filtering.

For more information, see Oracle Help Center.

Better authorization management

 

Autonomous Data Warehouse is now provisioned and managed using the native Oracle Cloud Infrastructure. This provides a more intuitive user interface to make managing your Autonomous Data Warehouse instances easier with additional capabilities including sorting and filtering.

For more information, see Oracle Help Center.

Built-in auditing

 

The OCI Audit service records use of Autonomous Data Warehouse 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 Data Warehouse 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 Data Warehouse instances with the Oracle Cloud Infrastructure Console.

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 Managing Concurrency and Priorities on Autonomous Data Warehouse.

May 2018

Object Storage Credentials

 

The term "Swift Password" has been replaced with the term "Auth token" in the documentation and UI.

April 2018

Microsoft Azure integration

Autonomous Data Warehouse 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 Data Warehouse, see LIST_FILES Function.

You can also remove files from the local file system. See DELETE_FILE Procedure.

Test Drive New Data Warehouse Features In Database 19c