Top 60 Oracle Blogs

Recent comments

March 2016

Collaborate 16: My sessions

I’ll be at Collaborate 16 next month and looking forward to seeing lots of good friends, learning some new things, and sharing a little experience too. For the last of those, I’ll present 3 sessions, er, more like 2.2 sessions:

Adding GPIO Pins to the Raspberry Pi Zero

Although the Raspberry Pi 3 is now available, many people are still interested in it’s cheaper, smaller version, the Raspberry Pi Zero.


A posting on the OTN database forum a few days ago demonstrated an important problem with hinting – especially (though it didn’t come up in the thread)  in the face of upgrades. A simple query needed a couple of hints to produce the correct plan, but a slight change to the query seemed to result in Oracle ignoring the hints. The optimizer doesn’t ignore hints, of course, but there are many reasons why it might have appeared to so I created a little demonstration of the problem – starting with the following data set:

Views as “stored text”

You’ll often see comments that views are not copies of the data, they are merely the stored text of a query that defines.

This is by and large true, but don’t forget, this is not  the same as saying we simply take whatever text you give us, and store it.

Let’s take a look at a simple example proving that this is not the case.

RMOUG’s Movie Night and WIT Panel

Last night I attended our RMOUG WIT’s movie night.  We partnered with Regis and the choice in movie has received a lot of great reviews, titled, Code-  Debugging the Gender Gap.

New Series of EM Blog Posts

One thing I like seeing is how people use Enterprise Manager. It’s one of the most enjoyable parts of speaking at conferences (apart from the social networking, of course), because quite often the users of Enterprise Manager find ways of using the product that we in Product Management might never have thought of. Sometimes that can lead to useful product enhancements, and other times it leads to much head shaking in disbelief (but since I don’t like exposing that side much you’ll have to grab me at a conference to hear some of those more “interesting” examples!)

Oracle Midlands : Event #14 – Summary

Last night was Oracle Midlands Even #14 with Lothar Flatz.

The session started with “Raiders of the Data Dictionary I: Indexing for the Workload” where Lothar discussed a project he worked on based around completely revamping the indexing of a system. I guess the best way I can describe it is to say it’s a more scientific approach to indexing, using the contents of the dictionary to provide information about columns and column groups used in queries to determine the indexes to create. In some ways the approach was quite extreme (throw everything away and start again), but I also admire the bravery of that approach!

Database dictionary corruption ? Maybe not.

At first glance, this looks like a major drama. Some sort of database dictionary corruption, or internal error. But we’ll see, it’s actually fine.

Let’s do a simple describe on an existing table

 Name                          Null?    Type
 ----------------------------- -------- --------------------
 EMPNO                                  NUMBER(38)
 ENAME                                  VARCHAR2(30)
 HIREDATE                               DATE
 DEPTNO                                 NUMBER(38)
 SAL                                    NUMBER(38)

Now of course, that could a synonym, or a view… so let’s also make sure that we are actually dealing with a real table.

Creating and Verify RSA SSH Keys

As we migrate to the cloud, secured credentials are starting to become a standard in most DBAs worlds.  If you don’t take the time to understand ssh keys and secured credentials, well, you’re not going to get very far in the cloud.

Hybrid Gateways and the Oracle Public Cloud with EM13c

This is going to be a multi-post series, (I have so many of those going, you’d hope I’d finish one vs. going onto another one and coming back to others, but that’s just how I roll…:))