Infrastructure at your Service

Category

Development & Performance

Nicolas Penot

Ansible Custom Interactive Dynamic Inventory

By | Cloud, Development & Performance, Entreprise content management | No Comments

When working with an Ansible dynamic inventory, you may want to update it from your playbook on the fly. For instance, you may want to create a server and then install an application on it without calling a second playbook or developing specific code to create a runtime group (e.g. “add_host” module). Or you may want to update the inventory on the fly without having to wait for an asynchronous mechanism to be triggered. This…

Read More
Jérôme Dubar

Oracle Database Appliance vs Oracle Cloud Infrastructure

By | Cloud, Database Administration & Monitoring, Database management, Development & Performance, Hardware & Storage, Operation systems, Oracle | No Comments

Introduction Oracle Database Appliances are very popular these days. And not only among new customers for this kind of engineered systems. Almost all customers already using old generation ODAs are renewing their infrastructure by choosing again ODAs, meaning that the solution is good enough and probably better than anything else. But now, public clouds are a real alternative to on-premise servers, and Oracle Cloud Infrastructure is a solid competitor vs Amazon and Azure public clouds….

Read More
Jérôme Dubar

Boost your CPU speed with Standard Edition 2 on ODA

By | Database Administration & Monitoring, Database management, Development & Performance, Hardware & Storage, Operation systems, Oracle | No Comments

Introduction There is no need to decrease the number of cores on your ODA when using Standard Edition 2, because your license is based on the number of physical CPU. So why would you do that? Obviously, the more cores you have, the more performance you should get. But that simply isn’t always true. Base CPU speed and Turbo Boost If you didn’t read my previous blog, please do so to understand how Xeon processors…

Read More
Jérôme Dubar

Oracle Database Appliance and CPU speed

By | Database Administration & Monitoring, Development & Performance, Hardware & Storage, Operation systems, Oracle | No Comments

Introduction A complaint I heard from customers about ODA is the low core speed of the Intel Xeon processor embedded in the X8-2 servers: Intel(R) Xeon(R) Gold 5218 CPU @ 2.30GHz. 2.30GHz only? Because of its comfortable number of cores (16 per processor), the cruise speed of each core is limited. Is it a problem compared to a home made server with less cores? Why clock speed is important? As you may now, the faster…

Read More
Nicolas Penot

Git collaboration: quick start

By | Development & Performance | No Comments

Git collaboration: quick start If you want to keep the git repository of your project clean and predictive (which is highly recommendable), here is a simple workflow to follow. For the sake of this article, we are going to join the MongoDB project. First step: work safely on your branch When joining the project, the first step to get a local copy in your laptop: $ cd my_working_directory $ git clone [email protected]:nico/mongo.git Once you do…

Read More
Franck Pachot

DBPod – le podcast Bases de Données

By | AWS, Cloud, Database Administration & Monitoring, Database management, Development & Performance, DevOps, NoSQL, Oracle, Postgres, SQL Server | No Comments

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 se détendre en musique mais aussi de s’informer avec des podcasts. J’ai l’impression que c’est un format qui a de l’avenir: moins contraignant que regarder une video ou ou lire un article ou une newsletter. Alors…

Read More
Lazhar Felahi

How to use DBMS_SCHEDULER to improve performance ?

By | Database Administration & Monitoring, Development & Performance, Oracle | 3 Comments

From an application point of view, the oracle scheduler DBMS_SCHEDULER allows to reach best performance by parallelizing your process. Let’s start with the following PL/SQL code inserting in serial several rows from a metadata table to a target table. In my example, the metadata table does not contain “directly” the data but a set a of sql statement to be executed and for which the rows returned must be inserted into the target table My_Target_Table_Serial…

Read More
Lazhar Felahi

Oracle Text : Using and Indexing – the CONTEXT Index

By | Database Administration & Monitoring, Development & Performance, Oracle | 2 Comments

Everybody has already faced performance problem with oracle CLOB columns. The aim of this blog is to show you (always from a real user case) how to use one of Oracle Text Indexes (CONTEXT index) to solve performance problem with CLOB column. The oracle text complete documentation is here : Text Application Developer’s Guide Let’s start with the following SQL query which take more than 6.18 minutes to execute : SQL> set timing on SQL>…

Read More
Alain Lacour

APEX Connect 2020 – Day 2

By | Application integration & Middleware, Development & Performance, Oracle | No Comments

For the second and last virtual conference day, I decided to attend presentations on following topics: – Universal Theme new features – Oracle APEX Source Code Management and Release Lifecycle – Why Google Hates My APEX App – We ain’t got no time! Pragmatic testing with utPLSQL – Why APEX developers should know FLASHBACK – ORDS – Behind the scenes … and more! and the day ended with a keynote from Kellyn Pot’Vin-Gorman about “Becoming…

Read More
Alain Lacour

APEX Connect 2020 – Day 1

By | Development & Performance, Oracle | No Comments

This year the APEX connect conference goes virtual online, like all other major IT events, due to the pandemic. Unfortunately it spans only over two days with mixed topics around APEX, like JavaScript, PL/SQL and much more. After the welcome speech and the very interesting Keynote about “APEX 20.1 and beyond: News from APEX Development” by Carsten Czarski, I decided to attend presentations on following topics: – The Basics of Deep Learning – “Make it…

Read More