Oracle Performance Tuning

Paperback (Print)
Used and New from Other Sellers
Used and New from Other Sellers
from $1.99
Usually ships in 1-2 business days
(Save 95%)
Other sellers (Paperback)
  • All (19) from $1.99   
  • New (4) from $18.0   
  • Used (15) from $1.99   
Close
Sort by
Page 1 of 1
Showing 1 – 3 of 4
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$18.00
Seller since Sat Jan 01 01:01:01 EST 2005

Feedback rating:

(332)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
2002 Softcover New

Ships from: Portland, OR

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$38.44
Seller since Tue Oct 07 09:35:53 EDT 2014

Feedback rating:

(294)

Condition: New
Brand New Item.

Ships from: Chatham, NJ

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$50.00
Seller since Tue Oct 07 09:37:03 EDT 2014

Feedback rating:

(184)

Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing 1 – 3 of 4
Close
Sort by

Editorial Reviews

From The Critics
Whalen and Schroeter run a performance tuning company, and here explain how to configure the Oracle database software package to perform optimally. Tuning must be done holistically, they argue, and optimal performance cannot be achieved by focusing on one part of the system. So they explore all areas from SQL statements to the operation of the disk drive. There is no bibliography. Annotation c. Book News, Inc., Portland, OR (booknews.com)
Read More Show Less

Product Details

  • ISBN-13: 9780672321467
  • Publisher: Addison-Wesley
  • Publication date: 4/16/2002
  • Pages: 432
  • Product dimensions: 7.40 (w) x 9.20 (h) x 1.00 (d)

Table of Contents

Introduction 1
Pt. I Instance Tuning
1 Tuning Fundamentals 5
2 Using the Oracle Configuration Parameters 23
3 Tuning the Oracle Instance 35
4 Performance-Enhancing Features 67
5 Tuning Workloads 103
6 The Oracle Performance Views 115
7 Using UTLBSTAT and UTLESTAT 125
Pt. II Oracle Hardware Topics
8 Oracle and System Hardware 163
9 I/O Concepts 179
10 Oracle and I/O 207
Pt. III Application and SQL Tuning
11 Using Explain Plan and SQL Trace 237
12 Index Tuning 255
13 The Oracle Optimizer 267
14 Tuning SQL 293
15 Using Hints 309
Pt. IV Advanced Topics
16 Oracle9i Real Application Clusters 331
17 Tuning Backup and Recovery 343
18 Creating a High-Performance Disaster Survival System 365
19 Oracle Networking Performance 377
Index 387
Read More Show Less

Preface

Each year, computer systems become faster. At the same time, memory and disk storage are becoming more plentiful and less expensive. Because of this, the means and the budget are now available to store vast amounts of information at relatively inexpensive prices. This has allowed users to increase the amount of data stored as well as increase the amount of processing that is done with that data. Because of this, society cannot simply solve performance problems by throwing more hardware at the problem. It's necessary to analyze, size, and properly configure systems to perform optimally.

For us, performance engineers, one of the problems that we see in the industry today is the introduction of large disk drives. At one time, it would have been necessary to configure 10 disk drives to hold the data that you have generated; you can now store the same data in 1 disk drive. What many people don't know is that this 1 disk drive is 10 times slower than 10 smaller disk drives. In this book, concepts such as this will be explained and explored.

Our philosophy in writing this book is that tuning must be done holistically. You cannot focus on one part of the system and achieve optimal performance. It is necessary to look at the application, the Oracle instance, the operating system, and the hardware and I/O subsystem to achieve optimal performance. In this book, we explore all areas of the system from SQL statements down to the operation of the disk drive.

We hope that you will use this book not only as a guide for learning Oracle performance tuning, but as a reference as well.

How to Use This Book

To keep the book interesting, we have added some personal anecdotes relevant to thesubject matter. We hope we have conveyed some of the excitement that comes when you push systems to their limits. Those of us who work in the database performance field constantly push the envelope of technology to achieve new levels of performance previously thought impossible. This kind of experimentation can be satisfying when everything works well, but frustrating when it doesn't.

Our hope is that, having read this book, you will have a basic understanding of how the components of the system work together to form the whole. If you have this foundation, you should be able to tackle a performance problem, know what to look for, and know how to fix it. Not all performance problems are alike, and solutions aren't either. It is important that you have a basic understanding of what to look for and what the possible solutions are.

If we have done our jobs correctly, you should finish this book with the ability to analyze the problem, hypothesize a solution, test that solution, and understand the result. We hope this book gives novices an idea of what performance engineering is all about. Seasoned professionals should receive new insight and ideas. By applying this newly acquired knowledge, you will find that tackling even the most complex performance problems can be broken down into simple, manageable tasks.

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)