CFP für Exaday 2017 gestartet


Es geht los bis zum 13.2.2017 können Vorträge für den Exaday 2017 rund um das Thema Oracle Engineered Systems eingereicht werden

Ich freue mich auf viele spannende Vorträge …

Der Exaday 2017 findet dieses Jahr am 20. Juni 2017 in Frankfurt – Mörfelden statt


The Call for Paper is opened until 13.2.2017

Please submit for the Exaday 2017 all around the topic Oracle Engineered Systems

http://exaday.doag. (more...)

Does it mean you work on boring stuff too?

Peter Sorger tweeted a not-so-serious question that is the title of this post, “Does it mean you work on boring stuff too?”

Absolutely… 🙂

Just to qualify that a bit, I work on a variety of things in my current job. Some I really enjoy, some I don’t enjoy so much. These days it’s really hard to be a specialist. To get stuff done you need a lot of different skills. I’m lucky that I (more...)

Resolve PDP Error for Named Credentials


Some of our named credentials use a privileged account to perform root actions via sudo. That account is not the same as the OEM agent binary owner and does not belong to the binary owner’s o/s groups for security reasons.

Sometime that causes problems, like this:

PDP execution may have failed 3430 Insecure operation – please consult your administrator pbrun8.5.1-01[112628]: 3201.07 Exec of /usr/bin/pb_sudo failed: Operation not permitted

The Powerbroker error is (more...)

Oracle Parallel Execution Deep Dive Session

Here is a recording of a session I did a while ago, covering how to understand the essentials of Oracle Parallel Execution and how to read the corresponding execution plans.

Logwriter I/O

If you are on any version of the database past, then savvy DBA’s may have noticed the following message popping up occasionally in their trace files

Warning: log write time 540ms, size 444KB

In itself, that is quite a nice little addition – an informational message letting you know that perhaps your log writer performance is worth closer investigation.  MOS Note 601316.1 talks a little more about this message.


Multitenant Enhancements in Oracle Database 12.2 (The Next Batch)

I’ve continued playing with some of the new multitenant functionality in Oracle Database 12c Release 2 (12.2).

Here’s the latest batch of articles.

Oracle’s Safra Catz and Trump’s Transition Team

I receive about 20-30 messages a week from women in the industry.  I take my role in the Oracle community as a role model for women in technology quite seriously and I’ve somehow ended up speaking up a number of times, upon request from different groups.


Although its not the first time the topics come up, I was asked last week for some recommendations on Oracle’s CEO, Safra Catz (more...)

Fast-Start Failover for Maximum Protection in #Oracle 12c

Fast-Start Failover is supported with Maximum Protection in 12cR2. Also Multiple Observers can now monitor the same Data Guard Configuration simultaneously. I will show both in this article. Starting with a (Multitenant) Primary in Maximum Protection mode with two Standby Databases. It is still not recommended to have the highest protection mode configured with only one standby. So this is my starting point:

DGMGRL> show configuration;

Configuration - myconf

Protection Mode: MaxProtection
cdb1 -  (more...)

DBCA and DBUA no longer function after applying Windows DB Bundle Patch 24922870 –

It’s been discovered that after applying Windows DB Bundle Patch 24922870, both DBCA and DBUA no longer function and give the following error:


Oracle Support have only filed a bug on Wednesday this week (11th January 2017):


So if you’re planning to use either DBCA or DBUA after applying the patch, you might want to hold off till (more...)

An introduction to PCP / Performance Co Pilot on Oracle Linux

I was investigating gathering performance data on (oracle) linux servers recently and came across Performance Co-Pilot (PCP). I have come across this product regularly in the past, but it seemed somewhat abstract to me, and I never ran into any actual usage. And we got sar for linux performance data and for the Oracle database we got oswatcher (and it’s exadata cousin exawatcher) and TFA right? How wrong I was.

First let me explain a (more...)

Creating a RAC 12.1 Data Guard Physical Standby environment (2)

In the first part of this mini-series you saw me define the environment as well as creating a primary database. With that out of the way it’s time to think about the standby. Before the standby can be created, a few preparations are necessary both on the primary as well as the standby cluster.

NOTE: As always, this is just a demonstration using VMs in my lab, based on my notes. Your system is most likely (more...)

use_nl hint

In response to a recent lamentation from Richard Foote about the degree of ignorance regarding the clustering_factor of indexes I commented on the similar level of understanding of a specific hint syntax, namely use_nl(a b) pointing out that this does not mean “do a nested loop from a to b”. My comment was underscored by a fairly prompt response asking what the hint did mean.

Surprisingly, although I’ve explained it many times over the last (more...)

Extending Flashback Data Archive in 12c

Flashback Data Archive (previously called Total Recall) has been around for a long time now. For those unfamiliar with it, (and by the way, if you are on Enterprise Edition, you should be familiar with it, because its a free feature), here is a very quick primer.

Create a tablespace to hold your history, and create a flashback archive using that space allocation.

SQL> create tablespace SPACE_FOR_ARCHIVE
  2  datafile 'C:\ORACLE\DB11\ARCH_SPACE.DBF' 
  3  size 100M;

Tablespace  (more...)

Unable to perform initial elastic configuration on Exadata X6

I had the pleasure to deploy another Exadata in the first week of 2017 and got my first issue this year.

As we know starting with Exadata X5, Oracle introduced the concept of Elastic Configuration. Apart from allowing you to mix and match the number of compute nodes and storage cells they have also changed how the IP addresses are assigned on the admin (eth0) interface. Prior X5, Exadata had default IP addresses set at (more...)

Cloud Control 13c Release 2 (13cR2) : It’s In Production Now

I didn’t think there would be quite so many posts about this journey, but we finally have Cloud Control 13cR2 in production, monitoring all our Oracle Database and WebLogic servers, and scheduling all our database backups.

Here are some of the posts that came out when I thought we would be using 13cR1.

The Most Important Tool for SQL Tuning

SQLT is a tool that collects comprehensive information on all aspects of a SQL performance problem. SQL tuning experts know that EXPLAIN PLAN is only the proverbial tip of the iceberg but the fact is not well recognized by the Oracle database community, so much evangelization is necessary.

I remember the time I was trying to solve a production problem a long time ago. I did not have any tools but I was good at (more...)

KeePass 2.35

I just noticed KeePass 2.35 was released yesterday. You can download it here.

You can read about how I use KeePass and KeePassX2 on my Mac, Windows and Android devices here.



KeePass 2.35 was first posted on January 10, 2017 at 4:46 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then (more...)

ilOUG Oracle Technologies Meetup Group

I have a confession: I love Oracle User Groups. Here. I said it.
I think that the idea of a community gathered around common professional interests and expertise are great. It’s an opportunity to meet you colleague and learn a thing or two you don’t get to work with on a daily basis from your peers. For junior DBAs it’s even more important. They have the opportunity to look into their future and see where (more...)

Join Elimination 12.2

From time to time someone comes up with the question about whether or not the order of tables in the from clause of a SQL statement should make a difference to execution plans and performance. Broadly speaking the answer is no, although there are a couple of boundary cases were a difference can appear unexpectedly.

When considering join permutations the optimizer has a few algorithms for picking an initial join order and then deciding how (more...)

Script: Finding the Top N Queries for a User (AWR)

In some conditions, I need to find the top N queries for a specific user in the database.
Assuming my customer is running Enterprise Edition and have tuning pack licenses, it is easy enough to pull the data off the Automatic Workload Repository (AWR).

For some reason, a lot of DBAs are not aware that the AWR report is just a report – and you can query the base table yourself to extract more information (more...)