Autonomous

An overview of “Oracle Cloud Infrastructure: everything for an efficient migration” event by dbi services

Is the Oracle Cloud a hot topic for you? dbi services organized an event about the Cloud today in Lausanne: "Oracle Cloud Infrastructure: everything for an efficient migration".

First contact with OCI’s Autonomous Database

Introduction Benefits of going into the Oracle Cloud (OCI) are clear for most of us: no more datacenter and hardware to manage. But what else? On OCI, you can also decide to get rid of part of the DBA tasks(…)

Recovery in the ☁ with Oracle Autonomous Database

By Franck Pachot . I’ll start this series with the Oracle Autonomous database but my goal is to cover the Point In Time recovery for many managed databases in the major cloud providers. Because I’ve seen lot of confusion(…)

Troubleshooting performance on Autonomous Database

By Franck Pachot . On my Oracle Cloud Free Tier Autonomous Transaction Processing service, a database that can be used for free with no time limit, I have seen this strange activity. As I’m running nothing(…)

The myth of NoSQL (vs. RDBMS) “a simpler API to bound resources”

By Franck Pachot . NoSQL provides an API that is much simpler than SQL. And one advantage of it is that users cannot exceed a defined amount of resources in one call. You can read this in(…)

A Serverless Standby Database called Oracle Autonomous Data Guard

By Franck Pachot . Announced by Larry Ellison last week, here it is: the Autonomous Data Guard. You can try it, unfortunately not on the Free Tier. First you create an Autonomous Database (ATP or ADW) and then(…)

Oracle Autonomous Linux: cron’d ksplice and yum updates

By Franck Pachot . Oracle Enterprise Linux (OEL) is a Linux distribution which is binary compatible with Red Hat Enterprise Linux (RHEL). However, unlike RHEL, OEL is open source, free to download, free to use, free to distribute, free(…)

ATP vs ADW – the Autonomous Database lockdown profiles

By Franck Pachot . The Oracle database has always distinguished two types of workloads: transactional (OLTP) and datawarehouse (VLDB, DWH, DSS, BI, analytics). There is the same idea in the managed Oracle Cloud with two autonomous database services.

ADWC – System and session settings (DWCS lockdown profile)

By Franck Pachot . The Autonomous Data Warehouse Cloud service is a PaaS managed service where we have a PDB and an ADMIN user which has most of the system privileges. For example, we have the privilege to change initialization(…)

ADWC – connect from your premises

By Franck Pachot . In the previous post about the Autonomous Data Warehouse Service, I've run queries though the Machine Learning Notebooks. But you obviously want to connect to it from your premises, with SQL*Net.