Database Administration & Monitoring

Oracle Cloud basics for beginners

Introduction Cloud, Cloud, Cloud. Everyone is talking about the Cloud but a lot of people are still in the fog with Cloud technologies. Let’s talk about basic features of the Oracle Cloud, called OCI for Oracle Cloud Infrastructure. What is(…)

Attaching your own CentOS 7 yum repository to AWS SSM

From some blogs I've written in the past you might already know that we are using AWS SSM to patch and maintain the complete EC2 and onprem instances at one of our customers. The previous posts(…)

The Oracle ACE program ♠ what it is not ♠

By Franck Pachot . I had a few questions about the Oracle ACE program recently and I thought about putting some answers there. Of course, that’s only my point of view, there’s an official web page:(…)

Control-M/EM Put a job already ordered in dummy mode

Hi everybody. Today we will see how to put a job in dummy mode on the monitoring part Introduction In some case you want, or you will be asked to bypass a treatment. For that, you can put the job(…)

Control-M/EM Cyclic job interval less than 1 min

Introduction By default, the minimal execution’s interval of a cyclic job is 1 minute (with the rerun every 0 sec option it will loop instantaneously). But what happens when you need to rerun it in a interval between 0 and(…)

Oracle 12c – global partial index

By Franck Pachot . We have an incredible number of possibilities with Oracle. Yes, an index can be global (indexing many partitions without having to be partitioned itself on the same key) and partial (skipping some of the table(…)

Oracle 12c – reorg and split table with clustering

By Franck Pachot . In this series of small examples on recent features, I have imported in a previous post, the statistics of covid-19 per day and per countries. This is typical of data that(…)

Oracle 12c – peak detection with MATCH_RECOGNIZE

By Franck Pachot . This post is part of a series of small examples of recent features. I’m running this in the Oracle 20c preview in the Oracle Cloud. I’ll show a very basic example of “Row Pattern Recognition”(…)

Oracle 12c – pre-built join index

By Franck Pachot . This post is part of a series of small examples of recent features. I’m running this in the Oracle 20c preview in the Oracle Cloud. I have created a few tables in the(…)

What is a serverless database?

By Franck Pachot . After reading the https://cloudwars.co/oracle/oracle-deal-8×8-larry-ellison-picks-amazons-pocket-again/ paper, I am writing some thoughts about how a database can be serverless and elastic. Of course, a database needs a server to process its data. Serverless(…)