OpenWorld 2019 Wrap Up

I can’t believe Oracle Open World is done for another year.

But what a great conference it was for those interested in the Oracle Database. We saw the introduction of Oracle Database 20c and of course the continuing evolution of the Oracle Autonomous Database with details on new deployment option (Dedicated) and new flavors (Document Store).

If you weren’t able to make it to OOW in person, don’t panic as a lot of the session presentations are now available for download in the OOW session catalog. You can download the slides by clicking the down arrow on the right-hand side of each session title as shown below.

Alternatively, you can check out the video playlist below which provides you with a great technical introduction to the Next generation Oracle Database and how we see it changing the way we develop and deploy applications.

Posted in Events, OOW | Tagged , , | Leave a comment

FREE Oracle Autonomous Database

Today was the first day of Oracle Open World and during Larry Ellison’s afternoon keynote he made a number of extremely exciting announcements around Oracle Autonomous Database including the launch of an Always Free Tier for Developers and students in the Oracle Cloud.  Larry said, “as long as you use the service, it will be there, free forever.”

So what’s included?

Along with compute and storage services, you also get access to 2 Autonomous Database with 20GB of storage each absolutely free. So you can try out both an Autonomous Data Warehouse and an Autonomous Transaction Processing system.

Larry also announced Oracle Autonomous Database Dedicated Deployment, which is aimed at folks who are looking to rethinking Database I.T. by providing them a private Database cloud on the Oracle public Cloud.



Juan Loaiza also gave a great detailed session on Oracle Autonomous Database Dedicated where he explained that just like Autonomous Database Serverless, you can run both transaction processing and data warehousing workloads. Where this new offering differs is in the deployment.

With dedicated, you get your own isolated Exadata Infrastructure, within a hardware enforced Virtual Cloud Network. Making it fully isolated from all other cloud tenants.

On that dedicated Exadata rack you can create multiple container databases, with one or more pluggable databases. With each pluggable database being an Autonomous Database, just as you would expect from the original serverless deployment.

Given you are the only customer on this dedicated Exadata infrastructure, you can customizable the policies used to manage the Autonomous Database Dedicated, if you wish.

You can customize the patching policy, selecting when the system is updated. This allows you to avoid updates during peak periods and gives you the opportunity to deploy new versions on test/dev database before production.

You can also separate databases by organization (sales, HR, marketing)
criticality or purpose (dev,test or production) by creating multiple container databases, which can have different levels of HA and or DR.

One of the key advantages you get by using Oracle Autonomous Database Dedicate is the automatic workload optimization, including Automatic Indexing. Juan mentioned that SAP recently tested it and automatic indexing added a handful of additional indexes to those defined by SAP out of the box and they saw a 10% improvements in performance. So it can help you define the right indexes for new applications or  help keep your existing application performant.

Hopefully now with the free tier, even more people can experience how easy, fast, and elastic the Oracle Autonomous Database really is!

Posted in Autonomous Database, OOW | Tagged , | Leave a comment

Are you ready for Oracle OpenWorld 2019?

With less than a week to go until Oracle Open World kicks off, I thought I would share with you what you can expect.

Of course the whole Database team will be there and you will have multiple opportunities to meet up with us, in one of our technical sessions, our hands-on-labs or at the Oracle demogrounds.

Below are just some of the session I thought might be interesting to help get you started:

  • Monday, September 16th at 12:15pm 100% Oracle Cloud: Registering 90,000 People for CERN Open Days
    Session CON3040 at Moscone West – room 3007A
    In this session Eric Grancher and Viktor Kozlovszky explain how CERN used the Oracle Autonomous Database to host the registration application for their open days at CERN (European laboratory for particle physics), which attract tens of thousands of people from countries all across in Europe and beyond.
  • Monday, September 16th at 4:45pm Rethink Database IT with Autonomous Database Dedicated
    Session PRO4660 at Moscone South – room 215/216
    Juan Loaiza reveals what motivated Oracle to develop Autonomous Database Dedicate and provides a clear understanding of how this cloud services works and how you can expect it to change the wait you interact with the Database.
  • Tuesday, September 17th at 11:15am  Oracle Autonomous Database: Looking Under the Hood
    Session TRN4728 at Moscone South – room 215/216
    Yasin Baskan will provide an insiders view to the technology underlying Oracle Autonomous Database  and give you a guided tour of getting started with the Oracle Autonomous Database.
  • Tuesday, September 17th at 11:30am Cloud Native Data Management
    Session Dev4677 at Moscone South – room 301
    What if you didn’t have to worry about how to structure data? What if you could store data in any format, independent of having to know if a cloud service could handle it? What if performance, web-scale, or security concerns no longer held you back when you were writing or deploying apps? Sound like a fantasy? Then come join Gerald Venzl and I as we shows you how to combine the power of microservices with the agility of cloud native data management to make this fantasy a reality.
  • Tuesday, September 17th at 1:30pm Database Trends: The Good, The Bad and The Ugly
    Session GEN4643 at Moscone South – room 207/208
    Juan Loaiza will share his candid assessment of the latest database trends including microservices, IoT, Kubernetes, machine learning, blockchain, JSON, big data, cloud, Kafka, autonomous, sharding and lets you know which you should adopt and which you should avoid.
  • Tuesday, September 17th at 2:30pm Oracle Code One Keynote
    Session KEY6320 at Moscone North – Hall F
    In this years Code One Keynote Todd Sharp, Greg Pavlik and I will explain how a smart app using machine learning and data from multiple sources can help Todd’s 13 year old, recently diagnosed with diabetes, easily calculate her carbohydrate consumption to help her determine her next insulin dose.

Check out the full searchable OOW catalog on-line to start planning your trip today!

Posted in Autonomous Database, Events, OOW | Tagged | Leave a comment

Can I use an Autonomous Database to develop new applications?

Yes, Oracle Autonomous Database (ADB) is the ideal platform for new application development.

With this family of cloud services, developers no longer have to wait on others to provision hardware, install software, and create a database for them. With ADB, developers can easily and instantly deploy an Oracle database without worrying about having to manual tune it or capacity planning. This allows developers to start developing in minutes and concentrate on solving business problems without all of the usual distractions.

ADB has the most advanced SQL and PL/SQL support accelerating developer productivity by minimizing the amount of application code required to implement complex business logic. It also has a complete set of integrated Machine Learning algorithms, simplifying the development of applications that perform real-time predictions such as personalized shopping recommendations, customer churn rates, and fraud detection.

What Development Tools should I use with ATP?

As soon as you have provisioned an ADB instance you have access to all of the great features of SQL Developer without having to download any additional software. Each ADB instance comes with its own SQL Developer Web (SQLDev Web).  SQLDev Web provides developers with a worksheet for running queries and scripts, dialogs for creating and editing object, a DBA console for managing the database, and data modeling features.

You can access SQLDev Web via the service console as shown in the video below.

For more information on using SQLDev Web with ADB check out Jeff Smith’s (Master Product Manager for all things SQL Developer and ORDS) recent blog post.

Oracle Application Express (APEX), a low code development framework is also pre-configured, and ready to go out of the box, with ADB.  APEX enables you to design, develop and deploy database-driven applications using only your web browser.

This easy ­to ­use development environment enables developers to quickly load data, manage database objects, develop REST interfaces, and build applications which look and run great on both desktop and mobile devices. Much of the development process is managed for you: security, authentication, database interactions, input validation, session state management and many other dependencies work out of the box.

Access to the APEX environment is also available via the service console. Remember the first time you click on APEX you need to login in to the administrators service in order to create a workspace. You can find the administration service by scrolled down to the bottom of the APEX login screen as shown in the video below.


You can get more information on how to connect to ATP from a number of other development environments including Java, NodeJS and Python in Chapter 2 of the ADB documentation

For more information on all developing new applications on ADB check out Jeff Smith’s  YouTube tutorials:

Posted in Autonomous Database, Oracle Database 18c, Oracle Database 19c | Tagged , , , | Leave a comment

Cloning an Oracle Autonomous Database

Often times development and testing teams need a copy of a production database in order to develop or test using a representative dataset. Up until now, creating these cloned  environments has been a challenging and time consuming process for DBAs.

Oracle Autonomous Database makes it extremely easy for a DBA to clone a database in just a few mouse clicks, as I demonstrate in the video below.

When it comes to cloning an Autonomous Database  you have two options:

You can create a new database that is a complete copy of the original database, which includes all metadata (table and view definitions etc.) and all of the actual data. This is referred to as a FULL CLONE.

Or you can create a new database that only contains the metadata from the original database.  This is referred to as METADATA CLONE.

Either way the “cloned” database will have a completely new database name, admin password. It can also have different infrastructure criteria (CPU count and storage) from the original database.

The clone will also not have any of the AWR data  or any of the ML Worksheets from original database.

Of course you don’t need to use the UI every time you want to create a clone. All of the tasks that can be done via the UI can be done using REST APIs or CLI commands.

Continue reading

Posted in Autonomous Database | Tagged , | Leave a comment

Oracle Database 19c is now available!

Today, April 25th, Oracle Database 19c became available to downloaded from

Oracle Database 19c is the final member of the 12.2 family a.k.a and is therefore the ‘long term support’ release. This means it will come with 4 years of premium support and 3 years of extended support. Making this release the version of the database that most folks are going to upgrade to next.

So, what can you expect?

There are hundreds of useful enhancements in Oracle Database 19c as well as a several new features. Dom Giles‘s latest post on the Oracle Database Insider blog has all the details on the new release, while I’ve listed just a couple of my personal favorites below.

Continue reading

Posted in New Features, Oracle Database 19c | Tagged , , | Leave a comment

Oracle RAC on Docker just got simplier

Early this year, I wrote a blog to let you know that Oracle Database RAC was available on Docker.  However, in that blog I described a number of manual steps that were required to rebuild the image before you could start using the RAC database.

I’m now delight to announce that you can simple download a Oracle Database RAC Docker image (under database) from the container registry, which has a pre-installed / pre-built image. Making it easier to have a RAC database for your  demos, development or test environments.


Posted in Docker, RAC | Tagged , | Leave a comment

Oracle Open World Wrap Up

Oracle Open World this year was a crazy busy week catching up with customers, Oracle Aces, Development Champions and partners as we all crammed into the Moscone center to hear the very latest on Oracle Technologies.

For the database, this year’s conferences saw the introduction of Oracle Database 19c and of course the continuing evolution of the Oracle Autonomous Database Cloud Services.

If you weren’t able to make it to OOW in person, don’t panic as a lot of the session presentations are now available for download in the OOW session catalog. You can download the slides by clicking the down arrow in the right hand side of each session title as shown below.

Alternatively you can check out the video below which provides you with a great technical introduction to the Autonomous Database and how it works.

Since 19c is still in beta the slides from those sessions are not available yet but if you are going to the UKOUG Conference in December Dom Giles and I will be giving you a taste of what you can expect from the new release in the Database Keynote session on Monday Dec. 3rd. While Nigel Bayliss and I will also give you a sneak peek of what you can expect from Automatic Indexing.

And of course I’ll have more Autonomous Database stickers to give away!

Posted in Autonomous Database | Tagged | Leave a comment

Day 2 of Open World 2018

Oracle OpenWorld started yesterday and San Francisco is just buzzing with Oracle folks and the excitement generated by the Oracle Autonomous Database.

If you missed Larry Ellison’s keynote yesterday the short video below will service as a good recap!

If you are interested in more information on the Autonomous Database and how it’s changing the roll of the DBA, be sure to check out the following sessions today:

  • An Insider’s Guide to Oracle Autonomous Transaction Processing
    Session TRN3979 at 11:15am in Moscone West – room 3003
    Robert Greene and I will provide an insiders view to the technology underlying Oracle Autonomous Database  and give you a guided tour of getting started with the Oracle Autonomous Transaction Processing.
  • Test Drive Automatic Index Creation in Oracle Autonomous Database Cloud
    Session TRN3980 at 4:45pm in Moscone West – room 3003
    After hearing all about Autonomous Transaction Processing in the morning session, we are sure you will be ready for a deeper dive into the Automatic Indexing capabilities. Mohamed Zait (lead architect on the Optimizer team) and I will explain exactly how Automatic Indexing works and share with you the results of this awesome capability in action.

You can also get your Autonomous Database laptop stickers at either of these sessions!

Posted in OOW | Tagged | Leave a comment

Day 1 Oracle Open World 2018

The biggest day of the Oracle calendar has arrived.

Oracle OpenWorld 2018 officially starts today!

The show kicks off with ton’s of great technical sessions including several great sessions on Oracle Autonomous Database.

  • 9:00 AM – 9:45AM Oracle Exadata: Strategy and Roadmap for New Technologies, Cloud, and On-Premises – session PRM4114 in Moscone West room 3008.
    Kick off your OpenWorld with Juan Loaiza as he provides an overview of current and future Exadata capabilities, which is the underlying infrastructure for our Autonomous Database both in the public cloud, and Oracle Cloud at Customer technologies.
  • 11:00 AM – 12:15 PM Oracle Autonomous Database – session PKN3947  in the Arena in Moscone South.
    In this general session Andy Mendelsohn will shares the latest updates from the Database Development team along with customer reaction to Oracle Autonomous Database.
  • 1:45 PM – 3:00 PM Larry’s keynote in Moscone North – Hall D. A must see, as he is going to share details on Gen 2 Cloud and the Oracle Autonomous Database!
  • 4:45 PM – 5:30 PM Oracle Autonomous Transaction Processing Overview and Roadmap – session PRO3978 in Moscone West room 3003. Finish your afternoon with Juan Loaiza and I as we< explain how our unique Autonomous Database works and illustrates how it can simplify your approach to data management and accelerate your transition to the cloud.

Hope to see ya there!

Posted in OOW | Tagged | Leave a comment