The acquisition of BitzerMobile is a huge game changer for Oracle's middleware offerings. It not only elevates the potential for all of Oracle's Fusion Middleware applications such as OBIEE but it now fits the gap in their mobility capabilities they've had around security. That's right Oracle may have been pushing (more...)
SQL performance can degrade for many reasons, some of most common are:
- plan changes
- data skewness
- low caching efficiency
- data growth
All these factors are relatively well known. A somewhat less common, although not exceptionally rare scenario, is read consistency overhead due to concurrent (more...)
I have, in the past, used the dbms_rowid package to create rowids from block addresses (typically faking the first and last rowids that could appear in an extent); but I’ve just been sent a piece of information by Valentin Nikotin that’s going to make me go back and check whether (more...)
This post also applies to non-Exadata systems as hard drives work the same way in other storage arrays too – just the commands you would use for extracting the disk-level metrics would be different.
I just noticed that one of our Exadatas had a disk put into “predictive failure” mode (more...)
A recent question on the OTN database forum included an execution plan that prompted one reader to ask: “but where has the existence subquery gone?” Here’s the original question showing the query, and here’s the later response showing the plan that prompted the question.
There were three possible reasons (more...)
Recursive subquery factoring (AKA Recursive Common Table Expressions) has been available in Oracle since version 11g R2 was launched sometime around 2009. I always thought of it as a replacement for the connect by clause and just another way to write hierarchical queries, so I never really took the time (more...)
I recently was working on an application in Apex 4.2.1.00.08, where the application had several pages with Interactive Reports.
On all these pages, the IR worked fine – except for one crucial page, where the IR’s action menu didn’t work (Select Columns, for example, showed a (more...)
Case Model and WABO
A case consists of the following primary components:
- Case Activities
- User Events
- Business Rules
The Case is the heart of ACM. The status and progress of the case is stored in here. In WABO the permit application is what defines the (more...)
Recently we noticed that imageinfo was displaying the following information at a customers site. Imageinfo was not displaying data i suspected, so a quick little blogpost about what was going on there.
[root@dm01db01 ~]# dcli -g /opt/oracle.SupportTools/onecommand/dbs_group -l root "imageinfo | grep 'Image version'" dm01db01: Image version: 11.2. (more...)
Check out what our newest SOA BPM customer Alaska DRB is saying about their success with Oracle Technology!
Alaska DRB manages over 16 Billion in Assets for over 60K members. The strategic vision of the agency director is to have an agile plateform to support six sigma lean for more (more...)
EINLADUNG ORACLE PARTNER DAY GERMANY,
Am 20. Januar 2014 im Dolce Munich Unterschleißheim
Sehr geehrter Oracle Partner,
wir laden Sie ganz herzlich zum Oracle Partner Day 2014 ein. Hier erfahren Sie aus erster Hand, wie Sie die Oracle Erfolgsstrategie für Ihr Unternehmen nutzbar machen können.
Die Tagesveranstaltung findet am (more...)
This post applies both to non-Exadata and Exadata systems.
Before Oracle 11.2 came out, it was true to say that Oracle Parallel Execution slaves always do direct path reads (bypassing buffer cache) when doing full segment scans. This should not be taken simplistically though. Even when you were doing (more...)
Storage for DBAs: Data deduplication – or “dedupe” – is a technology which falls under the umbrella of compression, i.e. reducing the amount of capacity required to store data. In very simple terms it involves looking for repeating patterns and replacing them (more...)