Understanding SQL

From time to time someone publishes a query on the OTN database forum and asks how to make it go faster, and you look at it and think it’s a nice example to explain a couple of principles because it’s short, easy to understand, obvious what sort of things might be wrong, and easy to fix. Then, after you’ve made a couple of suggestions and explained a couple of ideas the provider simply fades into (more...)

Alignement marketing et ventes, pourquoi le CRM doit évoluer ?

Personne ne pourra le nier, les services Marketing et Ventes ont généralement beaucoup de mal à travailler entre eux. La naissance d’une conflictualité entre deux équipes nuit gravement à la productivité des différents services et à la performance des campagnes à la fois marketing et commerciales. Malheureusement il est presque utopique d’espérer voir ces deux secteurs évoluer en totale harmonie. Ils oeuvrent pourtant tous deux dans le même objectif : créer de la valeur pour (more...)

Optimizing the PL/SQL Challenge IV: More OR Condition Woes

In the previous post in the PL/SQL Challenge optimization series, we'd made huge performance gains simply by removing optional bind parameter clauses. The main body of the query is still doing a significant amount of work however and taking several seconds to execute. Fortunately there are simple changes we can make to improve its performance. Let's take a look.

Reviewing our trusty autotrace report we can see the following: 

The red boxes highlight key issues (more...)

Oracle Database Appliance アップデート

2015年5月、Oracle Database Appliance の Bundle Patch がリリースされました。

  • Oracle Database
    - / / から / / へアップデート (PSU)
  • Grid Infrastructure
    - から へアップデート (PSU)
  • Oracle Appliance Kit
    - ACFS の自動拡張
    - (more...)

Receiving Errors When Validating Invoices? APP-PO-14144: PO_ACTIONS-065 CLOSE_AUTO

Are you getting this symptom when attempting to validate invoices?

APP-PO-14144: PO_ACTIONS-065: subroutine CLOSE_AUTO() returned error

Check out these two references:

Doc ID 1987958.1 Attempting to Validate Invoices: APP-PO-14144: PO_ACTIONS-065

Doc ID 1966826.1 Validate Invoice: APP-PO-14144: PO_ACTIONS-065: Subroutine CLOSE_AUTO() returned error

 Need more information?   Post your question in the Procurement Community here.

Special Database Options

When you're installing Ops Center, you have two options for the product database: You can use an embedded database, that's automatically installed on the Enterprise Controller and managed by Ops Center, or you can use a remote database that you manage yourself.

With regards to the customer-managed database, I saw an important question recently: When you install this database, do you have to enable any of the advanced or special features? Some folks want to (more...)

How to use Oracle Universal Connection Pool (UCP) with Spring Framework

This article illustrates the steps to use Oracle Universal Connection Pool (UCP) with the Spring framework, using a sample application built using the JDBC template.

  • Assume there is a simple table EMP in the database with (more...)

How to use Oracle Universal Connection Pool (UCP) with Hibernate

Hibernate ORM is an object/relational mapping framework for Java. Out-of-box, Hibernate supports two open source connection pools C3P0 and Proxool.

Universal Connection Pool (UCP) is Oracle’s feature-rich Java connection pool, replacing the Implicit Connection Cache (ICC), (more...)

eProseed has accomplished it’s first go-live with SOA Suite 12c technology

clip_image001We are pleased to announce that eProseed has accomplished its first go-live with 12c technology working with CFL - The Luxembourgish National Railway Company.
With this implementation, CFL accomplished a high-reliable, agile and flexible integration platform across various heterogeneous application - existent in and off-premises - empowering CFL monitoring and control capabilities in addition to a faster customer on-boarding.
eProseed team’s expertise enhanced the new SOA Suite 12c capabilities enabling to deliver a short time-to-market (more...)

Creating and scaling Dynamic Clusters using wlst by Jaap Poot

clip_image002Introduced in Weblogic 12.1.2, dynamic clusters is a great feature to scale your private cloud.
Dynamic clusters provides you easy scaling of Weblogic clusters by adding and removing managed server instances on demand. They contain one or more dynamic servers. These dynamic servers are based on a single servertemplate that guarantees that every member of the cluster is exactly the same.

Creating Dynamic Clusters

Let's take a look at some of the possibilities (more...)

Kan iemand mij uitleggen waar IT heen gaat?

“Als je het niet kan zeggen, zing het dan maar”. Dat was vroeger een veel gebruikte kreet als je niet onder woorden kon brengen of kon benoemen wat je wilde zeggen. Hier moet ik vaak aan terugdenken als ik de fantastische kretologieën voorbij zie komen die nieuwe trends of hypes in onze mooie IT wereld beschrijven. Soms iets van oude wijn en nieuwe zakken of door alleen het oogstjaar te veranderen, maar vaak zijn de (more...)

Guaranteed Method of Boosting your Oracle Skills

I can tell you how to be a better Oracle DBA, Developer, Designer, Architect – whatever your flavour of role or aspect of profession, if Oracle tech is part of your working world I can hand you the key to improvement. And it is easy.

I am totally assured(*) I can do this. It will work for every single one of you reading this post (except for you two, you know who you are). And (more...)

Traffic Director is now available for Exalogic (Solaris)

Traffic Director is now available for Exalogic (Solaris) and SuperCluster. Oracle Engineered Systems customers can now uptake Traffic Director either as a new installation or simply installing on top of an existing Traffic Director 11.1.1.x release.

In addition to addressing several critical bug fixes, this service pack release also delivers the following key features:

1. (more...)

Managing Your Customers, Contacts and Related Sales Data – The Easy Way


The following article looks at the simplified web services available to Oracle Sales Cloud users for creating basic customer, contact, and other records. This is also documented in this MyOracleSupport whitepaper, however in this article you'll fine our own examples and many usage tips.

If you search in Oracle Enterprise Repository for web services related to managing Sales Accounts (also known as Customers) then you'll find that several are returned.

AeroGear Germany tour 2015

Over the last three days Sébastien Blanc and I have been touring through Germany to visit a few JUGs.

The talks

We had the same setup for every evening: First, Sebi was talking about JBoss Tools and Forge and showed how to quickly create a Java EE based backend. Afterwards the audience saw the how to create a good looking Apache Cordova mobile app, that he also generated using Forge! At the end the solution (more...)

现以优惠价格获取Java SE 8 OCP认证

Brandye BarringtonOracle 2015428

Java SE 8颠 覆了人们编写代码的方式。

获得Java SE 8认证将帮助您充分利用其提供的所有新功能。

广大Java SE 8 OCA编 程人员,现在您成功通过Java SE 8 Programmer II (1Z1-809)考试即可成为 Oracle Certified Professional, Java SE 8程序员。 该考试的Beta测试版现正以大幅优惠价推出,只需50美元。

准备这门认证考试的过程将让您深入了解功能显著升级的最新版本Java。 学习在日常编程时使用lambdas表 达式,从而降低开发时间,为编程创造更大的灵活性。

虽然这项认证不含培训要求,但还是强烈建议您参加推荐的培训课程Java SE 8 Programming。 该培训由教师指导授课,通过理论联系实践的方式,教您如何有效地在实际运用中利用所学的知识与概念。

欢迎访问pearsonvue.com/oracle并注册考试1Z1-809。 登录Oracle认 证网站了解所有备考详情,包括考试目标、考题数量、时间分配和考试价格等。.


· 认证路径: Oracle Certified Professional, Java SE 8 Programmer

· 认证考试: Java SE 8 Programmer II (1Z1-809)

· 推荐培训: Java SE 8 Programming

· 认证网站: About Beta Exams

· 立即注册: Pearson VUE

Nouveaux cours en Français disponibles à la planification

Sachez que depuis peu, les cours français suivants sont devenus disponibles à  la planification :

Fusion Applications:

· Fusion Applications R8: Administer using EM12c Cloud Control (3 jours)

· Fusion Applications: Fixed Assets Fundamentals (2 jours)

Identity Management:

· Oracle Access Manager 11g R2: Administration Essentials (5 jours)


· Java EE 7: Front-end Web Application Development (5 jours)

Middleware Development Tools:

· Oracle Mobile Application Framework 2.1: Develop Mobile Apps (3 jours)

Oracle Linux:


Dom Brooks über Plan-Stabilität

Dom Brooks zählt zu den Blog-Autoren, die sich am intensivsten mit Fragen der Stabilität von SQL-Ausführungsplänen beschäftigt haben. In Strategies for Minimising SQL Execution Plan Instability liefert er einen recht umfassenden historischen Überblick zur Entwicklung des Optimizers und jener Ergänzungen, die eingeführt wurden, um seine Informationsgrundlagen und Entscheidungsmöglichkeiten zu erweitern. Dabei gilt natürlich, dass die größere Flexibilität und die Einführung adaptiver Strategien dazu führen, dass die Stabilität der Optimizer-Entscheidungen geringer wird. Die grundlegende Frage dabei (more...)

UKOUG Systems Event 2015

ukougI have a bone to pick with UKOUG. I’m coming from Birmingham and I’m a lazy git, so why the heck am I on in the first slot? :) It was a 04:30 start to the day, for a train journey starting at 05:50. I could have got a later train, but it would have been busier and more importantly, more expensive… After putting the latest of my writing tips posts live and lying in the (more...)

Google revoluciona las búsquedas otra vez

El 21 de abril, Google anunció un cambio sísmico en su algoritmo de búsqueda móvil que va a cambiar el orden de cómo se clasifican los sitios web (páginas individuales) a través de la búsqueda móvil. Los sitios web que no están adaptados a los móviles (mobile friendly) puntuarán menos y aparecerán más abajo a pesar de que aparezcan en puestos altos en el ranking de bíusqueda de  páginas completas o en el de búsqueda (more...)