Infrastructure at your Service

Category

Database Administration & Monitoring

Daniel Westermann

Attaching your own CentOS 7 yum repository to AWS SSM

By | AWS, Database Administration & Monitoring | No Comments

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 about that topic are here: Avoiding patching madness by using AWS SSM Avoiding patching madness by using AWS SSM A simple Terraform script to create an AWS EC2 playground Schedule reboots of your AWS instances and how that can…

Read More
Franck Pachot

The Oracle ACE program ♠ what it is not ♠

By | Database Administration & Monitoring | 4 Comments

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: https://www.oracle.com/technetwork/community/oracle-ace/index.html The program is flexible and open, with a large diversity of people, technologies, contributions, levels,… Then rather than explaining what it is, which would be limiting, I’ll rather tell you… what it is not. It is not a…

Read More
Nabil Saoual

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

By | Database Administration & Monitoring | No Comments

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 in dummy mode. But how can we proceed if this request is needed for a job already ordered and ready to be executed? Example: You made a manual backup and the same task is usually…

Read More
Nabil Saoual

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

By | Database Administration & Monitoring | No Comments

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 1 minute?   Let’s use a little trick to achieve that:   1)Job configuration   In planning pane create a job When selecting this job, go in “scheduling” tab part and tick the “cyclic” box:…

Read More
Franck Pachot

Oracle 12c – global partial index

By | Cloud, Database Administration & Monitoring, Oracle | No Comments

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 partitions where we don’t need indexing). In the previous post of this series of small examples on recent features I partitioned a table, with covid-19 cases per day and per country, partitioned on range of date…

Read More
Franck Pachot

Oracle 12c – reorg and split table with clustering

By | Cloud, Database Administration & Monitoring, Oracle | 2 Comments

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 comes as a time-series ordered by date, because this is how it is generated day after day, but where you probably want to query from another dimension, like per countries. If you want to ingest data faster, you keep it…

Read More
Franck Pachot

Oracle 12c – peak detection with MATCH_RECOGNIZE

By | Cloud, Database Administration & Monitoring, Oracle | 2 Comments

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” (the MATCH_RECOGNIZE clause in a SELECT which is documented as “row pattern matching in native SQL” feature by Oracle”). You may be afraid of those names. Of course, because SQL is a declarative language there is…

Read More
Franck Pachot

Oracle 12c – pre-built join index

By | Cloud, Database Administration & Monitoring, Oracle | No Comments

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 previous post with a mini-snowflake scheme: a fact table CASES with the covid-19 cases per country and day. And a dimension hierarchy for the country with COUNTRIES and CONTINENTS tables. This title may look strange for people used…

Read More
Franck Pachot

What is a serverless database?

By | AWS, Cloud, Database Administration & Monitoring, Oracle | No Comments

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 doesn’t mean that there are no servers. Serverless as not waiting for server provisioning The first idea of “serverless” is about provisioning. In the past when a developer required a new database to start a new project she had to…

Read More
Christophe Cosme

AWS – RDS – SQL Server Native backups

By | AWS, Cloud, Database Administration & Monitoring, Database management, SQL Server | No Comments

Introduction RDS provide automatic backup feature. This feature will backup the entire RDS instance. As a DBA sometimes you need to backup individual database, they are many reason for that (legal, migration, replication,…). Unfortunately individual database backups are not available within the RDS instance. This post explains how you can enable the native database backup on RDS , as you are used to with an on-premises SQL Server instance. To summarize we will create a…

Read More