Infrastructure at your Service

All posts by Nicolas Jardot

Nicolas Jardot
Senior Consultant

Nicolas Jardot has more than two years of experience in Oracle database management and Microsoft application development. He is specialized in Oracle tuning as well as in the Oracle Optimizer. Nicolas Jardot perfectly masters the behavior of the Oracle Optimizer, holding speeches on the topic at the Oracle OpenWorld 2013 and the UKOUG 2013. He is also specialized in C++ development and masters the programming of requests in SQL language. Nicolas Jardot has a solid experience in the virtualization and centralization of applications. He has developed several PL/SQL packages aimed to simplify the administration of database applications and maintains the DMK_SQL package of dbi services' Database Management Kit. Nicolas Jardot is Oracle Certified Professional 11g (OCP 11g) and ITIL Foundation V3 certified. Nicolas Jardot holds an Engineer's Degree in Computer Science from the University of Technology of Belfort-Montbéliard (F). His branch-related experience covers Pharma, Public Sector, Health, Real Estate, Automotive, etc.
Nicolas Jardot

DOAG 2017: Automation in progress

By | Database Administration & Monitoring, Oracle | 5 Comments

A week ago, I had the chance to be speaker at the DOAG Konferenz 2017 in Nürnberg. It’s sometimes hard to find time to be at the conferences because the end of year is quite busy at customers. But it’s also important because it’s time for sharing. I can share what I’m working on about automation and patching and I can also see how other people are doing. And it was great for me this…

 
Read More
Nicolas Jardot

How to read XML database alert log?

By | Database Administration & Monitoring | No Comments

Since Oracle 11g, Oracle maintains two copies of the database’s alertlog in ADR: a flat text file in the sub-directory trace and an XML like in the folder alert. I had a case recently at a customer where the log.xml was moved to another place and compressed for archiving reason. As the regular text file was not containing old data, the goal was to exploit the archived XML -like file. When the file is still located…

 
Read More
Nicolas Jardot

AOUG – Real World Performance Tour

By | Database management | No Comments

This week, Tom Kyte, Graham Wood and Andrew Holdsworth were present in Europe for several dates. One of the events was organised by the Austrian Oracle User Group (AOUG) in collaboration with the German and Swiss User Group (DOAG and SOUG) and I had the chance to be there to attend to one session of the Real Worl Performance tour session in Vienna. I think there is no real need to present the Real World…

 
Read More
Nicolas Jardot

Use a wallet to encrypt Oracle client passwords

By | Database management | No Comments

In our more and more connected world, security is a big concern. Storing password is a very important topic because if a machine is compromised, we can assume that any password stored in clear text are also compromised. I had the question from a customer how can we encrypt the password in our application and monitoring scripts? In this blog we will discuss one solution: using the Oracle client wallet We find passwords for Oracle…

 
Read More
Nicolas Jardot

SQL Patch: Another way to change the plan without changing the code

By | Application integration & Middleware | 5 Comments

Recently, at a customer site, I faced a performance issue. However, as often the statement is embedded in the application so it’s not possible to rewrite the query. In this blog post, we’ll change the execution plan to solve the problem without changing the code – thanks to SQL Patch. The faulty statement was part of a daily job that was configured and started from the application during the night. Every night, the statement failed…

 
Read More
Nicolas Jardot

OOW 2013: Solving customer issues with the 12c Optimizer (III) – Histogram on varchar2 column

By | Application integration & Middleware | No Comments

It has been a long time since the last Oracle 12c Optimizer article, but this one is the last on the series about customer issues in Oracle 11g. The goal of that series is to show how the new version 12c of Oracle Database helps solving these issues. This blog posting focuses on a well know Oracle behavior when gathering histograms on a varchar2 column. The three cases have been presented during the session “Solving…

 
Read More
Nicolas Jardot

UKOUG Tech13: Optimizer & SQL statements – hint or not hint that’s the question

By | Technology Survey | No Comments

It’s the final day of Tech13, less sessions but still good topics. Mainly about the Oracle’s optimizer: looking at the execution plans and a debate about hinting SQL statements. I will focus on the hint topic in this blog. Due to trip planning it’s a much shorter day, less time for attending sessions and less time for blogging. I will focus on the debate between Tony Hasler and Jonathan Lewis about how the optimizer takes…

 
Read More
Nicolas Jardot

UKOUG Tech13: Day 3 – Virtualization and Oracle 12c Optimizer

By | Technology Survey | No Comments

Another full day in Manchester, I choose to follow a stream a little bit different in the morning. So it will not be all about the Oracle Optimizer 12c today, but more about O.S and virtualization. Virtualization is an interesting topic but it’s also complex because if the concept seems simple, there are problematics with the licensing, the support and the performance. Why use Oracle VM? Everyone thinks about VMware when speaking about the first…

 
Read More
Nicolas Jardot

UKOUG Tech13: Day 2 – PL/SQL performance, Pluggable database API and so on

By | Technology Survey | No Comments

Tech13 – Day 2: 11 different streams with 3 dedicated to the databases. Many interesting topics and it’s sometimes hard to choose to which session attend. I tried to keep an eye on sessions about performances. I was interested on more than 6 sessions for that day but I can’t speak of all. PL/SQL performance Timothy Hall, blogger from oracle-base.com was speaking about improving the performance of PL/SQL calls from SQL. It’s not always easy…

 
Read More
Nicolas Jardot

UKOUG Tech13 “Super Sunday”: dbi services is here!

By | Technology Survey | No Comments

Today was the first day of UKOUG Tech13: 4 days about Oracle Technology. This year, 7 streams started today (3 last years). I also had a slot to give my presentation about the Optimizer behavior in 12c. The day started with a little delay in registration: My collagues Pierre and Philippe were not correctly registered and didn’t get their badge right away, but everything was solved before the start of the sessions. Speaker time I…

 
Read More