Another stupidly early start, so another night of no sleep, worrying about missing my flight.
I was up at 04:00 to get a taxi into the airport. The queues were massive, but for some reason I had a business ticket for the outward leg, so I could use the express lane and walk straight past the hordes of people and into the lounge. Happy days.
The first flight was Birmingham to Munich, which took about 90 (more...)
In the last week, I had two customers that had some failures with their standby databases and contacted me about closing their DG gaps. Since this kind of problems is common, and since the solutions are fairly easy I thought it worth a post to document this for their and your use.
Before we begin, let’s understand what dataguard gaps are. There are two types of gaps: transport and apply gaps. The transport gaps problem (more...)
A couple of days ago I got an email from someone who had seen me speak at the Oracle Code : London event, asking if I would come and have a chat with them about Oracle, the Universe and everything. Since I was already booked off work, I said, “What about tomorrow?”, and it was arranged.
So I spent yesterday afternoon speaking with three guys who were based in Birmingham, and a couple of guys based (more...)
Just a couple of certification related updates.
Upgrade to oracle Database 12c (1Z0-060)
About a week ago I finally got round to doing the 12c certification. As followers of the blog/website know I’ve been writing articles about Oracle Database 12c since it was released nearly 4 years ago and for pretty much all of that time I’ve been trying to convince myself to sit the 12c OCP DBA upgrade exam. It’s not that I care about the (more...)
I recently had some feedback from UKOUG Tech 16 and OUG Ireland. I was pleased with the evaluation numbers, but if I’m honest I find it hard to judge a lot by them. I typically get a lower score for “quality of slides” compared to the other areas, but I can’t really argue about that. The number of evaluations that include comments is a small fraction of the total evaluations returned, but it’s the first thing (more...)
I am quite excited to have been accepted to speak at the upcoming DOAG Exaday taking place June 20 in Frankfurt. It is the third time I have been lucky enough to present at the event, having spoken both in Frankfurt in Hamburg in previous years.
As you can probably imagine by looking at this weblog, I am a great supporter of the Oracle Engineered Systems community. My interest is not limited to Germany: I still remember (more...)
As developers, sometimes we set something running that we wish we hadn’t And naturally, we’d like to be good IT citizens and clean up the mess as quick as we can. (For most of us, this means – cover our tracks before the phone rings about smoke coming out of the server). But of course, getting an administrator to hand over the trigger to let you have the ALTER SYSTEM KILL SESSION (more...)
A little while ago Jeff Smith asked me if I had done anything with the collation functionality in Oracle Database 12c Release 2 (12.2). At the time my response was I was letting it stew a little before I released anything about it.
For some functionality the manuals contain a lot of information, but it’s not always obvious how much you will really care about. The collation functionality is exactly like that. You can get (more...)
(Yes. And Ansible. And Oracle…) TL;DR. This is the repo I’ll be talking about. It can use Ansible to provision Oracle (SI/RAC). Like I’ve said before, I use Vagrant quite a lot and I basically have 2 configs that I use every time. One that uses an external ‘hosts.yml’ to define the hosts (ip, ram etc) […]
It’s hard to understand all the ramifications of Oracle’s undo handling, and it’s not hard to find cases where the resulting effects are very confusing. In a recent post on the OTN database forum resulted in one response insisting that the OP was obviously updating a table with frequent commits from one session while querying it from another thereby generating a large number of undo reads in the querying session.
It’s a possible cause of (more...)
I’ve wrote in previous post
4. Next row piece can be stored in the same block only with inserts. When you run update, oracle will place new row piece into another block.
But it’s not valid anymore 🙂 Since 12.2 Oracle optimizes updates too.
You can check it on 12.2 and previous version using example 4 from previous post:
drop table test purge;
set serverout on
alter session set tracefile_identifier='test4';
As usual with early starts, I had a terrible nights sleep, worrying I would sleep through my alarm. I’ve been quite nervous about this event ever since I found out I got accepted. I’m pretty comfortable in front of your typical Oracle crowd, but having no idea about the makeup of this audience freaked me out. My feeling was if the crowd was made up of Oracle techies looking to find out about different stuff I should fit in OK. If it was (more...)
You probably know that there’s an official github repository storing Dockerfiles and samples to build Docker images for Oracle products and Open Source projects. Now Oracle takes one more step to support Docker. Oracle Brings Oracle’s Flagship Databases and Developer Tools to the Docker Store (you can read the official announcement). Oracle Linux was already on the Docker Store. Oracle Database 18.104.22.168 Enterprise Edition, Oracle client tools, Oracle Weblogic, Oracle (more...)
I wrote a post a few months ago where, amongst other things I mentioned my views on Oracle database versions, releases and patchsets. To summarise my points.
- What we used to know as releases (12.1, 12.2) are now so big they are essentially new major versions, despite what the version numbers suggest. That’s reflected both in the content and the time between them.
- What we used to know as patchsets are now more (more...)
I submitted two abstracts for Oracle OpenWorld 2017. I have two talks that I have thought of putting together:
- Python for the Oracle DBA
- Toastmasters for the Oracle DBA
I want to do these talks because they describe two things that I have spent time on and that have been valuable to me.
I have given several recent talks about Delphix. Kyle Hailey let me use his slot at Oaktable World in 2015 which was at the same time (more...)