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

Israelis in the Wide World

I ran into this post on Linkedin talking about what non-Israeli people should expect when working with Israelis (and especially if they visit Israel for business). It’s a very nice read and it’s not long. After reading it (and laughing to myself, as it’s quite accurate), I decided to write this post. Most of the … Continue reading Israelis in the Wide World

Using Different Languages in Oracle – Part 2

In the previous part (you can find it here) I discussed the character sets Oracle supports and the length limits. In this part I’ll show how it is actually stored and discuss some more topics that are relevant to using different languages with Oracle. Seeing the Data In order to see how Oracle saves the data, … Continue reading Using Different Languages in Oracle – Part 2

Oracle 12.2 is Released!

Remember my post about Oracle 12.2 release date? I’ve heard rumors that Oracle changed the date to March 1st, and it was right! Oracle 12.2 is available for download for Linux x86-64, and Solaris (both SPARC and x86-64). I don’t know the release dates for other platforms. This is the download page: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html I’m downloading … Continue reading Oracle 12.2 is Released!

Even More 12.2 Features

A few days ago I was browsing the documentation and suddenly realized that I haven’t gone over the 12.2 books. One of the things I like to do is reading the “New Features” guide, so I did. After writing about the major features, here are some smaller ones, but still important enough to know. Transparent … Continue reading Even More 12.2 Features

Oracle 12.2 Release Date

Oracle 12.2 is going to be a very interesting one with lots of great features. I published a few blog posts about some of the features, you can read about it here: Oracle 12.2 Cool New Features More Cool 12.2 Features Oracle 12.2 Sharding Option I recently saw a tweet from Tim Hall mentioning a … Continue reading Oracle 12.2 Release Date

Did You Know #18 – Order By Position

When writing a query with order by, we can use the column position instead of its name. This order by”trick” is easy to use, but should be handled carefully as it affects the order of rows if the column list changes. For example, these two are equal: select col1,col2,col3 from table1 order by col1,col2; select … Continue reading Did You Know #18 – Order By Position