The books in O'Reilly's Oracle series are authoritative -- they tell the whole story about complex topics, ranging from performance tuning to the use of packages in PL/SQL to new technologies like Power Objects. And they're independent; they're alternatives for readers who need to know how products and features really work. They're packed with real-world advice and techniques from practitioners in the field, and they come with disks containing code you can use immediately in your own applications.
Oracle system performance inefficiencies often go undetected for months or even years--even under intense scrutiny--because traditional Oracle performance analysis methods and tools are fundamentally flawed. They're unreliable and inefficient.
Oracle DBAs and developers are all too familiar with the outlay of time and resources, blown budgets, missed deadlines, and marginally effective performance fiddling that is commonplace with traditional methods of Oracle performance tuning.
Tuning of SQL code is generally cheaper than changing the data model. Physical and configuration tuning involves a search for bottlenecks that often points to SQL code or data model issues. Building an appropriate data model and writing properly performing SQL code can give 100%+ performance improvement. Physical and configuration tuning often gives at most a 25% performance increase.
This book is about tuning Oracle databases. Three areas of Oracle Database tuning are data model tuning, SQL code tuning, and physical and configuration tuning. The author began his career as an applications developer, not as a systems or network administrator. As a result, this book is written from an applications rather than an operating system perspective.
Oracle Database Performance Tuning Guide is an aid for people responsible for the
operation, maintenance, and performance of Oracle. This book describes detailed
ways to enhance Oracle performance by writing and tuning SQL properly, using
performance tools, and optimizing instance performance. It also explains how to
create an initial database for good performance and includes performance-related
reference information. This book could be useful for database administrators,
application designers, and programmers.
This book covers everything you need to know to pass the OCP: Oracle8i
Performance and Tuning and OCP: Oracle8i Network Administration
exams. The first part of the book covers the most critical areas of database
performance tuning and how to follow and implement Oracle’s recommended
tuning methodology. The second part covers the topics of network
administration including configuring the necessary client and server components
of an Oracle network and helps you develop an understanding of the
Oracle 8i Net8 architecture....
Oracle Database 11g Performance Tuning Recipes is a ready reference for database administrators in need of immediate help with performance issues relating to Oracle Database. The book takes an example-based approach, wherein each chapter covers a specific problem domain. Within each chapter are "recipes," showing by example how to perform common tasks in that chapter’s domain. Solutions in the recipes are backed by clear explanations of background and theory from the author team. Whatever the task, if it’s performance-related, you’ll probably find a recipe and a solution in this book....
You can enhance Oracle performance by adjusting database applications, the database
itself, and the operating system. Making such adjustments is known as tuning.
Proper tuning of Oracle provides the best possible database performance for your
specific application and hardware configuration.
Note: Oracle8 Tuning contains information that describes the features and functionality
of the Oracle8 and the Oracle8 Enterprise Edition products. Oracle8 and
Oracle8 Enterprise Edition have the same basic features.
"Offers hundreds of hints, tips, and tricks of the trade that can be useful to any DBA wanting to achieve maximum performance of Oracle applications. No Oracle library would be complete without this book." --Ken (Dr. DBA) Jacobs, Vice President of Product Strategy for Server Technologies, Oracle Corporation
"Rich is the first and last stop for Oracle Database technology and performance tuning. His knowledge is a vital tool that you need to successfully negotiate the waters of Oracle database development." --Mike Frey, Principal Architect, Navteq
Oracle SQL Tuning with SQLTXPLAIN is a practical guide to SQL tuning the way Oracle's own experts do it, using a freely downloadable tool called SQLTXPLAIN. Using this simple tool you'll learn how to tune even the most complex SQL, and you'll learn to do it quickly, without the huge learning curve usually associated with tuning as a whole.
Firmly based in real world problems, this book helps you reclaim system resources and avoid the most common bottleneck in overall performance, badly tuned SQL. You'll learn how the optimizer works, how to take advantage of its latest features, and...
Oracle Corporation is one of the world’s largest vendors of
software for managing information. Oracle has over 12,000
employees with offices in 93 countries around the world.
One of the reasons Oracle software is so popular is the
diversity of platforms it supports. In fact, Oracle software
runs on almost every popular computer in the world and is
used everywhere from home applications to giant corpora-
After completing this lesson, you should be able to do the following:
Define the roles associated with the database tuning process
Describe the dependencies between tuning in different development phases
Describe service level agreements
Identify tuning goals
Identify common tuning problems
Employ tuning activities during developmentand production
Balance performance and safety trade-offs
This book is a quick-reference guide for tuning Oracle SQL. This is not a comprehensive Oracle tuning book. The purpose of this book is to give you some light reading material on my "real world" tuning experiences and those of my company, Mark Gurry & Associates. We tune many large Oracle sites. Many of those sites, such as banks, large financial institutions, stock exchanges, and electricity markets, are incredibly sensitive to poor performance. With more and more emphasis being placed on 24/7 operation, the pressure to make SQL perform in production becomes even more critical.
The Early Years at Oracle Through the Eyes of Bruce Scott
Prior to forming Oracle, Bob Miner was Larry Ellison’s manager when they worked at Ampex
together on a CIA project code-named “Oracle.” Larry chose Bob as his manager because he
liked Bob a lot more than his original manager. Ed Oates, another founder of Oracle, happened
to be walking by Bob Miner’s door when Larry Ellison mentioned his (Larry’s) wife’s name. She
turned out to be Ed Oates’ lab partner from high school.
Performance problems are rarely “problems” per se. They are more often “crises” during which you’re pressured for results by a manager standing outside your cubicle while your phone rings with queries from the help desk. You won’t have the time for a leisurely perusal of the manuals, nor to lean back and read a book on theory. What you need in that situation is a book of solutions, and solutions are precisely what Oracle Database 11g Performance Tuning Recipes delivers.
Recovery Manager Features
Recovery Manager (RMAN) is an Oracle utility that you use to manage the backup, restore, and recovery operations on Oracle databases. RMAN has a powerful command language that is independent of the operating system.
Recovery Manager has a command-line interface. Oracle Enterprise Manager also provides a graphical user interface for the Recovery Manager. Recovery Manager can be used on databases of Oracle8 or later releases.
RMAN provides several features not available when you make user-managed backups with operating system commands.
Oracle Server Configuration Options
Oracle creates server processes to handle the requests of user processes connected to an instance. A server process can be either a dedicated server process, where one server process services only one user process, or it can be a shared server process, where a server process can service multiple user processes. Shared server processes are a part of Oracle Shared Server architecture.
On occasion you will need to perform some tasks using SQL*Plus and/or the operating system command line. In Practice 2, you will start an SQL*Plus session. Continue to keep the SQL*Plus session open to accomplish those tasks done in SQL*Plus. When performing tasks that require the operating system command line, an [ ! ] will be used from the SQL*Plus command line to get you out of SQL*Plus and into the operating system command line mode. Once you have completed your work on the operating system command line you can return to the SQL*Plus command line...
Overview of Primary Components
The Oracle architecture includes a number of primary components, which are discussed further in this lesson.
Oracle server: There are several files, processes, and memory structures in an Oracle server; however, not all of them are used when processing a SQL statement. Some are used to improve the performance of the database, to ensure that the database can be recovered in the event of a software or hardware error, or to perform other tasks necessary to maintain the database. The Oracle server consists of an Oracle instance and an Oracle database.