MultiTenant, Database, Performance, Licensing, DBA

Enable Enterprise Manager Express

There are many blogs about the product and so on. I want to recommend that you enable and give your developers access to it. Setting them up and getting them to scale the mountain of complexity that is the normal Enterprise Manager is probably not what you want to do. However, EM Express is a slimed down version focusing pretty much on just what a developer ought to care about, seeing the processes in the database and data about how […]

Database, SQL, Performance, DBA

Add hint to SQL you cannot modify

The last post showed how to lock the plan for a SQL that switched plan every now and then. Another common issue one can encounter is that of a SQL that uses a suboptimal plan and for which you’d want it to use a different plan. The way to instruct the optimiser to use a different plan is to use a hint to cause it to change how it accesses the table. But often the SQL is in application code […]

SQL, Performance, DBA

Lock the plan for a SQL

A SQL that sometimes just uses a plan you prefer it to not use is fairly common. There are always reasons for unstable plans, but more important than knowing the reason is often to make it stick to a certain plan. This has historically been done with a lots of ways from changing the SQL, adding hints, adding incorrect stats to influence the optimizer, using any of the techniques that came before SQL Plan Management (SPM). All of these has […]

Performance, Oracle Cloud, DBA

Grabbing an AWR without access to the database server

Getting an AWR can sometimes be difficult. If you are on an autonomous database you cannot log in to the database server and run your trusty old script for it. Other times you may not have the access and cannot get the DBA to find time to help you with it every time you want to look at one. Fortunately you can leverage your PL/SQL skills and just get it through any tool you want to use. The first thing […]

Database, Performance, DBA

Dumb Oracle refuses to use my great index

Let me tell you a story about a developer, let’s call her Sue, that had proved that Oracle was having mood swings and just didn’t use a perfectly good index even though it was the perfect index to use. This of course made Sue very upset and she spared nobody from her bitter words about how unreliable and temperamental the database was. It just wasn’t willing to use the index because it was stubborn. Poor Susan was the DBA having […]

Wallet, DBA

Update on creating wallet

I held a live stream for SWEOUG that presented what my last two blogs covered. It was my first ever and while it was a bit uncomfortable to set up to not see your audience it worked well. In fact it was really enjoyable and I look forward to doing more. In the stream Ilmar Kerm made a few comments about what I said. I was not able to fully grasp it during the stream, but I talked to Ilmar after to […]


Wallet setup for https

In the last blog post I wrote about how to access an HTTP-resource and the ACL needed for it. That works great for HTTP, but as the world is turning to HTTPS it is not enough in most cases. In this post I will look at how to set up the trust store in a database to allow access to an HTTPS-based access. I will use the same simple select grabbing the html for a webpage to show how it […]

Performance, DBA

Waiting for direct write temp – but what file?

This is essentially a not for myself for the next time I forget. It seems to be like once every other year I figure this out. It is not too easy to google for so it usually takes a bit too long. So you have identified the event “direct path read temp” or “Direct path write temp” as your main culprit in a SQL. Great, now let’s just see what temp file it is. That is how I’ve started a […]

Oracle, DBA

Quick note on MT and applications II

Talking about Multi Tenant and applications, one has to talk about the different options for sharing. It is one of the great features of multi tenant. It is a way to let one PDB – the application root –  have data that can be used from other PDBs. There are three kinds that allow you to get different features of the sharing. Metadata Data Extended Data Lets review each kind and why and how you’d use it. Metadata This allows you […]

DBA, Versioning, SQL

An old dog learns a new trick

Reports of this blogs death have been greatly exaggerated. It has been very quiet here though while I worked on getting the Swedish part of Miracle started. It is now rocking the Stockholm market so it’s time to get back into more geeky stuff. Talking of which. I have encountered Liquibase for database versioning time after time and always come to the conclusion that it is not what a DBA want to use. I recently took it out for a spin […]