| |
All of the following articles may be viewed free of charge. You have permission to distribute these materials within your company; but you may not, however, re-publish any articles without first asking for permission.
Thanks, Guy.
 Top 10 Strategies for Oracle Database Performance
Toad World PIPELINE Newsletter, Jan/Feb 2010
 |
Everybody loves Top 10 lists, but for a database as complex as Oracle it's hard to distil performance tuning best practices into a single book, let alone a list of 10 tips. Nevertheless, in this 3-part series of Toad World articles I'll try my best to present the 10 performance tuning concepts that I consider most important when optimizing Oracle database performance.
Part 1: Guy discusses adopting a tuning methodology, the importance of design and guidelines for indexing.
 (PDF, 268 KB)
Part 2: Guy provides an overview of the foundation tools that you can use to measure SQL and database performance, optimizing the Oracle optimizer to maximize SQL performance and methods for optimizing SQL statements that do not optimize successfully.
(PDF, 383 KB)
Part 3: Guy covers strategies that optimize the lower levels of database processing, such as contention for locks and latches and the optimization of IO.
(PDF, 320 KB)
Part 4: In the final installment, Guy considers the performance optimization of Oracle Real Application Clusters (RAC).
(PDF, 417 KB).
|
|
Cloud computing is a heavily overused term, applied to wide range of offerings such as Gmail and Flicker as well as Cloud platforms such as Windows Azure, Google App Engine and Amazon Web Services environment. I generally define cloud computing as the provision of virtualized application software, platforms or infrastructure across the network, in particular the internet.
Web Services (AWS) have taken an early market, technology and mindshare the lead in the Infrastructure as a Service (IaaS) category of cloud computing. AWS and similar offerings provide virtualized server resources together with other infrastructure (messaging, database, etc) over the internet. Customers build their application stack using these components. Amazon probably provides the richest IaaS stack including distributed storage (S3), cloud database (SimpleDB), messaging (SQS) and payments (FPS).
Ever since Oracle announced support for Amazon AWS at Oracle Open World I’ve been eager to play around with it. This week I managed to find the time to set up a test database and thought I'd share my experiences with ToadWorld readers.
|
Tuning MySQL SQL Code
Quest-Pipelines, June 2008
This paper covers the tools and various methods available for tuning poorly executing MySQL SQL code. MySQL has a well deserved reputation as a light-weight and efficient database server capable of meeting the requirements of even the most demanding high volume web applications. Nevertheless, as the part of your application that does virtually all the disk IO, it's going to be the source of a significant proportion of your application response time. Therefore, if you want your application to meet its full performance potential, you should not shirk on tuning the MySQL SQL code. ...
|
Systematic Oracle Performance Tuning
SELECT Magazine, Q4 2006
A mission critical application system is experiencing unsatisfactory performance. As an experienced Oracle performance specialist, you are called in to diagnose the problem. You’re well versed in modern wait-based performance profiling oriented performance diagnostics (such as “YAPP” 1), so the first thing you want to determine is which wait category is consuming the bulk of non-idle time. Looking at V$SYSTEM_EVENT, you immediately see that the database is spending the vast majority of it’s time within ‘ db file sequential read ’ events. Furthermore, the average time for each of these events – which represent single block reads against database files – is more than 20ms which is far higher than the service time you expect from the expensive and sophisticated disk array supporting the application.
|
Can your project win the database race?
Software Test and Performance, Nov 2005
Most mission-critical business applications have at their core a relational database that maintains key persistent information. The performance of that relational database is absolutely critical -- often the most important factor in the overall performance of the application. For this reason, when testing a database-driven application, it pays to give special attention to database performance. ...
|
Resolving Oracle latch contention
Quest-Pipelines, April 2005
This paper presents an overview of how the Oracle RDBMS uses latches to protect shared memory, the typical causes of and solutions to latch contention, and summarizes some research conducted at Quest Software that suggests that manipulating the (now) undocumented parameter “_spin_count” can be effective in relieving otherwise intractable latch contention problems. ...
|
Application Insight Articles:
|
 |
|