Oracle and UNIX Performance Tuning with Cdrom

Overview

Oracle Senior Performance Engineer Ahmed Alomari covers virtually every relevant optimization technique in Oracle8, Oracle7, and three leading versions of UNIX: Solaris 2.6, HP-UX 11, and Sequent Dynix-ptx 4.4. He presents in-depth coverage of both OLTP and DSS applications, covering optimization of the UNIX kernel, memory, processors and I/O, and all these major Oracle8 performance enhancements.
Read More Show Less
... See more details below
Available through our Marketplace sellers.
Other sellers (Paperback)
  • All (8) from $1.99   
  • New (2) from $35.96   
  • Used (6) from $1.99   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$35.96
Seller since 2008

Feedback rating:

(169)

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
0138491674 BRAND NEW NEVER USED IN STOCK 125,000+ HAPPY CUSTOMERS SHIP EVERY DAY WITH FREE TRACKING NUMBER

Ships from: fallbrook, CA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
$50.00
Seller since 2014

Feedback rating:

(149)

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 All
Close
Sort by
Sending request ...

Overview

Oracle Senior Performance Engineer Ahmed Alomari covers virtually every relevant optimization technique in Oracle8, Oracle7, and three leading versions of UNIX: Solaris 2.6, HP-UX 11, and Sequent Dynix-ptx 4.4. He presents in-depth coverage of both OLTP and DSS applications, covering optimization of the UNIX kernel, memory, processors and I/O, and all these major Oracle8 performance enhancements.
Read More Show Less

Product Details

  • ISBN-13: 9780138491673
  • Publisher: Prentice Hall Professional Technical Reference
  • Publication date: 5/29/1997
  • Edition description: BK&CD ROM
  • Pages: 400
  • Product dimensions: 6.99 (w) x 9.22 (h) x 0.86 (d)

Read an Excerpt

PREFACE: Preface

The purpose of this book is to share my experiences in the areas of UNIX and Oracle performance and tuning. Although this book may be used as a reference guide for UNIX kernel or Oracle startup parameters, it is intended to be an overall reference for concepts. The chapters of this book provide a tremendous level of detail on the internal workings of the Oracle and UNIX kernel. The purpose of including so much detail is to give the reader a complete understanding of Oracle and UNIX. It is this understanding that will enable the reader to apply these concepts to specific applications and/or user environments, thus enabling the reader to maximize the performance of his or her environment.
It is a key characteristic of this book that only the latest versions of Oracle and UNIX are discussed. The book covers Oracle 7.2 and 7.3, Sun Solaris 2.4 and 2.5, Sequent Dynix 4.1 and 4.2, and HP-UX 10. This will enable the reader to focus on the functionality and enhancements of the new versions, avoiding discussion of old releases.
Another characteristic of this book is that I have organized it into two major areas: Decision Support and Transaction Workloads. I felt that rather than focus on areas in the Oracle kernel and discuss each parameter, I would focus instead on the workload and discuss the affected areas of the Oracle kernel per workload.

Recommended prerequisites for this book are a basic understanding of SQL, UNIX shell language, and experience with UNIX system and Oracle7 database administration.

I have been a user of Oracle and UNIX across many different platforms including Sun, Sequent, HP, VAX/VMS, MS-DOS, Windows, andIBM RT. In this book, I intend to cover in great detail the Sun Solaris, Sequent Dynix, and HP-UX operating systems.

I hope you enjoy this book and find it useful in mastering the areas of performance and tuning. To show my appreciation for UNIX, I had to start with a Chapter 0. Good luck, and away we go!

ACKNOWLEDGMENTS
This book is dedicated to my parents, Mukarram Alomari and Dr. Suha Alomari, and to Lana Gardi. My parents have always emphasized education and the pursuit of excellence. Lana Gardi is also a very special person in my life. Lana, soon to be my wife (hopefully by the time this book is published), has been wonderfully supportive of my career and the drafting of this book. Special thanks to my mother, Dr. Suha Alomari, who gives true meaning to the words commitment, dedication, and excellence. Her values and encouragement keep me constantly striving to excel.
Thanks to the rest of my family Mustafa, Mohammed, Munna, May, Abduallah, and Zena for their support and encouragement.

I would also like to sincerely thank Henry Dai of Oracle. It is a great pleasure to work woth such a talented technical inovator as well as a great manager and visionary.
I would also like to thank the Oracle engineers and support staff with whom I have had the pleasure of working on various issues. Thanks also to the Sun, HP, and Sequent engineers and support staff.
I would also like to thank the reviewers, Michael Machowicz, Omar Tahboub, and Salim Ahmed. Their diligent and careful review helped me improve the format and organization of the book.
Thanks also to Mark Taub of Prentice Hall and the Prentice Hall staff for the editing and publishing efforts of this book.
Best Regards, Ahmed Alomari EMAIL: aalomari@us.oracle.com

Read More Show Less

Table of Contents

List of Tables
List of Figures
Preface
Acknowledgments
Introduction
1 Inside the UNIX Kernel 1
2 Memory and Processor Tuning 35
3 Configuring and Tuning I/O 83
4 Application Tuning: Eliminating the SQL Bottleneck 131
5 Tuning an OLTP System 165
6 Tuning a Decision Support System (DSS) 223
7 Media Recovery 267
8 NCA and Objects 287
App. A Installing and Configuring UNIX for Optimal Performance 291
App. B Installing Oracle for Optimal Performance 295
References 299
Index 301
Read More Show Less

Preface

PREFACE: Preface

The purpose of this book is to share my experiences in the areas of UNIX and Oracle performance and tuning. Although this book may be used as a reference guide for UNIX kernel or Oracle startup parameters, it is intended to be an overall reference for concepts. The chapters of this book provide a tremendous level of detail on the internal workings of the Oracle and UNIX kernel. The purpose of including so much detail is to give the reader a complete understanding of Oracle and UNIX. It is this understanding that will enable the reader to apply these concepts to specific applications and/or user environments, thus enabling the reader to maximize the performance of his or her environment.
It is a key characteristic of this book that only the latest versions of Oracle and UNIX are discussed. The book covers Oracle 7.2 and 7.3, Sun Solaris 2.4 and 2.5, Sequent Dynix 4.1 and 4.2, and HP-UX 10. This will enable the reader to focus on the functionality and enhancements of the new versions, avoiding discussion of old releases.
Another characteristic of this book is that I have organized it into two major areas: Decision Support and Transaction Workloads. I felt that rather than focus on areas in the Oracle kernel and discuss each parameter, I would focus instead on the workload and discuss the affected areas of the Oracle kernel per workload.

Recommended prerequisites for this book are a basic understanding of SQL, UNIX shell language, and experience with UNIX system and Oracle7 database administration.

I have been a user of Oracle and UNIX across many different platforms including Sun, Sequent, HP, VAX/VMS, MS-DOS, Windows,andIBM RT. In this book, I intend to cover in great detail the Sun Solaris, Sequent Dynix, and HP-UX operating systems.

I hope you enjoy this book and find it useful in mastering the areas of performance and tuning. To show my appreciation for UNIX, I had to start with a Chapter 0. Good luck, and away we go!

ACKNOWLEDGMENTS
This book is dedicated to my parents, Mukarram Alomari and Dr. Suha Alomari, and to Lana Gardi. My parents have always emphasized education and the pursuit of excellence. Lana Gardi is also a very special person in my life. Lana, soon to be my wife (hopefully by the time this book is published), has been wonderfully supportive of my career and the drafting of this book. Special thanks to my mother, Dr. Suha Alomari, who gives true meaning to the words commitment, dedication, and excellence. Her values and encouragement keep me constantly striving to excel.
Thanks to the rest of my family Mustafa, Mohammed, Munna, May, Abduallah, and Zena for their support and encouragement.

I would also like to sincerely thank Henry Dai of Oracle. It is a great pleasure to work woth such a talented technical inovator as well as a great manager and visionary.
I would also like to thank the Oracle engineers and support staff with whom I have had the pleasure of working on various issues. Thanks also to the Sun, HP, and Sequent engineers and support staff.
I would also like to thank the reviewers, Michael Machowicz, Omar Tahboub, and Salim Ahmed. Their diligent and careful review helped me improve the format and organization of the book.
Thanks also to Mark Taub of Prentice Hall and the Prentice Hall staff for the editing and publishing efforts of this book.
Best Regards, Ahmed Alomari EMAIL: aalomari@us.oracle.com

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)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

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