Measuring Response Times of Code on Oracle Systems

摘要

To many application developers, an Oracle database is just a "data store" with an API that they call when they need to persist an object. It's a helpful abstraction for managing functional complexity, but it can lead to some horrible performance problems. You can avoid those problems by better understanding what's going on inside the Oracle kernel. It's not that hard to do. The key is understanding how to measure how your code spends time inside Oracle. Once you've done that, your response time profile leads you exactly to your performance improvement opportunities.