ODC Appreciation Day – Plan Statistics

If you don’t know that by now, OTN (Oracle Technology Netowrk) has changed its name to ODC (Oracle Developer Community), so OTN Appreciation Day becomes ODC Appreciation Day. This initiative started by Tim Hall from ORACLE_BASE last year. In this day, every blogger writes something to thank Oracle for. You can read about the concept … Continue reading ODC Appreciation Day – Plan Statistics

Did You Know #22 – Reproduce SQL Issue

During OOW17 a customer ran into a wrong result issue in 11.2.0.4, which is very bad. I diagnosed this and found out that it happens because of bloom filter, so we just disabled that and it was solved. But I still opened an SR so Oracle can find and fix this bug. Wrong results bug … Continue reading Did You Know #22 – Reproduce SQL Issue

The English Language

I wrote this post quite a while ago and it stayed as draft since. A few days ago, during Oracle Open World 2017, I had a long chat with Jim Czuprynski and somehow we got to talking about the English language. As you well know by now, I’m not a native English speaker, but Jim … Continue reading The English Language

Did You Know #21 – Adaptive Features

When Oracle are adding a new feature to the database, they usually add a parameter to control it. Sometimes, after adding feature and the parameter, they realize that the parameter they chose for controlling the feature is not suitable. It might be confusing, or too general or something else. In these cases they change the … Continue reading Did You Know #21 – Adaptive Features

OSWOUG Event in Portland

I’m on my way back home after spending the day in Portland for the OSWOUG (Oregon and South Washington Oracle User Group) event. As usual (mostly) I’m writing about conferences and events I’m attending, especially if I had a good time. It all started a few months ago when I met Jon Wasserman at the … Continue reading OSWOUG Event in Portland

Oracle Support Rocks (Sometimes)

I wrote in the past about my frustration with Oracle support. I also hear from customers and colleagues about their frustration with Oracle support, from different reasons. People like to complain when something doesn’t work well, however, I’m writing this post to tell about excellent experience I had with the support lately. One of the … Continue reading Oracle Support Rocks (Sometimes)

Did You Know #20 – Exporting Views

Starting with Oracle 12.1 we can export views as tables. This means that the export will contains a “create table” command and its data, while the original object was actually a view. If we use this command: It will export the view as a view (import will perform CREATE VIEW) Now we can use the … Continue reading Did You Know #20 – Exporting Views

Diagnosing Listener Issues in RAC

I’ve written a few “diagnostics” posts in the past (you can see them all under the “Troubleshooting” category). People really like these type of posts, and I got many comments about them in the past (good ones…), so here is another case that I had not too long ago. I’d like to thank Kadhir Velavan, … Continue reading Diagnosing Listener Issues in RAC

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