September edition of newsletter for Autonomous Database Serverless

September 5, 2023 | 8 minute read
Keith Laker
Senior Principal Product Manager
Text Size 100%:

Lots of new features have just rolled out that will help you get even more from your Autonomous Database....

 

  • NEW - switch from ocpu to new ecpu model.
  • NEW - set backup retention period for more control over storage costs (ecpu-model only)
  • NEW - logical partition tracking improves query performance
  • NEW - data transforms now supports reverse private endpoints
  • NEW - app store for adb on github
  • NEW - free app to help monitor cloud infrastructure costs and usage

Update from our Global Leaders Team

  • FREE - strategic customer program for autonomous database
  • FREE 1-Day AI workshop for architects and practitioners
  • JOIN US at cloudworld 2023 for global leaders worldwide meeting
  • JOIN US at our EMEA Autumn Global Leaders meeting in Porto

 


SWITCH FROM OCPU TO NEW ECPU MODEL

OVERVIEW Customers can now update their Autonomous Database instances from the OCPU billing model to the new ECPU billing model. The option to upgrade is on the ADB console in the section covering resource allocation:

While provisioning a new database or cloning an existing database:

  • CPU count defaults to the minimum size of 2 ECPUs.
  • For databases that need more than 2 ECPUs, specify the number of ECPUs as an integer (i.e., 3,4,5, etc.).

 

BUSINESS BENEFIT The ECPU model offers finer-granularity pricing for resizing and auto scaling an Autonomous Database. Since backups are charged separately, there is more granular control over the backup process by setting the retention period between 1 and 60 days. Notes: The JSON Database and the APEX Service workload types only support the OCPU billing model and do not support updating an Autonomous Database instance to the ECPU billing model.

LEARN MORE

FAQ: Autonomous Database ECPU (public) FAQ on oracle.comclick here

DOC: Update to ECPU Billing Model on Autonomous Database, click here

DOC: ECPU Compute Model Billing Information, click here.


 

SET BACKUP RETENTION PERIOD WHEN USING NEW ECPU MODEL

OVERVIEW You can change the backup retention period for automatic backups on Autonomous Database with a retention period between 1 day and up to 60 days. The ability to set the backup retention period is only available for instances using the ECPU compute model.

 

BUSINESS BENEFIT Setting the backup retention period gives customers more control over the storage costs associated with the automatic backups.

LEARN MORE

DOC: Edit Automatic Backup Retention Period on Autonomous Database, click here.


 

LOGICAL PARTITION TRACKING IMPROVES QUERY PERFORMANCE

OVERVIEW Logical Partition Change Tracking (LPCT) tracks the staleness of materialized views. It evaluates the staleness of the base tables for individual logical partitions without using a materialized view log or requiring any of the tables used in the materialized view to be partitioned. LPCT can be created, modified, or dropped on the base table at any time, independent of table creation. The base table can be partitioned or non-partitioned, which makes it more adaptable than PCT. Because the LPCT framework requires metadata only and no changes to the base table.

BUSINESS BENEFIT LPCT significantly broadens the applicability of query rewrite for applications due to the fine-grained query rewrite. With LPCT, refresh operations are targeted at stale logical partitions only, improving the refresh time for materialized views and avoiding a complete re-build of the materialized view.

LEARN MORE

DOC: Logical Partition Change Tracking (LPCT) Refresh for Materialized Views, click here.


DATA TRANSFORMS NOW SUPPORTS REVERSE PRIVATE ENDPOINTS

OVERVIEW ADB-S built-in Data Transforms tool now supports support reverse connections on private endpoint (PE), i.e. subject to customer's VCN rules when the ADB-S is configured with PE. Overall, Data Transforms is now consistent with other ADB-S components in terms of network access (e.g. db links, UTL_HTTP, UTL_SMTP, APEX PL/SQL APIs etc.)

BUSINESS BENEFIT When using ADB's built-in Data Transforms tool, all outbound connections can now be subject to the customer VCN's egress rules. This enhances the overall enterprise-level security model for Autonomous Database.


 

 FREE APP STORE FOR AUTONOMOUS DATABASE ON GITHUB

OVERVIEW The free Github-based ADB App Store is an application launchpad for pre-built applications. Using the ADB App Store, tenants can install and manage the life cycle of these applications. Currently, the Github-based ADB App Store contains the following applications, which are free to use:

  • ADB Cost-Usage Management Analytics app
  • Monitor and manage OCI resource consumption and cost
  • Workload Analytics & Reports (WAR) app
  • Data analysis and visualization tool for Automatic Workload Repository
  • Visual Data Studio
  • Visualization tool for analytics data

NOTE: Applications within the Github-based App store are not supported by Oracle Support. Support for these apps is provided via the usual GitHub issue-tracking process and the usual caveats regarding fixes. .

Screenshot for ADB App Store home page

 

LEARN MORE

APP STORE: Visit the ADB App Store home page and review the setup instructions, click hereVIDEO: How to set up the Oracle Autonomous Database App Store, click here.


 

FREE APP TO HELP MONITOR CLOUD INFRASTRUCTURE COSTS AND USAGE

OVERVIEW Many customers want an easy way to determine what resources are being used. How much do those resources cost, how are they being used, how to optimize costs using lower-cost resources, how do the OCI resource consumption and cost compare to similar resource costs in AWS, can resources be consolidated, are there any orphaned resources, and, who owns what and why?

 

Home page for ADB App Store on GitHub

 

BUSINESS BENEFIT This free application helps customers answer the typical questions listed above. The application is easy to install and is easy to use. The application analyzes cloud resource consumption and reports daily billed usage, actual resource consumption (cpu, io, network, memory), and daily costs measured against a defined budget.

LEARN MORE

BLOG: Manage Your Oracle Cloud Infrastructure Cost and Usage, click hereVIDEO: Try the Oracle Autonomous Database App Store! Install the OCI Cost & Usage Application, click here.

NOTE: this free application not supported by Oracle Support. Support for the app is provided via the usual GitHub issue-tracking process and the usual caveats regarding fixes.


 

GLOBAL LEADERS PROGRAM

STRATEGIC CUSTOMER PROGRAM FOR AUTONOMOUS DATABASE

HELPING YOU GET MORE FROM AUTONOMOUS DATABASE

The Oracle Strategic Customer Program for Autonomous Database on Shared Exadata Infrastructure 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 the Global Leaders team directly: click here for more information.


FREE 1-DAY AI WORKSHOP FOR ARCHITECTS AND PRACTITIONERS

Free 1 day AI workshop from our Global Leaders Team

Workshop to learn more about Oracle's self-service modern data platform architecture.

Join us to learn the details of the self-service modern data platform architecture: Autonomous Database (ADB), Data Studio capabilities for load, transform, insights, machine learning, and AI, and hear about proven customer implementations. The Oracle Autonomous Database Product Management team invites you to this exclusive workshop to learn about the ease of achieving insights using the Oracle Modern Data Platform architecture. Learn about Oracle’s modern data platform architecture, our cloud products, and services to quickly achieve data insights using ADB, its tools, and inbuilt Oracle Machine Learning. Further, learn about real implementations from these practitioners, who have guided customers worldwide on their journeys, and get details on the latest features and announcements. The agenda for the workshop is as follows:

  • The modern data platform architecture
  • ADB overview (behind the curtains)
  • From Data Studio to Data Science and AI demo
  • ADB New Features Highlights (last 6-12 months)
  • ADB Best Practices (Getting the most from your ADB)
  • Modern Data Platform and ADB In-practice (Use-cases)

 

NEXT STEPS

The workshops will run in Chicago, New York, San Francisco, and Toronto in the coming months. For more information, including details on registering, click here.


 

ORACLE GLOBAL LEADERS WORLDWIDE MEETING 2023

Oracle Cloud World Las Vegas

Thursday, September 21, 2023 (last day of CloudWorld) at the Ghostbar in the Palms Resort Hotel

You are invited to share the registration link for our 2023 Oracle Global Leaders Cloud World event, which will take place on Thursday, September 21, 2023 on the last day of CloudWorld at the Ghostbar, in the Palms Resort. For the first time, we will live stream and record the Feedback Panel at the end of the event. The panel will feature Cetin, Juan, and Andy. The live stream Zoom registration link is available via the event agenda page - link below. You can also share the live stream reg link with customers and partners you know who may be interested in the feedback section (all registrations monitored)! We are looking forward to seeing you and your customers at CloudWorld.

NEXT STEPS

Use the following event registration link to register for the CloudWorld meeting: click here

Use the following link to register for the live stream event if you cannot attend the Thursday event at Cloud World, click here.


 

EMEA ORACLE GLOBAL LEADERS MEETING PORTO

29 - 30 November 2023 | 9:00 AM - 5:00 PM | Hilton Porto Gaia, Porto

A unique and interactive event for Oracle Customers using Oracle Data Management Products and Services to share the details of their success, illustrate new and planned ideas as well as inspire innovative applications and powerful use-cases. All this, and a brief update on Oracle Data Management Strategy and Roadmap from Oracle Product Management.

NEXT STEPS

Use the following event registration link to register for this event - click here.

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

Oracle Autonomous Database named a Leader in The Forrester Wave™: Cloud Data Warehouses, Q2 2023

Keith Laker | 7 min read

Next Post


Essbase 21.5.2.0.0 On Premise and 21.5.2.0.1 Marketplace is available

Tanya Heise | 1 min read
Everything you need to know about data warehousing with the world's leading cloud solution provider