External HDD Performance

This is not a technical post and it’s not related to the database world. It’s just a short experience I had with external HDDs as a simple user so I wanted to share it.

I have an Transcend external HDD for quit a while now. It’s a 2TB disk and it was very useful with my old laptop (where I only had 160GB SSD drive). Since I got my new laptop with 1TB SSD, I hardly use the external disk anymore, but I do keep backups on it (like a good IT guy). This disk contains a second copy of all of my pictures, some documents and other junk (called me old-fashioned, but I don’t want to backup all of this to the cloud).

Continue reading “External HDD Performance”

Order of Predicate Execution #1

In my previous post, I wrote about the parsing operation and what happens first. In the footnote I said that the order doesn’t affect performance, the cost based optimizer doesn’t care about the order of stuff in the query, right? Well, not quite.

Continue reading “Order of Predicate Execution #1”

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 parameter in the following version.

Continue reading “Did You Know #21 – Adaptive Features”

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”