Cloud, Database Administration & Monitoring, Oracle A Serverless Standby Database called Oracle Autonomous Data Guard 16.07.2020 by Oracle Team 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(…)
AWS, Cloud, Database Administration & Monitoring, Database management, DevOps DBPod – le podcast Bases de Données 14.07.2020 by Oracle Team By Franck Pachot . J’essaie quelque chose de nouveau. Je publie beaucoup en anglais (blog, articles, présentations) mais cette fois quelque chose de 100% francophone. En sortant du confinement, on reprend les transports (train, voiture,…) et c’est l’occasion de(…)
Cloud, Database Administration & Monitoring, Oracle Oracle Autonomous Linux: cron’d ksplice and yum updates 30.06.2020 by Oracle Team 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(…)
Cloud, Database Administration & Monitoring, Database management, Hardware & Storage, Operating systems Oracle Cloud basics for beginners 25.06.2020 by Jérôme Dubar 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(…)
Cloud, Oracle Oracle non-linguistic varchar2 columns to order by without sorting 16.06.2020 by Oracle Team By Franck Pachot . Sorting data is an expensive operation and many queries declare an ORDER BY. To avoid the sort operation you can build an index as it maintains a sorted structure. This helps with Top-N queries as(…)
Cloud, Oracle No{Join,GroupBy}SQL – Analytic Views for BI 14.06.2020 by Open source Team By Franck Pachot . Advocates of NoSQL can query their structures without having to read a data model first. And without writing long table join clauses. They store and query a hierarchical structure without the need to follow relationships,(…)
Cloud, Database Administration & Monitoring, Oracle Oracle 12c – global partial index 10.06.2020 by Oracle Team 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(…)
Cloud, Database Administration & Monitoring, Oracle Oracle 12c – reorg and split table with clustering 10.06.2020 by Oracle Team 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(…)
Cloud, Database Administration & Monitoring, Oracle Oracle 12c – peak detection with MATCH_RECOGNIZE 08.06.2020 by Oracle Team 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”(…)
Cloud, Database Administration & Monitoring, Oracle Oracle 12c – pre-built join index 05.06.2020 by Oracle Team 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(…)