Infrastructure at your Service

All Posts By

Nicolas Jardot

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
Nicolas Jardot

OOW 2013: Solving customer issues with the 12c Optimizer (II) – Histogram precision

By | Application integration & Middleware | No Comments

This article is the second on a series of 3 about customer issues in Oracle 11g. The goal is to show how the new version of Oracle solves these issues. This blog will focus on a common issue, when Oracle is not able to get a good histogram because some data is missing at the time the job gathers the statistics These 3 real customer cases have been presented during my session “Solving critical customer…

Read More
Nicolas Jardot

Oracle Open World 2013: Final day – Database as a service and replication fundamentals

By | Technology Survey | No Comments

My final day at Oracle OpenWorld 2013, less sessions and less people but still a big day after almost one week in San Francisco. In this blog I’ll focus on the private cloud with databases as service and the fundamentals about replication. To conclude on Oracle OpenWorld, I would say that there are three big news – more on these at the end of this posting. On Thursday, there are less people in the sessions…

Read More
Nicolas Jardot

Oracle Open World 2013: Day 4 – In-Memory, the next big thing in Oracle 12c

By | Technology Survey | No Comments

Let’s talk about the 4th day in San Francisco at Oracle OpenWorld 2013. Many conferences, hands on labs, keynotes and so on. Some sessions are in the biggest room with many people. Today, we will focus on the new In-Memory option. I have already posted about that feature, but today, I went to an In-Memory session to get a little more details on it – many pictures and less text (easier to gigest ;-). Larry…

Read More
Nicolas Jardot

Oracle Open World 2013: 3rd day – Hands on lab, Optimizer tips and Microsoft Cloudn

By | Technology Survey | No Comments

Today, I’ll talk about the 3rd day at Oracle OpenWorld 2013 and I’ll be shorter than yesterday, too much text. Actually, it’s difficult to have good pictures during the conferences. So what’s the program in this blog: a “hands on lab” session about Linux management, a keynote from Microsoft and few tips about the optimizer. Too much text and not enough photos, I already told that the event is impressive: And it’s just one place!…

Read More