Riga Dev Day 2015 : The Main Event

The event was held at a cinema in a shopping mall. We even got a free popcorn ticket. Awesome! I missed the starting keynote, which was a pity because everyone said it was really cool. So my day went as follows.

Krasimir Tsonev : Using Node.js for everything or what it is to write a book about it

I went to this session because I wanted to be with the “cool kids”. :) I ended up (more...)

Video and Slides – Data Caching Strategies for Mobile Application Framework by Andrejus Baranovskis


I have recorded a video tutorial, based on my OOW'14 session - Data Caching Strategies for Oracle Mobile Application Framework. ADF developers who could not attend OOW'14 in San Francisco, this is for you ! Here you can view the slides: Data Caching Strategies for Oracle Mobile Application Framework

Watch the first part of the tutorial: Read the complete article here.

WebLogic Partner Community

For regular information become a member in the WebLogic Partner Community please (more...)

Sun ZFS Storage 7000 Appliance Administration training in Bangkok

| Jan 23, 2015
Just yesterday, I concluded a training on ZFS Appliance for a rather small batch in Bangkok.

Check this out for more details about ZFS Appliance.

Cloud Control 12c: Gruppen und Privilegien

Gruppen werden in Oracle Enterprise Manager Cloud Control auch dazu verwendet, Zugriffsrechte zu vergeben. Bis zur Version EM gibt es aber eine große Einschränkung, die mit EM durch eine fein granulare Definitionsmöglichkeit gelöst wurde.

Wenn Sie Zugriffsrechte in Cloud Control über Gruppen vergeben, dann sollten Sie diesen Tipp unbedingt lesen.

Recover Keystore for Agile 9.3.2 and above version

agileks.jks is the Keystore used by Agile based on Java JCEKS and AES algorithm. So all the AES related password in Agile are associated with agileks.jks.

During Agile installation, a random Keystore password is created automatically, then agileks.jks is created as well based on the random Keystore password. After that Agile will use this Keystore password and Keystore file to encrypt the random Keystore password itself and save to Agile database propertytable (more...)

DB Link with Oracle BI Applications

| Jan 22, 2015

Authors: Simon Miller, Director OBIA, Oracle Customer Engineering and Advocacy Lab (CEAL team) and Patrick Block, Principal, OBIA Development

In an earlier blog post 3 Modes for Moving Data to the BI Applications DW from a Source Application Database the available options for setting up data source connections was provided in detail, along with screenshots.  It should be noted this information written for OBIA is still applicable for 11. (more...)

Existing News – Java Cloud Service just got an update – WebLogic Server 12.1.3

| Jan 22, 2015

As of Jan 19th, Oracle Java Cloud Service supports WebLogic Server 12.1.3. OJCS was upgrade to support the latest 12c version of WebLogic Server. 

When you create a Java Cloud Service instance, you get to choose the version of the underlying WebLogic Server. Now you can select WebLogic Server 12.1.3. 

Java Cloud Service creation selecting WebLogic Server 12.1.3

All new instance creation will have a choice of 11g ( or 12c (12.1.3). (more...)

Exalogic Elastic Cloud 12c Software and X5-2 Hardware Launch

Today’s blog post is brought to you by Oracle Product Manager Kelly Goetsch.

We're excited to announce the release of the first of two fundamental innovations in Oracle Exalogic - our planned 12c Exalogic Elastic Cloud Software and our new X5-2 hardware, the latter of which is available immediately.

Beginning with software, we're seeing a massive shift from traditional pure virtualization to cloud. In our 12c release, Exalogic is aligning with Oracle's public cloud to (more...)

New Year, New Name, Same Mission

Happy New Year! Looks like it will be another busy one. So, let’s get going! Yes, I just changed the name of my blog from “Oracle Data Warrior” to “The Data Warrior.” Why? Well, for one, my company name is Data Warrior LLC, so it seemed to make sense. Plus over the last few years […]

Riga Dev Day 2015 : The Journey Begins

My first flight was 06:20, so I had to leave the house at 04:00, which meant getting up at about 03:00. Yuck!

The first flight was about 90 minutes from Birmingham to Frankfurt, with the smoothest landing I can ever remember in a plane the size of an A320. I was meant to have a 65 minute changeover before the flight from Frankfurt to Riga. A one hour changeover at Frankfurt is too short, but the (more...)

Patch Now!

So two guys walk into a bar.  They're both talking like pirates and dressed like pirates.  The bartender asks...

No, wait, that's not the kind of patch we're talking about today.  Sorry, folks.  We're talking about a patch for your software...a fix or an update for software you already have in place.  Did you know Oracle puts out Critical Patch Updates ("CPU"s) for all their project on a regular basis?  You can read about (more...)

Partition gotchas

Two minor partition gotchas on partition extent sizing and on the number of partitions in an interval partitioned.

First – old news – note that initial extent size for partitioned tables changed in
Somehow this passed me by and I was late to the large extent party – duh!
Influenced by parameter _partition_large_extents, the default was changed to 8MB rather than 64K for autoallocated ASSM extent sizing.

Pre 11.2. (more...)

LOB Space

Following on from a recent “check the space” posting, here’s another case of the code not reporting what you thought it would, prompted by a question on the OTN database forum about a huge space discrepancy in LOBs.

There’s a fairly well-known package called dbms_space that can give you a fairly good idea of the space used by a segment stored in a tablespace that’s using automatic segment space management. But what can you think when a (more...)

Cluster Cache Coherency in EM12c

January is winding down and RMOUG Training Days 2015 is just around the corner, taking up much of my after work hours.

With that, we are going to discuss a great performance console in the EM12c cloud control-  Cluster Cache Coherency.

Cluster Cache Coherency

Optimization for an Oracle Real Application Cluster, (RAC) can be a daunting tasks for those that aren’t familiar with some of the most common issues to look for.  Although many (more...)

How to Set Axis Max Value of AnyChart in APEX Dynamically

I just created a one-page APEX application to show performance chart of our main production server based on Active Session History data. We publish it on a big monitor so we can see the performance chart during the day. It’s not a big deal but it’s really useful. I used 2D stacked column chart and make the chart simple (contains only 3 colors: green for CPU, blue for user IO and orange for all other (more...)

Oracle Database 12c Patching: DBMS_QOPATCH, OPATCH_XML_INV, and datapatch


Oracle Database 12c brings us many new features including: the long needed ability to run OPatch and query the patch software installed in the Oracle Home programatically through SQL using the new DBMS_QOPATCH package.

If you’re a DBA working in an environment where patching consistently among databases is important, this is a welcomed enhancement. Sometimes one-off critical bug fix patches are important in the environment. Other times regular and consistent application of the quarterly (more...)

Enterprise Apps on SaaS

It's really, really early on a Monday morning as I write this:  "zero dark-thirty".  Some ideas just refuse to allow sleep until you share them.  So, while shivering in the pre-dawn cold, I offer the following for your consideration...

Picture if you will, just for a moment, the idea that your enterprise applications system is like an iceberg.  There are the system costs that you can see.  Then there are the costs below the water (more...)

Bitmap Counts

In an earlier post (not very serious) post about count(*) I pointed out how the optimizer sometimes does a redundant bitmap conversion to rowid when counting. In the basic count(*) example I showed this wasn’t a realistic issue unless you had set cursor_sharing to force (or the now-deprecated similar). There are, however, some cases where the optimizer can do this in more realistic circumstances and this posting models a scenario I came across a few (more...)

PL/SQL Fall Through?

Somebody wants to know how you can write a PL/SQL solution that mimics the fall through of a switch statement because PL/SQL doesn’t support a switch statement. It’s a question that I found interesting because there wasn’t a need for it when I figured out what he wanted to accomplish. Essentially, he wanted to know how to implement a nested loop where the first loop runs in ascending order and the nested loop runs in (more...)

Riga Dev Day and Oracle Midlands Event #7

There are a couple of things on the radar for the coming week and unfortunately for me they are both on the same day.

In Birmingham, UK it is Oracle Midlands Event #7 (OM7) on Thursday 22nd of January. This will be the first Oracle Midlands event I’ve missed since it started. I’m a big fan of what Mike is doing with Oracle Midlands and I appreciate the sponsorship from Redgate that means it is (more...)