Over the past 6 months I have been trying to push myself to use extended events (XEvents) over SQL trace, once you get past the learning curve it’s probably the way to go. If you are operating in the Azure … Continue reading
Related Articles
SQL Optimizer for Oracle – a success story
Here's a SQL Optimizer success story! SQL Optimizer for Oracle automates the SQL optimization process and maximizes the performance of our SQL statements. SQL Optimizer analyzes, rewrites, and evalua...
Oracle Multi-Threaded Server – Overview
Multi-threaded server is not something that should implemented just because it exists. MTS has a specific purpose and, like any other feature, it comes with a set of trade-offs that you should conside...
RAC Wait Event Enhancements in Oracle10g
Starting from Oracle10g, most of the RAC related wait events could be further classified in two types, namely 'place holder' events and 'fix up events'. For example, when a cr request is initiated, th...
