Abstract There are many ways to find SQL that is performing poorly. The hard part is what to do with a bad SQL statement once you have it. In this session, several real-world examples will be reviewed to help you (more...)
Yeah, it’s indeed true and official. So if you still haven’t started reading and learning Multitenant architecture introduced in 184.108.40.206 and enhanced in 220.127.116.11, it’s high time that you start doing it. Not because that it’s new but because the old architecture you are familiar with, it’s officially on the verge of extinction.
Last week we installed the new "SOA Bundle Patch 18.104.22.168.1 (Patch)" (19707784). Applying the patch went fine, no problem at all.
We have a process that is initiated by an Initiator Task, that can be started, I'm sure you're familiar with, using the link under 'Applications'. In our case, however, clicking it gives an exception in stead of opening the Task Form:
I’m working on Oracle database migration project where customer have chosen commodity x86 hardware with RHEL6 and EMC storage.
I’ve done many similar installations in the past and I always used the native MPIO in Linux (DM-Multipath) to load balance and failover I/O paths. This time however I’ve got EMC PowerPath doing the load balance and failover and got the native MPIO disabled. From my point of view it’s the same, whether I’ll be using (more...)
I've been working my way through some security topics along WildFly 8 and stumbled upon some configuration options, that are not very well documented. One of them is the TLS/SSL configuration for the new web-subsystem Undertow. There's plenty of documentation for the older web-subsystem and it is indeed still available to use, but here is the short how-to configure it the new way.
Generate a keystore and self-signed certificate First step is to generate a (more...)
With the release of SOA Suite 12c a new product was revealed. The first sighting was at Oracle OpenWorld 2013. On the Fusion Middleware Demo Grounds there was a demo shown where B2B was integrated with a product called Managed File Transfer (shortened as MFT). At that same conference I gave a presentation about this product together with the product manager of MFT, Dave Berry. This blog gives an in-depth look into (more...)
Wieder nur eine kurze Notiz, aber eine mit einem aus meiner Sicht recht bedeutsamen Inhalt: wie man von Christopher Jones erfährt gibt es Oracles Beispiel-Schemata seit kurzem als Repository auf GitHub:
This repository contains a copy of the Oracle Database sample schemas that are installed with Oracle Database Enterprise Edition 12c. These schemas are used in Oracle documentation to show SQL language concepts. The schemas themselves are documented in Oracle Database Sample Schemas, 12c Release (more...)
A recent thread on the OTN database forum supplied some code that seemed to show that In-memory DB made no difference to performance when compared with the traditional row-store mechanism and asked why not. (It looked as if the answer was that almost all the time for the tests was spent returning the 3M row result set to the SQL*Plus client 15 rows at a time.)
The responses on the thread led to the question: (more...)
The Fusion Middleware Partner Community Forum takes place March 3rd & 4th in Budapest Hungary. During this annual conference You as an Oracle Partner can get the latest updates on the Fusion Middleware 12c solutions. “The Cloud Platform for Digital Business” will be the theme of the 20th conference. Keynotes will be delivered from Amit Zavery, Andrew Sutherland and SOA, BPM and Mobile product management including live demos. On the (more...)
Oracle 12c introduced "invisible columns" to help us add columns to tables without breaking existing applications. The documentation explains how they work with SELECT and INSERT, but not MERGE. Here's what happened when I tried MERGE.
Oracle E-Business Suite environments may be vulnerable due to excessive privileges granted on the SYS.DUAL table to PUBLIC. This security issue has been resolved in the January 2015 Oracle Critical Patch Update (CPU).
On January 24, Oracle published additional information regarding this security issue in My Oracle Support Note 1964164.1. Revoking of these privileges may cause “subtle timestamp corruptions” in the database unless database patch 19393542 is applied.
I’m writing this in my hotel room in downtown San Francisco, with my colleague Francesco Tisiot flying in tonight and US colleagues Jordan Meyer, Daniel Adams and Andy Rocha travelling down tomorrow and Monday for next week’s BIWA Summit 2015. The Business Intelligence, Warehousing and Analytics SIG is a part of IOUG and this year also hosts the 11th Annual Oracle Spatial Summit, giving us three days of database-centric content touching most areas of the (more...)
Over the last twelve months or so, one of my projects has been fixing and reviewing fixes of javac lint warnings in the JDK 9 code base
raw and unchecked) and once a warning category is cleared, making new instances of that category a fatal build error.
Ultimately, all the warnings in the jdk repository were resolved and -Xlint:all -Werror is (more...)
I created a simple Grails application which makes it possible to store client data inside a MySQL database. I created this application since I want to learn more about GORM (Grails Object Relational Mapping).
I already tested the application in the internal server from Grails, but I wanted to deploy it to a remote server. So I created a development account on Openshift and there I created the following server:
The Fusion Middleware Partner Community Forum
takes place March 3rd & 4th in Budapest Hungary. During this annual
conference You as an Oracle Partner can get the latest updates on the
Fusion Middleware 12c solutions. “The Cloud Platform for Digital
Business” will be the theme of the 20th conference. Keynotes will be
delivered from Amit Zavery, Andrew Sutherland and SOA, BPM and Mobile
product management including live demos. On the second day you can