A Tip for using Excel to Validate HDL templates

HCM Data Loader (HDL) data ready to load into Oracle HCM Cloud is in pipe separated text file format, however most people will create and manipulate these files in MS Excel as it’s the handy swiss-army-knife for data manipulation that almost everyone is familiar with.

The way that we’ve worked is that we create template files containing the sheets and columns corresponding to the fields that the client is using, which the client then populates, (more...)

Oracle Forms 12c: Run Oracle Forms WITHOUT a Browser! New Runtime Options for More Flexibility Without a Browser

We are excited to post the first in our Oracle Forms 12c guest series and introduce our first contributor and a loyal member of the Oracle Forms Community, Holger Lehmann.  If you’re a Forms guru and want to contribute click here  for more information

We also have an awesome upcoming Oracle Forms 12c webinar with Michael :WEBINAR: ORACLE FORMS 12C: NEW FEATURES UNVEILED AND EXPLAINED – Register here!

Oracle Forms 12: New Runtime Options (more...)

Nested loop internals. Part 2: decision making

In the previous part of this mini-series we looked at differences in multiblock read behavior for different nested loop optimization mechanisms depending on degree of ordering of the data. In this post I’ll continue to explore the subject, but this time we’ll focus on decision-making process: what factors (other than the obvious ones — like optimizer hints and/or parameters) affect the specific choice of a mechanism?

Clustering factor

Previously, we saw that in all nested (more...)

What HCM Cloud content was popular in 2015?

The ‘Year in Blogging’ reports have come through so I can see what posts and newsletter items garnered the most views.

The Fusion Tipster Blog

So, according to the summary, the most popular post was Introducing OTBI-E, followed by What’s Coming in Taleo 14B, and then the posts on specialisation. Of those, only the former was written in 2015, with the other two coming from 2014. The other popular posts written in 2015 (more...)

SQL – is there a better way?

Next Tuesday at 11:20 am at Oracle headquarters there will be a panel discussion on SQL. You can participate whether you are there or not as we are collecting questions ahead of time and will video the panel to be posted later. The panel’s participants will be

Jenkins Plugin for Delphix

In my last blog I talked about trying out Jenkins. In this blog post I want to talk about the new Jenkins plugin for Delphix.

Delphix plugin

Delphix plugin is easy to add. Just navigate to “Manage Jenkins” in the top left

Screen Shot 2016-01-15 at 11.34.17 AM

Then click on “Manage Plugins”

Screen Shot 2016-01-15 at 11.34.27 AM

Then type in “delphix” in the search bar and then click on the “Delphix Jenkins plugin” to install

Screen Shot 2016-01-15 at 11.45.10 AM

Now we can access Delphix APIs through the Jenkins (more...)

Trying out Jenkins

Jenkins seems to be the top code build, integration and QA automation tool to support continuous delivery.

Jenkins allows me to kick of jobs on a schedule or ofter certain events and Jenkins will keep track of the status of the jobs and the results.

To get Jenkins installed,  I read wiki.jenkins-ci.org   and then read biouno.org to try my first Jenkins example.

I installed Jenkins  on one of the VMs from the “landshark” demo environment for (more...)

Another python graph – one wait event

Here is another graph that I created in Python with Pyplot:

onewait_medium

This is onewait.py on my github repository. Note that I blanked out the database name in the example graph to hide it.

This is a graphical version of my onewaitevent.sql script. It queries the AWR looking at a particular wait event per hour. You look at the number of wait events in an hour to see how busy the system was and then (more...)

Yes SQL ! the conference Jan 26 & 27 at Oracle

Wow, this is big – a Yes SQL conference !

Finally ! It’s here ! Yes SQL ! the conference!

At Oracle headquarters !

Send me your questions!

Have questions about SQL? about No SQL? about Yes SQL? About how Oracle is faring in the industry with SQL? I’ll be moderating a SQL panel discussion with

  • Andy Mendelsohn (Executive Vice President for Database Server Technologies)
  • George Lumpkin (Vice President, Product Management)
  • Bryn Llewellyn (Distinguished Product Manager)
  • Steven Feuerstein (Developer Advocate)
  • (more...)

Nested loop internals

Nested loop join appears like the simplest thing there could be — you go through one table, and as you go, per each row found you probe the second table to see if you find any matching rows. But thanks to a number of optimizations introduced in recent Oracle releases, it has become much more complex than that. Randolf Geist has written a great series of posts about this join mechanism (part 1, (more...)

New Website for FOEX online

Last year was very eventful at FOEX, which kept me occupied and kept me from blogging. Thankfully I managed to attend a few conferences and stay in touch with the community through Twitter and Slack on apex.world.

FOEX is growing a lot and needed a new website design, so we had a brainstorming meeting and decided to again build it in APEX.

Last week we finally decided everything for the website was ready (more...)

Public Appearances H1 2016

Here’s where I’ll hang out in the following months:

26-28 January 2016: BIWA Summit 2016 in Redwood Shores, CA

10-11 February 2016: RMOUG Training Days in Denver, CO

25 February 2016: Yorkshire Database (YoDB) in Leeds, UK

6-10 March (more...)

Covering bases

What would you think if you receive a complaint about plan regression with the following information (from SQL real-time monitoring report) about the good plan:


Global Stats
==============================================================================
| Elapsed |   Cpu   |    IO    | Concurrency | Fetch | Buffer | Read | Read  |
| Time(s) | Time(s) | Waits(s) |  Waits(s)   | Calls |  Gets  | Reqs | Bytes |
==============================================================================
|      99 |      64 |       36 |        0.00 |     6 |     (more...)

Trying Python and Pyplot for Database Performance Graphs

In the past I have used Excel to graph things related to Oracle database performance. I am trying out Python and the Pyplot library as an alternative to Excel.  I took a graph that I had done in Excel and rewrote it in Python. The graph shows the CPU usage within the database by category.  For example, I labeled the database CPU used by a group of web servers “WEBFARM1” on the graph.

Here is an example graph:

monday

You (more...)

Peeking table block contents

Sometimes you want to know what’s inside a certain block. Of course, the most straightforward way to do it is by dumping block contents using ALTER SYSTEM DUMP DATAFILE contents and analyzing it. However, “straightforward” doesn’t mean “simple”. Block dumps represent its contents in binary format which is hard to read. Sure, there are various utilities (like utl_raw) that can help you convert everything to the human-readable format, but it’s going to be a tedious (more...)

My 2015

Year 2015 was a very good one for me, even though not exactly in a way I expected it to be. I didn’t get to blog as much as I wanted to, and I didn’t get as many interesting performance troubleshooting to do as years before that. But there was lots of other interesting experiences — e.g. designing, running and analyzing all sorts of sophisticated performance tests for a candidate hardware platform.

Of course, (more...)

Smart Connections with BetterTouchTool

Terminal applications like iTerm2 are a great way to improve your efficiency when connecting to a remote host on your Mac.  As I started making my own shortcut keys I hit the wall.

When I have an OEM agent to check, I’ll log into the box, sudo to the binary owner, go the agent bin directory, and execute emctl status agent.

Here’s the wall:  Shortcut keys from iTerm could change directory and execute a command, (more...)

TurboTax Bug

It was quite annoying to find that TurboTax couldn’t send me a text message to confirm my order of a second state. However, I made the mistake of clicking the “Confirm my account a different way (takes longer)” radio button to get to their web page.

After I got two-step verification enabled on their web site, now it’s impossible to order the second state software. It appears that once you click that button, the software (more...)

Github Repository

I am experimenting with Github. I have created a repository for my Oracle database related scripts. Here is my Github URL: https://github.com/bobbydurrett/dba.git

You can clone this repository locally if you have git installed using this command:

git clone https://github.com/bobbydurrett/dba.git

I’ve had challenges before when I write a blog post about a script and then revise the script later.  It seems weird to update the post with links to the new version.  So, I’m thinking of (more...)

Enterprise Manager 13c Upgrade

My goodness me it’s been a long time since I updated here. As it’s nearly the season for New Years resolutions I thought I’d make one early and start updating again. This post is inspired by the release on Friday of Oracle Enterprise Manager 13c. Already there’s a nicely screenshotted How to Upgrade article by @gokhanatil . Step […]