Oracle New Version Numbering

Oracle is using the same numbering scheme since I’ve started working with it (7.2). The 5 number scheme with the release number, patchset and PSU is quite confusing and the post I wrote about that (here) is still very popular. But now, Oracle is changing that. They’ve decided to come up with a new and … Continue reading Oracle New Version Numbering

Reading AWR Report – Part 3

After talking a bit about the AWR report (if you haven’t read the previous posts, you can find part 1 here and part 2 here), I think one of the best ways to understand it is to talk about real examples. In this part I’ll give you a few examples and tips regarding the report. … Continue reading Reading AWR Report – Part 3

The Best KScope I’ve Been to

OK, so KScope17 was my first KScope, don’t be petty about it. I also know that it’s been already a month, but I’ve been doing a lot and didn’t have time to write. A week after KScope we’ve been to a family vacation in Alaska, then I went to a concert in Seattle (Counting Crows … Continue reading The Best KScope I’ve Been to

Reading AWR Report – Part 2

In the previous part I explained the top part of the report. In this part I’ll continue with the actual information about database activity, what we are looking for and other important things we can find in the report. Wait Events The table with the wait events is one of the most important in the … Continue reading Reading AWR Report – Part 2

Reading AWR Report – Part 1

Once in a while I get requests for some information about reading and analyzing an AWR report. I have been thinking for a long time about writing such a post, but always postponed it as it is a very tricky topic. The AWR (or statspack for that matter) report is huge and contains so much … Continue reading Reading AWR Report – Part 1

Did You Know #19 – Using LIKE

The LIKE operator is a very useful one. It is used to match strings with partial match while using the underscore (‘_’) as a single character wildcard and the percentage sign (‘%’) as multiple character wildcard. There are a few things you should know and some tricks you can use with the LIKE operator: The underscore … Continue reading Did You Know #19 – Using LIKE

Tips for Upgrading a Database

In February ’17 I participated in Mike Dietrich’s upgrade workshop and it was great! I don’t want to repeat stuff that he said there, you can read everything on his blog. This workshop made me think about upgrades I did in the past (and I did quite a few) and important things to think about before … Continue reading Tips for Upgrading a Database

ASM Disks Scripts

One of my customers is working with ASM and their database grows really fast. So every one in a while we need to add another ASM disk to the system. Before I add a new ASM disk, I usually verify that there is indeed a new disk in the system that is not being used. … Continue reading ASM Disks Scripts

Optimizer Bugs and Issues

I wrote before about optimizer changes after upgrades, so this is a quick post about some more information related to this topic. As I wrote in the post I mentioned above, most of the issues we run into after upgrading are performance related. I guess this is the case because it’s one of the most … Continue reading Optimizer Bugs and Issues

Working with Oracle Documentation

When I open Oracle documentation to look for something, people usually raise their eyebrows (almost as they do when I open sqlplus). Most of them simply say: “What do you need the documentation for? Just open google and search”. Even though googling stuff usually works, I actually like the documentation (in some aspects at least). … Continue reading Working with Oracle Documentation