Even more new features added to Autonomous Database in April

April 28, 2023 | 6 minute read
Keith Laker
Senior Principal Product Manager
Text Size 100%:

We are continually adding new features to Autonomous Database. Over the LAST 12 MONTHS OVER +170 NEW FEATURES have been added, and the latest update included the following: 

  1. SNAPSHOT STANDBYS FOR X-REGION DR - a disaster recovery cross-region peer can be converted to a snapshot standby - a read-write database - for up to two days. 
  2. SINGLETON PIPES IN DBMS_PIPE - using a Singleton Pipe, you can send and retrieve a custom message and share the message across multiple database sessions with concurrent reads.
  3. SEND NOTIFICATIONS TO MICROSOFT TEAMS - send messages, alerts, or the output of a query from Autonomous Database to a Microsoft Teams Channel. 
  4. SEND EMAILS USING DBMS_CLOUD_NOTIFICATION - Send emails to a public SMTP endpoint using the Oracle Cloud Infrastructure Email Delivery service. 
  5. OML SERVICES BATCH SCORING - batch scoring for in-database models using REST endpoints for more optimal scalability and efficiency.
  6. NEXT-GENERATION OML NOTEBOOKS - an enhanced web-based notebook platform for data analysts and data scientists.
  7. STRATEGIC CUSTOMER PROGRAM FOR AUTONOMOUS DATABASE - expert-led advice and guidance on successfully designing and rolling out an ADB project.
  8. Oracle Global Leaders summer events in Nashville and Sofia

Below is more information on each of the above topics. Let me know if you have questions on any of the following topics - you can email me directly (keith.laker@oracle.com).


 

 SIMPLER MANAGEMENT

ADB makes deploying and managing application workloads easier regardless of complexity, scale, or criticality.

SNAPSHOT STANDBYS FOR CROSS-REGION DR

FEATURE OVERVIEW

A cross-region peer can be converted to a snapshot standby. This converts the peer to a read-write database for up to two days. 

Snapshot standby CPU usage is billed based on the base CPU count and any additional CPU usage if compute auto-scaling is enabled.

BUSINESS BENEFIT

This feature significantly improves the overall cost-effectiveness of Autonomous Database where customers have enabled Autonomous Data Guard. 

It allows the snapshot standby to be used for testing and querying the data with no downtime on the primary (source) database. 

Using a snapshot standby, you can make configuration changes or perform DML operations on the database as needed for complete testing and verification of the standby environment. 

LEARN MORE 

DOC: Convert Cross Region Peer to Snapshot Standby, click here 

 

SINGLETON PIPES IN DBMS_PIPE

FEATURE OVERVIEW

The DBMS_PIPE package allows two or more database sessions to communicate using in-memory messages. 

Singleton Pipe is an addition to the DBMS_PIPE package that allows you to cache and retrieve a custom message and share the message across multiple database sessions with concurrent reads.

No alt text provided for this image

BUSINESS BENEFIT

Cloud admins and application developers can use the pipe functionality in several ways: as an external service interface, debugging, independent transactions, and alerts. 

LEARN MORE 

DOC: Caching messages with singleton pipes, click here

 

SEND NOTIFICATIONS TO MICROSOFT TEAMS

FEATURE OVERVIEW

Microsoft Teams channels can now receive messages, alerts, or output of a query from Autonomous Database using DBMS_CLOUD_NOTIFICATION. 

BUSINESS BENEFIT

This makes it easier for customers who use Microsoft Teams to integrate directly with operations related to activities within Autonomous Database. 

LEARN MORE 

DOC: Send notifications from Autonomous Database to Microsoft Teams, click here

 

SEND EMAILS FROM AUTONOMOUS DATABASE

FEATURE OVERVIEW

Use the DBMS_CLOUD_NOTIFICATION package to send messages and query results as emails to public SMTP endpoints. Note that Oracle Cloud Infrastructure Email Delivery Service is the only supported email provider. 

BUSINESS BENEFIT

This makes it easier to send query results or send messages via email using Autonomous Database to groups or individuals.

LEARN MORE 

DOC: Send Email from Autonomous Database Using DBMS_CLOUD_NOTIFICATION, click here

 


RICHER ANALYTICS

ADB's rich in-database analytics helps you win new deals and expand existing deployments.

OML SERVICES BATCH SCORING

FEATURE OVERVIEW

Oracle Machine Learning Services (OML Services) on Oracle Autonomous Database now supports batch scoring for in-database models using REST endpoints. With OML Services, models can now be deployed through REST endpoints hosted in Oracle Autonomous Database to enable batch scoring. 

OML Services supports batch scoring for regression, classification, clustering, and feature extraction machine learning techniques.

BUSINESS BENEFIT

This new approach to batch scoring means that both the source data and scoring results remain inside the Autonomous Database, which means reduced latency and more optimal scalability and efficiency. 

Unlike other solutions that require provisioning a VM for 24 - 7 availability, OML Services is included with Oracle Autonomous Database, so users pay only for the additional compute when producing actual predictions.

LEARN MORE 

BLOG: Announcing OML Services Batch Scoring on Autonomous Database, click here 

DOC: Oracle Machine Learning Services, click here 

GITHUB: Example notebooks, click here 

AskTOM: OML Services Batch Scoring on Autonomous Database, click here 

LIVELABS: Get started with Oracle Machine Learning Fundamentals on Oracle Autonomous Database, click here.

 

NEXT-GENERATION OML NOTEBOOKS

FEATURE OVERVIEW

The new OML Notebooks interface, OML Notebooks EA, is now generally available across all regions. This new interface is provided alongside the current environment to give your customers the opportunity to explore this new functionality and convert existing notebooks over the coming months to the new environment with the simple click of a button. 

New features include:

 

  • faster notebook loading times
  • new Oracle "Redwood" look and feel
  • Jupyter and Zeppelin layouts
  • richer visualization
  • individual paragraph comments and dependencies

 

No alt text provided for this image

 

BUSINESS BENEFIT

OML Notebooks are automatically provisioned and managed within Autonomous Database. OML Notebooks enable creating conda environments with custom-installed third-party R and Python packages for OML4Py and OML4R. 

Unlike other solutions that require provisioning a VM for 24 - 7 availability, OML Services is included with Oracle Autonomous Database, so users pay only for the additional compute when producing actual predictions. 

LEARN MORE 

BLOG: Announcing next-generation OML Notebooks on Oracle Autonomous Database, click here 

DOC: Get Started with Notebooks Early Adopter for Data Analysis and Data Visualization, click here 

 


GLOBAL LEADERS PROGRAM

STRATEGIC CUSTOMER PROGRAM FOR AUTONOMOUS DATABASE

Expert-led advice and guidance on successfully designing and rolling out an ADB project.

The Oracle Strategic Customer Program for Autonomous Database Serverless is designed to help you deliver successful Autonomous Database projects by directly supporting you and your customer. It provides expert-led advice and guidance on successfully designing and rolling out an Autonomous Database project. 

There are many benefits in bringing your customers and prospects into this global program, including:

 

  • Ensure successful migration and implementation of existing workloads on Autonomous Database
  • Support from both product management and development
  • Dedicated coordinators for each geographical region
  • Program support for a project is targeted to last approximately three months but can be extended
  • Invitation to join the Oracle Global Leaders Program after successful implementation
  • The program is delivered using an honor system - no contracts!

 

NEXT STEPS 

Use the following link to contact our Global Leaders team to discuss how we can help you with your next Autonomous Database project: click here for more information.

 

AMERICAS ORACLE GLOBAL LEADERS MEETING IN NASHVILLE

June 7 - 8, 2023 | The Hermitage Hotel, Nashville

These in-person events will inspire your customers and help them learn more about how Autonomous Database and Oracle Cloud can drive innovation, growth, and success. 

Hosted by Oracle Database Product Management and Intel, this is a unique networking event for Oracle Customers using Oracle Data Management products and services to share the details of their journeys – successes, plans, obstacles, and learnings. 

NEXT STEPS 

Use the following link to register for this event: click here for more information about how to register .

 

EMEA ORACLE GLOBAL LEADERS MEETING IN SOFIA

June 22 - 23, 2023 | InterContinental: Sofia

Hosted by Oracle Database Product Management and Intel, this is a unique networking event for Oracle Customers using Oracle Data Management products and services to share the details of their journeys – successes, plans, obstacles, and learnings. 

NEXT STEPS 

Use the following link to register for this event: click here for more information about how to register.

Keith Laker

Senior Principal Product Manager

Product Manager for Autonomous Database and Analytic SQL with extensive experience in data warehouse and business intelligence projects. Worked in various roles, including post-sales consultancy, customer support, and product management at locations across Europe and US.

 


Previous Post

How to Take Actions or Get Notified When Scheduler Jobs Complete in Autonomous Database

Can Tuzla | 4 min read

Next Post


Latest Autonomous Data Warehouse innovations breaking through data management boundaries

George Lumpkin | 8 min read
Everything you need to know about data warehousing with the world's leading cloud solution provider