Blog Archives

January 13, 2015

In the previous instalment of this series I introduced three ways of accessing the run-time statistics for a query and described, for one of the methods, the basics of the information we can get and how we can use it. In this article I want to expand on the use of one method to show it can help use identify… Continue Reading →

All Things Oracle Full Articles, Database Administration, Database Development

We have a new DBA in training and part of my job is to mentor and demonstrate good Oracle practices. Here’s a write up I made for him on how I solved a performance issue. Issue: The BI team complained about a large query in out production BI database that had been running slowly for the past few days. Steps to resolve: Action… Continue Reading →

11g, Database Administration, Performance Tuning, Troubleshooting