Tags » Database Tuning

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

Reading AWR Report - Part 2

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 other important things we can find in the report. 687 more words

Database Tuning

Reading AWR Report - Part 1

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, but always postponed it as it is a very tricky topic. 822 more words

Database Tuning

Machine learning for database tuning: Mobiliar’s journey continues. Next stop Munich.

During the first week in May, I could share Mobiliar’s experience with the practical use of machine learning technology for DB2 systems tuning at IDUG’s annual North American DB2 Technical conference in Anaheim, CA. 529 more words


Optimizer Bugs and Issues

I wrote before about optimizer changes after upgrades, so this is a quick post with some more information related to this topic. 213 more words

Database Tuning