Oracle’s Always Free Autonomous Database and Cloud Infrastructure

Yesterday Larry Ellison announced in his keynote during the Oracle Open World 2019 the "Always Free Autonomous Database and Cloud Infrastructure". For more details about it see:

In short terms, you get a full environment with:
  • 2 Always Free Databases
  • Up to 1 OCPU and 20GB of Storage for each Database
  • SQL Developer Web-based
  • APEX
  • Automatic REST
  • SQL Notebooks for Machine Learning
  • 1 (more...)
  • ADW – Loading data using Object Storage

    There are a number of different ways to load data into your Autonomous Data Warehouse (ADW) environment. I’ll have posts about these alternatives.

    In this blog post I’ll go through the steps needed to load data using Object Storage. This might appear to have a large-ish number of steps, but once you have gone through it and have some of the parts already setup and configuration from your first time, then the second and subsequent (more...)

    Where is My Money Going? Checking the balance with Oracle Cloud Account Metering REST APIs

    Where is My Money Going? Checking the balance with Oracle Cloud Account Metering REST APIs
    How much did I spend so far?
    Where is My Money Going? Checking the balance with Oracle Cloud Account Metering REST APIs

    It's a typical question we ask ourselves daily and what do we do? Probably check the bank account status on our phone and yell at ourselves for all the money we trashed the previous night at the pub.

    The Cloud

    One of the great benefits of the cloud is that there is no big upfront cost required to start playing with the latest tool or technology, we just (more...)

    Oracle ADW how to loading new OML notebooks

    Oracle Autonomous Database (ADW) has been out a while now and have had several, behind the scenes, improvements and new/additional features added.

    If you have used the Oracle Machine Learning (OML) component of ADW you will have seen the various sample OML Notebooks that come pre-loaded. These are easy to open, use and to try out the various OML features.

    Screenshot 2019-07-29 13.07.01

    The above image shows the top part of the login screen for OML. To see (more...)

    GoLang: Inserting records into Oracle Database using goracle

    In this blog post I’ll give some examples of how to process data for inserting into a table in an Oracle Database. I’ve had some previous blog posts on how to setup and connecting to an Oracle Database, and another on retrieving data from an Oracle Database and the importance of setting the Array Fetch Size.

    When manipulating data the statements can be grouped (generally) into creating new data and updating existing data.

    When (more...)

    GoLang: Querying records from Oracle Database using goracle

    Continuing my series of blog posts on using Go Lang with Oracle, in this blog I’ll look at how to setup a query, run the query and parse the query results. I’ll give some examples that include setting up the query as a prepared statement and how to run a query and retrieve the first record returned. Another version of this last example is a query that returns one row.

    Check out my previous post (more...)

    Importance of setting Fetched Rows size for Database Query using Golang

    When issuing queries to the database one of the challenges every developer faces is how to get the results quickly. If your queries are only returning a small number of records, eg. < 5, then you don’t really have to worry about execution time. That is unless your query is performing some complex processing, joining lots of tables, etc.

    Most of the time developers are working with one or a small number of records, using (more...)

    Oracle and Microsoft to Interconnect Oracle Cloud and Microsoft Azure

    On the 5th of June 2019, both Oracle and Microsoft made a joint announcement on the interconnection between Oracle Cloud and Microsoft Azure:

    Oracle’s Press Release
    Microsoft Press Release

    The key aspects of the announcement are:

    1. A direct interconnect between Oracle Cloud and Azure Cloud, starting in Ashburn (North America) and Azure US East, with plans to expand additional regions in the future.
    2. Unified identity and access management, via a unified single sign-on experience (more...)

    Oracle Linux hangs after “probing EDD” in Oracle Cloud

    Just short note: If your imported Oracle Linux image hangs on boot in the Oracle cloud, just set GRUB_DISABLE_UUID=”true” in /etc/default/grub

    Observations About the Scalability of Data Loads in ADWC

    In the last days, I am running a number of tests based on the TPC-DS benchmark against Oracle’s Autonomous Data Warehouse Cloud service (ADWC). One of the first thing I did is of course to create the TPC-DS schema and populate it. The aim of this blog post is to share some observations related to the population step.

    I started by generating the data with the tool provided by TPC-DS: dsdgen. With the following command, (more...)

    Which Privileges Are Required to Use the ADWC Service Console?

    The Autonomous Data Warehouse Cloud (ADWC) service provides a Service Console that can be used to monitor the service activity and to carry out a small number of administration tasks (e.g. changing some resource management rules).

    The documentation specifically says to use the ADMIN user to login. But, actually, any unlocked database user having the CREATE SESSION privilege can be used to login. This is not only useful, but, in my opinion, necessary. In (more...)

    DBMS_CLOUD Package – A Reference Guide

    The Appendix A of the Using Oracle Autonomous Data Warehouse Cloud guide describes the DBMS_CLOUD package. Unfortunately, it documents only a subset of the subroutines. And, for some of them, the description could also be enhanced. Therefore, while I was testing all the subroutines the DBMS_CLOUD package provides, I took a number of notes. By the end of my tests, I got what I can call my personal reference guide to the package. Since it (more...)

    Jarvis Pizzeria: Custom Reports & Dashboards

    | Jun 3, 2018
    In our previous blog we showed the out of the box functionality of Dashboard & Reporting. Next to the default dashboards, you can also create your own custom dashboards. However, before we can create dashboards on this, we need to set up some indicators within our application. In the composer we have to go to the tab Indicators.

    There are three types of indicators that you can create here:
    - A Dimension represents the grouping (more...)

    Jarvis Pizzeria: Business Reports & Dashboards

    | May 28, 2018
    Within the workspace there are some out of the box dashboards that you can use to monitor your instance. When you go to My Tasks and click Dashboard, by default the Health dashboard is shown.
    There are a total of 5 default dashboards, Health, Open, Workload, Trend & Closed. You can use the filters on the right hand side to filter the dashboard.

    The health dashboard will give you an instant, real-time view of the (more...)

    Playing with ADWC (Autonomous Data Warehouse Cloud Service)

    Oracle has launched Oracle 18c and the Autonomous Data Warehouse Cloud Service (ADWC). Many people call the Oracle 18c as the Autonomous database, and this is a huge mistake! Oracle 18c (that is in reality Oracle is not an

    Playing with Oracle Ravello – Migrating your VMs to the Cloud

    Hello everyone, A few years back we had the boom of the “Private Cloud” rush, where everyone started to implement virtualization technologies to make a better use of it Infrastructure resources and improve high availability, scalability and innovation! Now to

    The Forgotten Link To The Cloud

    (Note: This article was also published at – Last year when presenting a session at Collaborate’17 in Las Vegas regarding Tips and Best Practices for DBAs, I went thru the evolution of the DBA profession and also gave

    Jarvis Pizzeria: Aborting a Process

    | Apr 17, 2018
    In this blog entry, we will take a look at the way a dynamic process deals with a process that ends with an exception. We will implement this in our “Register Order” process.

    We modeled the process as depicted below:

    When saved, published and activated, we start a new dynamic process; of course through our famous form:

    The expectation is that Register Order starts and that we can start executing the task. When we open (more...)

    Playing with Oracle Cloud – Creating a Hybrid DR Deployment

    On this article, we will create a Hybrid Disaster Recovery (DR by using Data Guard) Oracle Database Cloud Service database deployment with a primary database on-premises and a standby database in the cloud. This can be used to implement an improve the high

    Playing with Oracle Database Cloud – Migrating to Cloud using an Oracle Cloud Backup

    The idea for this scenario is to learn how to migrate an Oracle Database from on-premises to Oracle Cloud DBaaS by using a previously done backup using Oracle Cloud Backup Services. First, we will create an Oracle Database Cloud Services database