Delphix Express – a free version of Delphix




photo by Yannis (CC 2.0)

On the website there is a “Free Trial” download which is a fully functional 30 day trial version of Delphix. Unlike the 30-day trial version, Delphix Express is yours to use, as long as you’d like.

Delphix Express is a free version of Delphix limited to 1 vCPU and 25 GB of managed storage.

Delphix Express is in pre-release status. If you’d like to join (more...)

Exadata’s onecommand fails to validate NTP servers on storage servers

This will be simple and short post on an issue I had recently. I got the following error while running the first step of onecommand – Validate Configuration File:

2015-07-01 12:31:03,712 [INFO  ][    main][     ValidationUtils:761] SUCCESS: NTP servers on machine verified successfully
2015-07-01 12:31:03,713 [INFO  ][    main][     ValidationUtils:761] SUCCESS: NTP servers on machine verified successfully
2015-07-01 12:31:03,714 [INFO  ][    main][     ValidationUtils:778] Following errors were found...
2015-07-01 12:31:03,714 [INFO  ][     (more...)

ODTUG Kscope15 Review: It was the best of times, it was the best of times!

Last week AuraPlayer headed south to attend ODTUG’s annual KScope conference in Hollywood, Florida. It was very exciting to play many pivotal roles; serving as an ODTUG Board member, an Exhibitor, a 2 time speaker and an Oracle ACE Director. The event was definitely a highlight – I truly learned a lot and, of course, had a lot of fun.

With that being said, so much happened that it would be nearly impossible to provide an (more...)

Good new SQL tuning book

People ask me from time to time what are some good SQL tuning books. It’s a tough question to answer. There are some seminal books such as “SQL Tuning” by Dan Tow and “Cost Based Optimizer Fundamentals” by Jonathan Lewis, but these are advanced books  that few I know have actually read from cover to cover. If you are looking for practical SQL tuning cookbooks you might want something a little less advanced.  For a practical (more...)

Our Top 10 ODTUG #Kscope15 Sessions for Mobile / ADF/ Cloud / Forms Developers

It’s that time of year again; Kscope time, and I’m sure you are as excited as we are. You are most likely spending every moment of your free time reading the never-ending list of sessions tryinaurakscopeg to decide which ones to attend. Although there are over 300 to choose from, it’s time to bite the bullet and make decisions, because schedules must be made. To help you on your way, Mia, AuraPlayer’s CEO, has compiled a (more...)

Flushing Shared Pool Does Not Slow Its Growth

I’m still working on resolving the issues caused by bug 13914613.

Oracle support recommended that we apply a parameter change to resolve the issue but that change requires us to bounce the database  and I was looking for a resolution that does not need a bounce.  The bug caused very bad shared pool latch waits when the automatic memory management feature of our database expanded the shared pool.  Oracle support recommending setting _enable_shared_pool_durations=false (more...)

Functional programming a brief introduction to Scala

In this blogpost I’ll try to explain on a very basic level what functional programming (FP) is about. look at is as an introduction to the amazing world of FP. FP is already here for quite a few decades. It was mostly used in the academic world and specialized industries. Since the coming of Scala, FP became more and more mainstream.

So what is functional programming?

(from Wikipedia (more...)

5 Minute JavaScript #19: Polyfills

The past few weeks were dedicated to the useful array methods. However these methods have been implemented in ECMAScript 5 and are therefore not available in older browsers such as IE8 and sometimes we have to support legacy browsers.

In JavaScript, we use polyfills to create behavior that is not implemented in browser. We can use polyfills to add every kind of behaviour to our application and a lot of websites provide these polyfills.

Basically (more...)

5 Minute JavaScript #18: reduce

The past weeks we dived in the wonderful world of array methods. Previously we already discussed forEach, filter, some and every, and map. Today we’ll take a look at the reduce method. While being extremely useful, its concept can be hard to grasp.

Also known as fold (in this case foldLeft) in other functional programming languages, reduce kan be used to combine all elements of an array into one single return value. That return (more...)

SQL Performance, Part IV. Heap tables.

Demo script

Writing tips and techniques

It’s been a while since I’ve posted anything on my blog, and this is a slightly different post to the rest, as it’s not technical in any way…  Instead it’s a quick post about a series of fantastic writing tips and techniques posted recently, from my good friend Tim Hall at ORACLE-BASE.  I’ve tweeted a few of these


SQL performance, Part III. Data storage strategies

Imagine that you’re on a desert island where some pirates hid their treasure. You don’t know where exactly it is hidden, but you want to find it. How should you approach this – e.g. should you dig randomly? Or should you follow some sort of a system – and if yes, then which?

I think most readers have smelled a trap right away (it’s not a very sophisticated trap anyway) – of course it (more...)

SQL Performance, Part II — Disk I/O: metrics and scales

While query performance depends on a large number of things, overall scale of query performance for a given database is generally set by disk I/O speed. The most common type of a storage device used in databases is still a hard disk drive (HDD), so let’s consider how it works.

HDD uses magnetic state of a very small region on a disk to encode “0” or “1” (i.e. carry 1 bit of information). A (more...)

SQL Performance, Part I. Data access efficiency.

Database performance optimization deals with the problem of reducing time (and/or other resources) required to complete database queries by resolving various inefficiencies. There are many kinds of performance issues, and they can be categorized in many different ways. One important way is by scope: statement-level or instance-level. Instance-level performance tuning (which we are not covering in this mini-series) deals with such problems as excessive parsing, cache efficiency, concurrency etc. Statement-level performance tuning deals mostly with (more...)

Giving back

Occasionally, I receive requests to explain stuff I talk about in my blog posts on a level accessible to beginners. Unfortunately, it’s not always possible to do so. You start to explain one little thing, and then you realize that in order to understand that thing, one would to understand a dozen other little things, and before you know it, instead of writing a short blog post you find yourself writing something of the size of (more...)

Top 6 production database mistakes that could be slowing down your system

Oracle Is Easy, a blog written by <a href="" SmartDog Services


After more of 14 years of experience working with Oracle Databases of different sizes, levels of activity and critical importance, I know a thing or two about production databases. No matter the size of the database or the complexity of the product that is working with the database, there are always some common settings that DBAs are missing and can adjust improve (more...)

Planning, Implementing and Nurturing Your Failure Analysis Codes in Oracle EAM

Oracle Is Easy, a blog written by <a href="" SmartDog Services

It has been said that the goal of a good Maintenance Manager should be the elimination of his Maintenance Department. My opinion is that phrase should be amended to read “A good Maintenance Manager’s goal should be the elimination of Corrective Maintenance.” Since machines and software are not perfect one hundred percent across the board, a more realistic goal is to (more...)

Google Search Appliance GSA Version 7.4 Released

Wanted to drop a quick note here that Google released the latest version of the Google Search Appliance software last week. That brings the most current version up to 7.4.0.G.72 and officially end of life’s the 7.0 version of the appliance software.

New features from the support site posting:

  • Seamless Integration with Microsoft: we’re releasing our SharePoint and Active Directory 4.0 connectors out of beta. These connectors provide improved (more...)

ADF 12.2.1 New Features

Oracle has just updated their ADF Statement of Direction, announcing that ADF 12.2.1 will be out in 2015. Here is what they are promising for this release:

The Next Version of Oracle ADF

Oracle is planning to deliver the next version of Oracle ADF – 12.2.1 – as part of the next release of Oracle Fusion Middleware 12.2.1 in 2015. Some of the focus areas for this version include:

Observer effect

In physics, one important limitation of any experiment is the fact that an act of observation inevitably interferes with the observed process (“observer effect”). Same thing is true about databases. It is a well known fact that, for example, turning on tracing can significantly slow down the process for which it’s enabled. But there exist even nastier forms of this effect: for example, when you try to trace a SQL statement using nested loop batching mechanism, (more...)