Infrastructure at your Service
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…
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….
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…
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…
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…
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…
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…
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>…
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…
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…
