You are not even wrong about the Cloud – Part 4

| Apr 18, 2014

This series of blogs has been exploring several aspects of Cloud computing which have the difficult property of orthogonality – a characteristic where two aspects of Cloud computing which would seem to work together actually follow separate and sometimes divergent paths. The tangible result of this orthogonality is difficulty coming up with an accurate assessment for a Cloud computing offering, since these multiple areas are not (more...)

When Bad Tweets Attack: 8 Bits of Advice

| Apr 18, 2014

Bad Twitter attackIt’s the nightmare every C-suite exec envisioned back when talk of doing social media first started…what happens if the brand makes a catastrophic and very public social media mistake? Don’t people realize how much money has been spent on marketing and PR to make sure every syllable the brand puts out is soft, safe and sanitized?

Social is 24/7, real-time, revealing, and involves interaction between humans. That is not a recipe corporations seek out. But (more...)

ArchBeat Facebook Friday: Top 10 Shared Links – April 11-17, 2014

Among the blog posts, articles, events, and other items shared with the more the 5,000 fans of the OTN ArchBeat Facebook Page over the last seven days, the following items were the most popular:

  1. OIM Clustering: Keeping separate environments separate | Simon Kissane
    For testing and development purposes, it is common to have multiple distinct OIM environments co-existing on the same subnet. In that scenario, it is essential that the distinct environments utilize separate multicast (more...)

DIY Disasters

When people take on home renovation “Do-It-Yourself” projects beyond their skills, disaster ensues. Apparently, this is so common that you can base a whole TV series on this theme – where professionals rescue the disastrous DIY project for the grateful and clueless amateur handyman.

I’ve seen the same thing happen in many IT projects. The people in the organization overestimate their own skills and are unable or unwilling to pay the cost of professional external (more...)

Bitmap loading

Everyone “knows” that bitmap indexes are a disaster (compared to B-tree indexes) when it comes to DML. But at an event I spoke at recently someone made the point that they had observed that their data loading operations were faster when the table being loaded had bitmap indexes on it than when it had the equivalent B-tree indexes in place.

There’s a good reason why this can be the case.  No prizes for working out what it is – and I’ll supply an answer in (more...)

Podcast Show Notes: SOA and Cloud – Where’s This Relationship Going?

Opinions vary on the relationship between service oriented architecture and cloud computing. Some say SOA is essential to the cloud. Others say cloud is entirely possible without SOA. In this three-part program three members of the Masons of SOA, the group behind the Industrial SOA article series, offer their insight into the issue.

The Panelists

(Listed alphabetically)
  • Jurgen Kress, Oracle EMEA Alliances and Channels, founder of the Oracle SOA and BPM community, the Oracle (more...)

I Love Logs

It occurred to me a few days ago, as I was reading this article on DevOps, that I might actually be a DevOps.

I think of myself as a developer, but my current role is in a small team running a small system. And by running, I mean that we are 

  • 'root' and 'Administrator' on our Linux and Windows servers
  • 'oracle / sysdba' on the database side, 
  • the apex administrator account and the apex workspace (more...)

Migrating a Database to an Exadata Machine

We have been migrating our databases from the non-Exadata servers to the Exadata Database Machine using the “RMAN 11g Duplicate standby from Active database” command, to create the standby databases on the Exadata machine. Below are the steps which were performed for these successful migrations. Assumptions Here we assume that the following tasks has been […]

The post Migrating a Database to an Exadata Machine appeared first on VitalSoftTech.

Oracle Priority Service Infogram for 17-APR-2014

RDBMS and Performance

Frequently Misused Metrics in Oracle, from The Oracle Alchemist.

Some notes from Tyler Muth on Oracle Database 10.2 De-Supported.

Also from Tyler Muth, a quick posting on Create Bigfile Tablespace – Oracle Managed Files (OMF).


From the dbi services blog: Implementing Oracle Database as (more...)

Simple Example with REPLACE

The REPLACE function allows you to change a string of characters to another string of characters and can accept three parameters:
(1)    Input column name.
(2)    Old string value.
(3)    New string value.
You can see what I mean in the example below, which I tested on Oracle 11.2:
SQL> create table directory_name
  2  (location varchar2(30))
  3  /
Table created.
SQL> insert into directory_name


This was tested on an Oracle 11.2 database. You cannot GRANT or REVOKE object privileges to or from yourself:
SQL> show user
SQL> grant select on blah to john
  2  /
Grant succeeded.
SQL> grant select on blah to andrew
  2  /
grant select on blah to andrew
ERROR at line 1:
ORA-01749: you may not GRANT/REVOKE privileges to/from
SQL> revoke select (more...)

Google Glass + iBeacons


If you haven’t talk to me IRL for the past 10 months, then I haven’t pestered you about the wonders of BLE and micro-location. My love affair with BLE (Bluetooth Low Energy) beacons became clear when I heard at WWDC 2013 that Apple was implementing BLE beacon detection in their CoreLocation framework. Apple showed how a small BLE beacon sending a constant signal (UUID + Major + Minor *) at a given interval could help (more...)

Automatically Add License Protection and Obfuscation to PL/SQL

Yesterday we released the new version 2.0 of our product PFCLObfuscate . This is a tool that allows you to automatically protect the intellectual property in your PL/SQL code (your design secrets) using obfuscation and now in version 2.0 we....[Read More]

Posted by Pete On 17/04/14 At 03:56 PM

LogDump and Understanding header information in Oracle GoldenGate Trail Files

Replication of data is always a fun thing to look at; What is replicating?!  Discussions around, How do I get data from server/database A to server/database B or even to server/database C are valid questions and are often asked by management.  Often the simple (knee jerk) answer is, just set it up and start replicating.  Although Oracle GoldenGate may be simple (for some architectures) to meet the demands of management and the (more...)

Supplemental Logging and Securefiles Causing DBWn to Block

A few weeks back, we began making changes to prepare for using Oracle Golden Gate. One of the first steps required is to enable "minimal supplemental logging" at the database level. We did this during an evening maintenance window. However by the time the morning workload picked up, we started seeing a lot of sessions blocking, and the root blocker was one of the DB Writer (DBWn) processes.

Looking at the blocked sessions, a query (more...)

OSP #3a: Build a Standard Cluster Platform

This is the fifth article in a series called Operationally Scalable Practices. The first article gives an introduction and the second article contains a general overview. In short, this series suggests a comprehensive and cogent blueprint to best position organizations and DBAs for growth.

We’ve looked in some depth at the process of defining a standard platform with an eye toward Oracle database use cases. Before moving on, it would be worthwhile to briefly touch (more...)

MongoDB is growing up

I caught up with my clients at MongoDB to discuss the recent MongoDB 2.6, along with some new statements of direction. The biggest takeaway is that the MongoDB product, along with the associated MMS (MongoDB Management Service), is growing up. Aspects include:

  • An actual automation and management user interface, as opposed to the current management style, which is almost entirely via scripts (except for the monitoring UI).
    • That’s scheduled for public beta in May, (more...)

Zur Semantik der ON clause im ANSI Left Outer Join

Vielleicht wäre es sinnvoller, auf diesen Eintrag zu verzichten, weil er ein wenig peinlich ist - aber was soll's: gestern ist mir im Rahmen eines OTN Threads aufgefallen, dass meine Interpretation der ANSI OUTER JOIN Syntax bislang unzutreffend war. Ich verzichte auf nähere Erläuterungen zu meiner Fehleinschätzung (die für meine übliche Formulierung von ANSI OUTER JOINs ganz plausibel war), und erkläre lieber gleich, was das ON tatsächlich bedeutet:

drop table t1;
drop table t2;

create (more...)

Indexing Foreign Key Constraints With Bitmap Indexes (Locked Out)

Franck Pachot made a very valid comment in my previous entry on Indexing Foreign Keys (FK) that the use of a Bitmap Index on the FK columns does not avoid the table locks associated with deleting rows from the parent table. Thought I might discuss why this is the case and why only a B-Tree index does […]

How important is a Disaster Recovery site for you?

I regularly read threads on the oracle-l mailing list, and occasionally feel very tempted to reply to one. Just recently I saw one that I liked a lot. It is specifically about using an Oracle Database Appliance (ODA) as a Disaster Recovery (DR) solution for an Exadata system. The Exadata configuration was not specified, I assume it was a smaller (eighth rack/quarter rack) configuration.

There were lots of arguments pro and against that Exadata->ODA architecture, (more...)