I just came back from RMOUG Training Days conference. It was my first time in Colorado (and obviously my first RMOUG training day) and it was really great (I wrote
I just came back from RMOUG Training Days conference. It was my first time in Colorado (and obviously my first RMOUG training day) and it was really great (I wrote
In the previous post I talked about the order of predicate execution based on the predicate position and inline view.As promised, in this post I’ll add statistics and see what
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
Over the years I’ve heard and learned quite a lot about how Oracle does stuff. Some of it was logical, some just details to remember (I have a really lousy
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
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
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
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,
I wrote before about optimizer changes after upgrades, so this is a quick post with some more information related to this topic.
The internet is full of information about indexes, and for a reason. Indexes in a database is probably the most important performance related topic. There are so many cases, properties,