Method R, LLCTechnical papers, published articles, standards, and essays by Cary Millsap and other Method R authors.
Cary Millsap
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.
Cary Millsap
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.
Cary Millsap
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.
Cary Millsap
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.
Cary Millsap
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.
Karen Morton
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.
Karen Morton
Oracle continues to add more and more automated features and advisors to assist with diagnosing and fixing problems. Given all this automation and advice Oracle is providing, a question to ask is whether or not all this advice is “dumbing us down” or “smartening us up.” This paper explores this question and asks you to…
Cary Millsap
“Measure Twice, Cut Once” is a reminder that careful planning yields better gratification than going too quickly into operations that can’t be undone. Often, however, it’s better to Measure Once, Cut Twice.
Cary Millsap
This paper explains the science behind why the number 2.0 is the magical key to batch queue management that maximizes performance for everyone.
Cary Millsap
In this paper, I will take a fun look at the dangers of several popular but bad guidelines, and I will offer alternative advice that helps you avoid the risk of costly performance management mistakes while not losing sight of the friendly goals: fast, easy, and cheap.
Cary Millsap
The enormous variety of technology options available in today’s open systems environment makes the role of system architect more critical than ever on both large and small projects.
Cary Millsap
This paper will help the reader configure a very large Oracle Server database (VLDB) for high performance and high availability with low maintenance.
Cary Millsap
The technical architect of an application system is responsible for building a system that meets the goals of the end users. To succeed, this person must combine the right hardware components with suitable application architectures, always obeying complex functional, operational, and economic constraints.
Cary Millsap
The OFA Standard is a set of configuration guidelines that will give you faster, more reliable Oracle databases that require less work to maintain.