Windows 7 error “key not valid for use in specified state”

When you see that error upon trying to install or upgrade something on your Windows 7 64-bit machine, chances are that it is caused by a Windows Security update that you need to uninstall. There is probably no point in messing around with the registry or the application that you want to upgrade. Instead, remove the Windows update KB2918614 like this:

Open the control panel, then click  Windows Update

Windows 7 control panelClick Update History and then Installed (more...)

SLOB Failing To Generate AWR Reports? Red Hat Bug 919793!

This is a quick blog post to help folks that are testing with SLOB at high user (session) counts. The situation may arise where you are testing SLOB on a large configuration, with or without SQL*Net, and the SLOB driver ( is failing to produce Automatic Workload Repository (a.k.a AWR) reports.

This problem will generally be seen on RHEL 6 variants that implement the much maligned /etc/security/limits.d/90-nproc.conf method of preventing (more...)

OSCON 2014: Complete Video Compilation

OSCON 2014 - Today, it's not only developers, system administrators or organizations have use the Open Source. Businesses have established to use the Open Source as well. So, you can not ignore about Open Source. At OSCON, you'll encounter the open source ecosystem. It helps digging deep into the business of open source.

Five Reasons to Attend OSCON: Get straight to the epicenter of all things open source and get better at what you do, Learn from (more...)

Using #DB12c PDB as a Repository for #EM12c…. Not so fast!

Last year, I wrote a post on how to setup Oracle Enterprise Manger 12c ( with Oracle Database 12c ( and what you could expect.  At the time the configuration was not supported by Oracle and I only did it to see if it could be done.  If you would like to read that post it can be found here.

This past May (2014), I attended the Oracle Customer (more...)

Webinar Followup (Aug. 27): In Search of Plan Stability – Part 1

Thanks to everyone who attended my August 27th webinar entitled In Search of Plan Stability - Part 1. You can download the presentation materials from these links:

Presentation PDF

I'll update this post to provide a link to the recording shortly.

Come back in November for Part 2. Hope to see you then!


Presenting at OOW 2014

This year I’ll be presenting at Oracle Open World with many of the best in the industry.  If you are going to be in the San Francisco area between September 28 thru October 2 2014, stop by and check out the conference.  Registration information can be found here.

The topics which I’ll be presenting or assisting with this year are:

  • OTN RAC Attack – Sunday, September 28, 2014 – 9 am – 3 pm PST (more...)

DBMS_UTILITY.EXPAND_SQL_TEXT and temporal validity in 12c

12c gave us two new features among others: DBMS_UTILITY.EXPAND_SQL_TEXT and temporal validity. DBMS_UTILITY.EXPAND_SQL_TEXT is advertised as a means to expand SQL text that is using views, but it is also very useful to see how Oracle internally rewrites some SQL queries. Here I'm going to use it to see how temporal validity queries are actually executed. All tests are done using Enterprise Edition.

First I'll create a table for (more...)

The 7 Deadly Sins of Cloud Computing

As if anyone needs to be reminded, there’s a ridiculous amount of hype surrounding clouds and big data. There’s always oodles of hype around any new technology that is not well understood—I believe the correct term for this is product marketing. There are at least seven deadly sins that can be committed when determining a […]

The Big Data Job Gap: Where are the Platform Scientists?

Big data continues to live up to its reputation for disruption as it gnaws away at all of the entrenched constituencies – IT silos, vendors, pricing models and now, careers; it’s about to get very personal. On the possibility side, there is a massive skills gap that needs to be filled. Everybody knows there aren't […]

7 Ways Data Virtualization Helps CIOs

IDC study found that Delphix

  1. Pays for itself in 4.3 months
  2. ROI 461% over 5 years
  3. $1 Million storage and hardware savings
  4. $50 Millionannual  savings for companies over 75,000 employees
  5. $78,500 saved per year per 85 employees
  6. $85,000 annua lIT efficiency per 100 employees
  7. 98.6% storage reduction on a 2.42 TB database footprint


Screen Shot 2014-08-12 at 10.26.54 AM

Screen Shot 2014-08-12 at 10.27.20 AMScreen Shot 2014-08-12 at 10.27.29 AM

A milestone

This week my blog has crossed an important milestone: 111,111 visits. :) I’d like to use this occasion to thank all my readers for their continued interest in my blog, and announce that there are a few more interesting texts in the pipeline, covering such topics as insert optimization, manual optimization of expensive joins, mechanics of redo log related waits (log file sync, log buffer, log file parallel write), and much else. Stay tuned!

OTN Article: Oracle Database 12c: Que sucede en un CDB cuando uno de los PDB obtiene un problema?

OTN - Oracle Technology Network Latina America continue publish our articles. Our 8th technical article published on OTN in Spanish Language at 28th August. This article entitled : Oracle Database 12c: ¿Que sucede en un CDB cuando uno de los PDB obtiene un problema? written by Joel Perez (Oracle ACED), Mahir M. Quluzade (OCE) and Bruno Nuñez (OCE).

It is a link of article:

Thanks to my friends, Joel and Bruno, for their all efforts and thanks to OTN. 

Mahir M. Quluzade


I’ve just found out that we can specify query block for PRECOMPUTE_SUBQUERY: /*+ precompute_subquery(@sel$2) */
So we can use it now with SQL profiles, SPM baselines and patches.

SQL> select/*+ precompute_subquery(@sel$2) */ * from dual where dummy in (select chr(level) from dual connect by level<=100);


SQL> @last

SQL_ID  c437vsqj7c4jy, child number 0
select/*+ precompute_subquery(@sel$2) */ * from dual where dummy in
(select chr(level) from dual connect by level<=100)

Plan  (more...)


Yesterday and today I’ve read or heard two people mention the force_match => TRUE parameter value for DBMS_SQLTUNE.IMPORT_SQL_PROFILE and how it forces a profile to work on all SQL statements that are the same except for their literal values.  So, I ran a quick test using the coe_xfr_sql_profile.sql utility that comes with the SQLT scripts that are available for download on Oracle’s support site.

I’ve mentioned in earlier posts how we use (more...)

In-memory Consistency

A comment on one of my early blogs about the 12c in-memory database option asked how Oracle would deal with read-consistency. I came up with a couple of comments outlining the sort of thing I would look for in a solution, and this note is an outline on how I started to tackle the question – with a couple of the subsequent observations. The data is (nearly) the same as the data I generated for my previous article on the (more...)

The ALS Ice Bucket Challenge, the DBA Kevlar Way

I believe you do your best when you follow in what you believe.

Kellyn’s …. Hold the ice…:)


Oracle performance video library

Here is a series of Oracle performance tuning videos that I put together recently at Delphix. All the presentations are free and open to the public, just have to register.



Successfully managing a modern organization’s complex data estate requires careful work at multiple layers, from the implementation of organization-wide data policies and platforms to the careful tuning of particular databases. Only with optimization at every level can data achieve its full potential, enabling the (more...)

Hands-On Programming with R by Garrett Grolemund

R is a free software environment for statistical computing and graphics. It compiles and runs on a wide variety of UNIX platforms, Windows and MacOS.
R language is useful to become a data scientist, as well as a computer scientist. I mention a book that points about a data science with R. A Hands-On Programming with R Write Your Own Functions and Simulations By Garrett Grolemund. It was written how to solve the logistical problems of (more...)

Rolling Out-of-Place patching para Oracle Grid Infrastructure 12c y 11gR2: clonación en esteroides

Mi artículo más reciente para ToadWorld, dentro de una serie dedicada a aplicar patches con mínima suspensión del servicio. Ahora detallando cómo aplicar patches a Grid Infrastructure usando un Golden Image.

Greening of Storage

By Tim Gorman

I recall that the Dec 1999 or Jan 2000 issues of Nat’l Geographic magazine had a “Letters From The Editor” column that speculated, in jest, that the rate at which humans were saving back-issues of Nat’l Geographic magazine, would by the year 2100 result in the total accumulation of yellow magazines outweighing planet Earth.

Anyway, that statement resonated with me, because although I change residences every few years, it has only been (more...)