Infrastructure at your Service

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
Middleware Team

UKOUG Tech 2013 – Weblogic Java and Middleware 2

By | Technology Survey | No Comments

During this last day I also decided to follow the Middleware stream. I have continued to learn about future Oracle product strategies. In the web tier layer, Oracle will continue to support I planet web server but without adding new added value features inside. They insisted on the fact that OHS (Oracle HTTP Server) is still, and will be the preferred Oracle product as a web server. OHS is derived from Apache the famous free/open…

Read More
Middleware Team

UKOUG Tech 2013 – Weblogic Java and Middleware

By | Technology Survey | No Comments

Today I attended the Middleware Weblogic stream. It was very interesting to learn a few things about the Oracle view and strategy around Java and Middle-tiers layer. On the perspective to continue to provide cloud management tools and products, Oracle wants achieve stronger integration between Weblogic and Databases, both in 12c versions about following features: Application availability with Transaction Gard Multitenant Database integration Database Connection Pool Global Data Services Oracle also made a introduction about…

Read More
Pierre Sicot

UKOUG Day 3: PL/SQL hints by Tom Kyte & Oracle Active Data Guard

By | Technology Survey | No Comments

Today’s first session I assisted was presented by Tom Kyte. He talked about SQL topics we surely do not know. The first topic concerned the possibility of using the plsql_warning clause with the PL/SQL compiler. This feature exists since version 10.1 but is not widely used. The different values you can define for the plsql_warning with a classical alter session command are: Severe: code might cause unexpected errors or wrong results Performance: code might cause…

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
Pierre Sicot

UKOUG Day 2: Exadata Management Deep Dive with OEM Cloud 12c

By | Technology Survey | No Comments

I started the second day ay UKOUG with an Exadata Management Deep dive with Oracle Enterprise Manager Cloud 12c. Through a certain numer of plugins, Oracle Enterprise Manager Cloud 12c offers an integrated view of hardware and software. In Enterprise Management Cloud 12c you have access to the following menus: Software Cell Management: Cell home page and performance page Workload distribution by database Interprets immediately what’s happening Performance workload distribution may help analyze analyses performance…

Read More
Middleware Team

UKOUG Tech 2013 – SOA and Oracle Fusion Middleware

By | Technology Survey | No Comments

This Monday I decided to follow the SOA – JAVA – BPM stream. I attended a presentation showing a high level overview of Oracle SOA and BPM Architectures, Oracle Fusion Middleware, and various product integrations. They have spoken a few about SOA principles, from legacy Systems and application, to the end Web Services. What we need to understand here, is that SOA is an intermediate / abstraction layer that aims to standardize accesses to more…

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
Middleware Team

UKOUG Tech 2013: dbi services won the Weblogic Hackathon contest!

By | Technology Survey | No Comments

Today, we participated in two WebLogic presentations – and won the WebLogic Hackathon contest! But first, let’s talk about the sessions. The first session was a summarized overview of the Weblogic installation process. There are two manners to proceed. On the one hand, you can use a GUI based interface, and on the other, you can use the silent mode. At the end of the presentation, we installed a new Weblogic domain in a virtual…

Read More
Pierre Sicot

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

By | Technology Survey | No Comments

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 Solving Critical Issues with the 12c Optimizer, covering histogram collection, temporary table statistics and adaptive query optimization. There were around thirty people at his session, and a lot of UKOUG speakers were very interested and asked…

Read More
Morgan Patou

Developing an archive action for Alfresco Share (1 of 2)

By | Application integration & Middleware | 2 Comments

A few weeks ago when I was working on setting up an Alfresco Community Edition v4.2.c, I came across a problem that took me quite some time. What I will talk about today is the customization of the actions provided by the interface of Alfresco Share. This action was tested on all sub-versions of Alfresco Community Edition 4.2 (a, b, c and d). Unfortunately, Alfresco Share does not provide function to archive content. To meet…

Read More