Category Archives: Script

Template for creating data owners and application users

How many times haven’t I seen applications logging onto the Oracle database as the schema owner. This is definitely not good practice. And usually by the time the DBA discovers this, it’s “to late” to change. I’ve heard managers say: “It will be to expensive and to much of a risk changing this now”. (Note! […]

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 […]