Categories
Oracle Monographs Papers

Death to the Health Check… Long Live the Health Check

Better Testing, Better Risk Reduction

I have a long history with conventional database system “health checks.” I don’t like them. I haven’t liked them for a really long time, since about 1997, when I realized that conventional health checks are an inferior way to help customers. There is a better way.

This is article number four in the Method R Oracle® Performance Monograph series. I hope you’ll enjoy it.

Categories
Oracle Monographs Papers

Better Testing, Better Risk Reduction

Better Testing, Better Risk Reduction

When your tests don’t measure your system the way your users will perceive it, you can be headed for big trouble. When you test, you should measure how your application is going to feel to your users. These measurements give you confidence both in the programs you’ve tested, and in the diagnostic process you’ll use later in production.

This is article number three in the Method R Oracle® Performance Monograph series. I hope you’ll enjoy it.

Categories
Oracle Monographs Papers

Preventing the Post-Production Performance Problem

Preventing the Post-Production Performance Problem

How confident are you that those new features you’re adding to your production application will be fast and efficient? What if they’re not? You need a process that finds inefficient code earlier, and a process to fix the inefficiencies that evade early detection. One process can accomplish both goals.

This is article number two in the Method R Oracle® Performance Monograph series. I hope you’ll enjoy it.

Categories
Oracle Monographs Papers

Solving the Unsolvable Performance Problem

Solving the Unsolvable Performance Problem

How do you solve production performance problems? The method you use may be structurally incapable of helping you find certain types of performance problems. Changing how you look at your system makes all the difference.

Over the past few weeks, I’ve been writing some short articles in a new series that I’m calling the Method R Oracle® Performance Monograph series. Today, I am releasing the first monograph, called “Solving the Unsolvable Performance Problem.” It’s a fast introduction to understanding why my team and I do what we do. I hope you’ll enjoy it.

Categories
Papers

Thinking Clearly About Performance

Creating “high performance” as an attribute of complex software is extremely difficult business for developers, technology administrators, architects, system analysts, and project managers. However, by understanding some fundamental principles, performance problem solving and prevention can be made far simpler and more reliable.

Categories
Papers

Why You Should Focus on LIOs Instead of PIOs

Many Oracle educators teach that reducing the number of PIO (“physical” I/O) calls should be the top priority of SQL optimization. However, in our field work, we commonly eliminate 50% or more of the response time from slow Oracle applications, even after they’ve been tuned to execute no PIO calls. The secret is that Oracle LIO calls are more expensive than many people understand.

Categories
Papers

For Developers: Making Friends with the Oracle Database

This paper describes how to use an Oracle Database tracing feature to write better, faster Oracle-based applications, regardless of whether your code is Java, PHP, C#, Ruby, Python, Perl, C, or something else.

Categories
Papers

My Case for Agile

Among many of my Oracle database administrator (DBA) friends, “agile” is widely regarded as a dirty word, a synonym for “sloppy.” However, adopting the principles of the Agile Manifesto (specifically, the implementation of the Agile Manifesto called Extreme Programming, or XP) has radically improved the commercial and technical success of projects that I’ve worked on.

Categories
Papers

Mastering Performance with Extended SQL Trace

Oracle’s extended SQL trace data stream contains a linear sequential record of every database call and every operating system call that the Oracle kernel executes in response to the code that you write.

Categories
Papers

Managing Statistics for Optimal Query Performance

Half the battle of writing good SQL is in understanding how the Oracle query optimizer analyzes your code and applies statistics in order to derive the “best” execution plan. The other half of the battle is successfully applying that knowledge to the databases that you manage.