Tags » Database Tuning

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

Scanning an Index

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, and different ways to use indexes that there is simply a lot to write about. 1,419 more words

Database Development

05 Simple Tuning Rules

Select Consideration

select * from sales_history


Select s.order_ID, s.product_ID, s.price, s.product_name

from sales_order s

The simplest rule is to select only the data you need… 292 more words