X

Information, tips, tricks and sample code for Big Data Warehousing in an autonomous, cloud-driven world

Try Oracle Cloud Platform For Free

Autonomous Database Newsletter - February 18-2020

Keith Laker
Senior Principal Product Manager
 


Autonomous Database
on
Shared Exadata
Infrastructure

February 18, 2020
 


 
ADB Logo
 

Welcome to our first customer newsletter for Autonomous Database on Shared Exadata Infrastructure. This first newsletter covers the following new features and topics:

  1. Database Vault now available
  2. APEX 19.2 now available in Always Free ADB
  3. Multiple DB support
  4. New Graph Server supports ADB
  5. Easier migrations
  6. New data centers
  7. Global Leaders Program - Day With Development
  8. Quick Links

 

Don't forget to checkout our "What's New" page for Autonomous Database on oracle.com, click here.

  

BACK TO TOP
 
Feature Icon

(Shared
Infrastructure
Only)
NEW - Using Oracle Database Vault with Autonomous Database

Oracle Database Vault implements powerful security controls for your Autonomous 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.

 

 

LEARN MORE

 

DOC: Using Oracle Database Vault with ADW: click here

DOC: Using Oracle Database Vault with ATP: click here.

PPT: OOW2018 - Autonomous and Beyond: Security in the Age of the Autonomous Database: click here

DOC: Database 19c documentation for Database Vault, click here.

 

 

SEE MORE

 

VIDEO: Database Vault Overview, click here.

PDF: Database Vault FAQ - click here

PDF: Database Vault Data Sheet - click here

PDF: Oracle Database Vault Overview - click here

PDF: Oracle Database Vault Best Practices - click here

PDF: Oracle Database Vault DBA Best Practices - click here

 

 

DO MORE

 

VIDEO: Database Vault - Enforcing separation of duties, click here.

VIDEO: Database Vault - Enforcing Trusted Path Access Control, click here.

VIDEO: Database Vault Advanced Use Cases II - Operations Control, Database Vault Simulation Mode, click here.

 

 
 

BACK TO TOP
 
Feature Icon

(Shared
Infrastructure
Only)

 

NEW - Always Free Autonomous Database now includes APEX 19.2

Oracle APEX 19.2 on Always Free Autonomous Database provides a preconfigured, fully managed and secured environment to both build and deploy world-class data-centric applications. Oracle APEX applications developed on-premise can be easily deployed to Oracle APEX on the free version Autonomous Database.

 

 

LEARN MORE

 

What is Application Express: click here.

DOC: APEX 19c Getting Started Guide: click here.

DOC: Creating Applications with Oracle Application Express in ADW: click here.

DOC: Creating Applications with Oracle Application Express in ATP: click here.

 

 

DO MORE

 

Create a simple Human Resources (HR) application for the fictitious AnyCo Corp which manages departmental and employee information stored in database tables, click here.

VIDEO: Learn how to create an APEX Application using a spreadsheet in just 2 minutes! click here.

HOL: List of APEX hands-on labs: click here.

 

 
 

BACK TO TOP
 
Feature Icon

(Shared
Infrastructure
Only)
NEW - Multiple Database Versions and Availability by Region

Depending on the region where you provision or clone your database, Autonomous Database now supports one or more Oracle Database versions. The version availability depends on the region - note that some regions do not support multiple Oracle Database versions.

When multiple database versions are available, you choose an Oracle Database version when you provision or clone a database

Multiple Database Support when creating a new ADB instance

 

LEARN MORE

 

DOC: Oracle Database versions and availability by region for ADW: click here.

DOC: Oracle Database versions and availability by region for ATP: click here.

If you are using ADB with Oracle Database 19c there are additional database features available in the database:

DOC: ADW Oracle Database 19c features, click here.

DOC: ATP Oracle Database 19c features, click here.

 
 

BACK TO TOP
 
Feature Icon

(Shared
Infrastructure
Only)
NEW - Availability of Oracle Graph Server and Client 20.1

Oracle Graph Server and Client 20.1 is a software package that works with Autonomous Database. It includes the in-memory analytics server (PGX) and client libraries required to work with the Property Graph feature in Autonomous Database.

With graph analytics you can explore and discover connections and patterns in social networks, IoT, big data, data warehouses, and complex transaction data for applications such as fraud detection in banking, customer 360, and smart manufacturing.

 

LEARN MORE

 

Download is available on edelivery.oracle.com click here.

DOC: Installation instructions click here. See section 1.7 Using Oracle Graph with the Autonomous Database.

WEB: Graph Server page on oracle.com click here.

 

 

SEE MORE

 

PPT: Demystifying Graph Analytics for the Non-expert, click here

PPT: Using Graph Analytics for New Insights, click here

 
 

BACK TO TOP
 
Feature Icon

(Shared
Infrastructure
Only)

 

NEW - Features to Simplify Migrations To ADB

1. Database Resident Connection Pool (DRCP)
Using DRCP provides you with access to a connection pool in your ADB 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.

DOC: ADW click here.
DOC: ATP click here.

 

2. Set MAX_STRING_SIZE value
By default the Autonomous Data Warehouse database uses MAX_STRING_SIZE 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.

DOC: ADW click here.
DOC: ATP click here.

 

3. Number of concurrent statements
The maximum number of concurrent statements is increased. See Predefined Database Service Names for Autonomous Data Warehouse for more information.

DOC: ADW click here.
DOC: ATP click here.

 

 

  

BACK TO TOP
 

(Shared
Infrastructure
Only)
NEW - More Data Centers Now Online

Autonomous Database is now available in the following data centers:

  • Jeddah, Saudi Arabia
  • Osaka, Japan
  • Melbourne, Australia
  • Amsterdam, Netherlands

For more information on the status of services in each data center click here. For more information about how to subscribe to these new regions, click here. To switch to the new region, use the Region menu in the Console. See Switching Regions for more information, click here.

 

  

BACK TO TOP
 

EVENTS Oracle Global Leaders - Day With Development

As part of our Global Leaders program, Oracle Product Management will be hosting a series of workshops for Architects, DBAs, Application Developers and for those interested in learning more about Oracle Information Management.

Content will cover a general architecture overview, various cloud service capabilities (such as Autonomous Data Warehouse, Oracle Data Integration and Oracle Analytics Cloud) and how these services work together. All Services will be shown live so you will experience the look and feel of each product along with how to work with our complete range of data warehouse services.

The schedule for this series of "Day With Development" events in the US is:



 		 Feb 21

 		     Chesterfield/St Louis


 		 Feb 28

 		     Vancouver


 		 March 26

 		      Irving


 		 April 20

 		     Nashville


 		 April 21

 		     Louisville


 		 May 21

 		     New York

The schedule for this series of "Day With Development" events in the EMEA is:



 		 March 3

 		     Madrid, Spain


 		 March 5

 		     Roma, Italy


 		 March 9
(Morning)

 		     Dubai, United Arab Emirates


 		 March 9
(Afternoon)

 		     Dubai, United Arab Emirates


 		 March 12

 		     Istanbul, Turkey


 		 March 16

 		     Warszawa, Poland


 		 March 18

 		     Colombes cedex, France


 		 March 23

 		     Moscow, Russian Federation2

Please use the above links to register for an event in your area and get more information the general Terms and Conditions.

 

  

BACK TO TOP
 
oracle.com Icon

oracle.com
ADW ATP
Documentation Icon

Documentation
ADW ATP
YCO calculation Icon

TCO Calculator
Serverless Dedicated
Cloud Cost Estimator Icon

Cloud Cost Estimator
Autonomous Database
Public What's New Icon

ADB New Features
Autonomous Database
Schema Advisor icon

Schema Advisor
Autonomous Database
 
 
 
Public What's New Icon

Customer Forums
ADW ATP
 
 
 

BACK TO TOP
 

Join the discussion

Comments ( 1 )
  • Vinod S Monday, February 24, 2020
    Wonderful to read the first newsletter. Great job in collating a wide range of reading material. These are powerful reads for an Oracle expert. It would be valuable to include at least one article on the basics - how will someone very new to Oracle Autonomous Database get started. Looking forward to the next edition of the newsletter.
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.

Recent Content