Welcome to our latest customer newsletter for Autonomous Database on Shared Exadata Infrastructure. This newsletter covers the following new features and topics:
Don't forget to checkout our "What's New" page for a comprehensive archive of all the new features we have added to Autonomous Database - click here.
To find out how to subscribe to this newsletter click here.
|
|
(Shared
Infrastructure
Only)
|
NEW
The service level agreement for ADB has just been published and it applies only to the deployment of an Autonomous Database on shared infrastructure.
The pillar document listed below in the section headed LEARN states that:
Oracle will use commercially reasonable efforts to have the Oracle Cloud Infrastructure – Autonomous Database Services on Shared Infrastructure with a Monthly Uptime Percentage of at least 99.95% during any calendar month (the "Service Commitment").
In the event an Autonomous Database Service on Shared Infrastructure does not meet the "Service Commitment" then customers will be eligible to receive Service Credits. Note - there are specific definitions of key terms in the pillar document (listed below in the section headed LEARN) that you should read and understand.
PDF: Oracle PaaS and IaaS Public Cloud Services Pillar Document (April 2020), click here.
Autonomous Database information is covered in Category 7, which starts on page 4 with ADB covered on pages 17 and 18.
|
|
|
(Shared
Infrastructure
Only)
|
NEW
Autonomous Database instance CPU and storage usage is now billed by the second, with a minimum usage period of one minute. Previously Autonomous Database billed in one-hour minimum increments and partial usage of an hour was rounded up to a full hour.
This change benefits the following types of use cases:
- Where you only run your ADB instances during work hours and stop instances at end of working day
- Where you start-stop your instances to run overnight batch jobs
- Where you have ADB instances which typically have a short lifecycle – sandboxes, QA, training, integration testing instances.
DOC: Per-second billing announcement for ADW, click here
DOC: Per-second billing announcement for ATP, click here
DOC: OCI Per-second billing general announcement which covers ADB, click here
BLOG: Review of per-second billing on OCI, click here
|
|
|
(Shared
Infrastructure
Only)
|
NEW
Autonomous Database now supports loading and using Simple Oracle Document Architecture (SODA) documents and collections. SODA allows developers to store, search, and retrieve document collections, typically JSON documents, without using SQL.
It is possible to also access document collections with SQL/JSON operators which means that ADB now combines the simplicity of a document database with the power of a relational database.
The Oracle Cloud Infrastructure console has been updated with a link to access the SODA drivers for several languages and frameworks including: Java, Node.js, Python, Oracle Call Interface, and PL/SQL, as shown below.
DOC: Using JSON Documents with ADW, click here
DOC: Using JSON Documents with ATP, click here
Documentation covers the following key topics:
- Work with Simple Oracle Document Access (SODA) in Autonomous Database
- SODA Collection Metadata on Autonomous Database
- Work with JSON Documents Using SQL and PL/SQL APIs on Autonomous Database
- Load JSON Documents with Autonomous Database
|
|
|
(Shared
Infrastructure
Only)
|
NEW
ADB extensions enable developers to connect to, browse, and manage Autonomous Databases directly from their IDEs. There are extensions for the following: Eclipse, Microsoft Visual Studio and Visual Studio Code.
Users with permissions to manage the databases can perform a number of actions (depending on their IDE), such as:
- Sign up for Oracle Cloud
- Connect to a cloud account using a simple auto-generated config file and key file
- Create new or clone existing Always Free Autonomous Database, Autonomous Database Dedicated, and Autonomous Database Shared databases
- Automatically download credentials files (including wallets) and quickly connect, browse, and operate on Autonomous Database schemas
- Change compartments and regions without reconnecting
- Start, stop, or terminate Autonomous Databases
- Scale up/down Autonomous Database resources
- Restore from backup
- Update instance credentials and/or license type used
- Rotate wallets
- Convert Always Free ADBs into paid ADBs
|
|
(Shared
Infrastructure
Only)
|
NEW
When configuring a private endpoint one of the steps is to define a security rule(s) in a Network Security Group. This creates a virtual firewall for the Autonomous Database and allows connections to the Autonomous Database instance.
The Network Security Group can now be configured with stateful rules.
DOC: Configure Private Endpoints with ADW, click here
DOC: Configure Private Endpoints with ATP, click here
BLOG: Announcing Private Endpoints in Autonomous Database on Shared Exadata Infrastructure, click here.
|
|
|
(Shared
Infrastructure
Only)
|
UPDATED
Two specific improvements relating to how Data Pump dump files can be used with ADB. It is now possible to:
- Query Data Pump dump files in the Cloud by creating an external table
- Use Data Pump dump files in the Cloud as source files to load data
DOC: Query external Data Pump dump files with ADW, click here
DOC: Load Data Pump dump files into an existing table with ADW, click here.
DOC: Query external Data Pump dump files with ATP, click here
DOC: Load Data Pump dump files into an existing table with ATP, click here.
|
|
|
 |
ORACLE GLOBAL LEADERS PROGRAM
|
 |
WEBCAST
29 April 2020 at 15:00 CET
Join this Oracle Global Leaders webcast to discover directly from Peter Merkert, CTO & Co-Fouder, Retraced GmbH how they are using Oracle Autonomous Database and the benefit they are getting. To register click here.
To learn more, also see the video: How Autonomous & Blockchain Provide A Sustainable Transparent Clothing Supply Chain?
|
|
 |
WEBCAST
13 May 2020 at 12:00 PM ET
Join this Oracle Global Leaders webcast to discover directly from Derek Hayden, SVP, Data Strategy and Analytics at OUTFRONT Media, about the role of Autonomous Data Warehouse in the new data platform for OUTFRONT Media moving in the digital age.
Derek will discuss initial success with ADW, OAC and how this platform is being used for OUTFRONT's growth, efficiencies and data management in the out of home advertising industry.
To register click here.
|
|
| |
WEBCAST
19 May 2020 at 15:00 CET
Join this Oracle Global Leaders webcast to discover directly from Dr. Holger Friedrich, CEO, SumIT how they are using Oracle Autonomous Database and the benefit they are getting.
Oracle Application Express is a powerful low-code web application development framework built-in and ready-to-use with Oracle Autonomous Database. It is instantly available in every provisioned service instance. In this webcast we will explain and demonstrate how sumIT and partner document2relation employ APEX and ATP to provide quick migration services and application development for migrating legacy Lotus Notes applications to the Cloud.
To register click here.
|
|
 |
WEBCAST
13 May 2020 at 12:00 PM ET
Join our Global Leaders webinar to hear from Frank Hoogendoorn, CDO of MineSense: a technology solution provider for the Mining Industry that combines IoT and machine learning to create "Smart Shovel" technologies that optimize mine operations, all powered by Oracle solutions!
In this Webinar, Frank will explain how MineSense has transitioned from "start-up" to a "scale-up", and how Autonomous Data Warehouse with built-in APEX is enabling rapid business growth with international Mining customers that include some of the world’s largest Copper and Zinc producers. Backed by APEX and ADW, their disruptive ‘smart shovel’ technology collects and analyzes orebody data in real-time, where machine learning based algorithms drive processing decisions to boost mine productivity while reducing energy consumption, all of which leads to more sustainable mining operations. With the flexibility and low cost setup of ADW, the ease of application development and deployment with APEX, and superb on-demand data processing performance, MineSense will talk about how Oracle Solutions, (some even running right on mining shovels!), have been key in setting up a pivotal digital platform, where IT is no longer seen as a business cost but rather a key driver for growth.
To register click here.
|
|
|
