Category Archives: DBA

When to rebuild an Oracle index?

For several years now it’s has been clear that we shouldn’t just rebuild an index. In the worst case this could make performance even worse than it used to be (for the next following days). So the question is “What indexes should be rebuilt?”. I just read this article from Jonathan Lewis that might just […]

DBA: Login as application user “without” the password

In an implementation description I wrote a while ago, the DBA resource should login with an application user and run a script. On the implementation day I received a call in the middle of the night. Something had failed. My first question was “Did you follow the documentation?” The answer was “Yes”. After a quick […]

Useful articles regarding statistics on partitions

One of the blogs that I´ve been following is Doug’s Oracle Blog. Doug has for instance written a series of articles regarding statistics on partitions. This series is definetly worth reading, and you can find the first article here: http://oracledoug.com/serendipity/index.php?/archives/1562-Statistics-on-Partitioned-Tables-Part-1.html