Infrastructure at your Service

Category

Development & Performance

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
Jérôme Dubar

Terraform and Oracle Cloud Infrastructure

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

Introduction When you learn a cloud technology, like OCI, the one from Oracle, you start building your demo infrastructure with the web interface and numerous clicks. It’s convenient and easy to handle, even more if you’re quite used to infrastructure basics: network, routing, firewalling, servers, etc. But when it comes to build complex infrastructures with multiple servers, subnets, rules, databases, it’s more than a few clicks to do. And rebuilding a clone infrastructure (for example…

Read More
Franck Pachot

Refactoring procedural to SQL – an example with MySQL Sakila

By | Development & Performance | 4 Comments

By Franck Pachot What I want to show in this blog post is that, as in mathematics where you have to apply some algebra rules to transform an equation to an equivalent one, the database developer must translate the business specification to an equivalent that is optimized (in performance, reliability and readability) for the data model. I was looking at the Sakila sample database provided with MySQL. It simulates a DVD rental store. For my…

Read More
Jérôme Dubar

Make Oracle database simple again!

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

Introduction Let’s have a look at how to make Oracle database as simple as it was before. Oracle database is a great piece of software, yes it’s quite expensive, but it’s still the reference and most of the companies can find a configuration that fits their needs according to a budget. Another complain about Oracle is the complexity: nothing is really simple, and you’ll need skillful DBA(s) to deploy, manage, upgrade, troubleshoot your databases. But…

Read More
Arnaud Berbier

DevOps World – Jenkins World – The Workshop On Day One

By | Application integration & Middleware, Development & Performance, DevOps, Docker, Kubernetes | No Comments

After achieving new challenges during customer activities where I was managing a quite huge project around Kubernetes & Jenkins X EcoSystem, I get the opportunity to attend the DevOps World – Jenkins World in Lisbon.A big thanks as I will better understand all the superheroes in this Jenkins World.The superheroes for me this year is Jenkins X !Today was the 1st day with a dedicated workshop for about ~ 7 hours covering all the important…

Read More
Stéphane Haby

SQL Server 2019: Java in SQL Server hard to believe, no?

By | Development & Performance, DevOps, SQL Server, Technology Survey | One Comment

It has already been a few months that we are testing the next version of SQL Server: SQL Server 2019. I already blogged about a previous version of SQL Server supporting R and Python. With the new version of SQL Server 2019, Java will also be integrated. The Java runtime used is Zulu Open JRE and can be tested from the CTP3.2 of SQL Server 2019 Step 1: The installation Like a lot of people,…

Read More