BE SHARING

Oracle optimizer

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

01.12.2013 by Nicolas Jardot

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(…)

Technology Survey

UKOUG Day 1: Oracle Optimizer 12c, Cost Based Optimizer, Exadata

01.12.2013 by Oracle Team

Today was the first day of the United Kingdom Oracle User Group (UKOUG) – usually called the Super Sunday! I already participated in today’s first session three weeks ago in Geneva, but my colleague Nicolas Jardot was talking about(…)

Application integration & Middleware

Oracle Open World 2013 – Day 1: APEX printing tools (XSL-FO / PL/PDF) & Welcome Keynote

24.09.2013 by Arnaud Berbier

To start the Oracle OpenWorld on this Sunday morning, the Swiss community organized a brunch. Thanks for inviting me! It was an interesting networking place in a very good hotel on the 25th floor. As I could not(…)

Application integration & Middleware

Jonathan Lewis @ dbi services: Oracle Optimizer workshop

01.03.2012 by Hervé Schweitzer

Last week, Oracle Ace Director Jonathan Lewis held an Oracle Optimizer Workshop at dbi services BaselArea. I would like to share some of the key learnings of this really interesting exchange I experienced together with my colleagues.

Application integration & Middleware

A SQL statement is slow and suddenly fast? Have a look at “Cardinality Feedback”!

12.04.2011 by Hervé Schweitzer

Discussing with some tuning gourous we were made aware about this feature. It is not so far from the adaptive cursor sharing perfectly described in Chris's blog : http://antognini.ch/papers/BindVariablePeeking_20090718.pdfThis feature, compares the real execution(…)

Application integration & Middleware

How to avoid strange figures in the Oracle optimizer system statistics

03.01.2011 by Yann Neuhaus

Have you ever noticed strange figures while collecting the Oracle optimizer system statistics ? If so, you need to provide the optimizer with the correct number. In this posting, I will show you how.