Tags » Database Tuning

Order of Predicate Execution #2

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 happens. 651 more words

Database Development

Artificial stupidity as a DBA limitation of artificial intelligence

“Artificial intelligence is no match for natural stupidity” ― Albert Einstein

What about introducing Artificial Intelligence into the database to an extent it tunes itself into all possible dimensions? 609 more words

DBA

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? 436 more words

Database Development

Parse Order and Analysis

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 memory, but somehow, I actually remember some of the details). 460 more words

Database Development

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. 180 more words

Database Development

db file sequential reads - Oracle wait event

DB file sequential reads wait event comes under the User I/O wait class. In any busy system this is one of the most common wait event and normally appears in the top 5 wait events. 482 more words

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… 944 more words

Database Tuning