Now, the #1 guide to Oracle tuning on UNIX platforms has been thoroughly updated for Oracle 8i. Oracle Senior Performance Engineer Ahmed Alomari covers every relevant optimization technique for every leading application and development approach -- including Web-centered development! Alomari presents in-depth coverage of both OLTP and OLAP/DSS applications, covering optimization of the UNIX kernel, memory, processors and I/O, key benchmarking and lifecycle issues, and all these major Oracle8/8i performance enhancements: Partitioning, star queries, parallel DML, the Connection Manager, connection pooling, multiple buffer pools, Parallel query enhancements, I/O slaves, multiple DBWR processes, optimizer and PRO*C enhancements, and more. Discover Oracle8/8i and UNIX installation options that supercharge performance. Learn new techniques for optimizing object-relational databases. Ruthlessly eliminate the bottlenecks in your SQL code. No matter how long you've been running Oracle and UNIX, you'll run them faster -- and smarter -- with Oracle8i & UNIX Performance Tuning.
Book Description
Editorial Reviews
From the Inside Flap
Preface
The purpose of this book is to share my experiences in the areas of UNIX and Oracle performance and tuning. The chapters of this book provide a tremendous level of detail on the internal workings of the Oracle and UNIX kernels. 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, such as Oracle8i and Solaris 8. 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: data warehousing and Online Transaction Processing (OLTP). This edition of the book places more of an emphasis on application tuning since the application has the most control over the overall performance and scalability. It is important that the application be well designed and highly optimized.
Recommended prerequisites for this book are a basic understanding of SQL, UNIX shell language, and experience with UNIX system and Oracle database administration.
I have been a user of Oracle and UNIX across many different platforms including Sun, Sequent, HP, VAX/VMS, MS-DOS, Windows, and IBM RT. I hope you enjoy this book and find it useful in mastering the areas of performance and tuning. Good luck, and away we go!Complementary Materials
An ftp directory has been created to accompany this book at ftp://ftp.prenhall/pub/ptr/database.w-050/alomari. The directory contains white papers, utilities, and scripts available for download. The material in the ftp directory offers additional information associated with Oracle8 such as architecure white papers, product features, and performance tuning tips. There are also SQL scripts that can be used to monitor database performance. Best Regards,
Ahmed Alomari
Ahmed.Alomari@oracle
From the Back Cover
Achieve breakthrough Oracle 8/8i performance!
- Optimize Web-centered enterprise applications
- Maximize OLTP and OLAP/DSS performance and scalability
- Tune UNIX, eliminate SQL bottlenecks, and master Oracle 8/8i's latest performance enhancements
Maximize performance: Tune Oracle8i and UNIX together!
Now, the #1 guide to Oracle tuning on UNIX platforms has been thoroughly updated for Oracle 8i! Oracle Senior Performance Engineer Ahmed Alomari covers every relevant optimization technique for every leading application and approach, including Web-centered development, OLTP, OLAP/DSS, and object-relational database systems.
Alomari covers the entire system lifecycle, showing how to achieve breakthrough performance by tuning both Oracle 8i and your underlying UNIX platform. Coverage includes:
- Choosing Oracle 8/8i and UNIX installation options that maximize performance
- Optimizing the UNIX kernel, memory, processors and I/O for your application
- Partitioning, star queries, and parallel DML
- Connection Manager, connection pooling, and multiple buffer pools
- Parallel query enhancements, I/O slaves, and multiple DBWR processes
- Oracle 8/8i optimizer and PRO*C enhancements
- Expert techniques for eliminating SQL bottlenecks
- State-of-the-art database performance benchmarking
- Specific solutions for Solaris, HP-UX, and Sequent
No matter how long you've been running Oracle and UNIX, you'll run them faster—and smarter—with Oracle8i & UNIX Performance Tuning!
Product Details
Would you like to update product info or give feedback on images?
|
More About the Author
Discover books, learn about writers, read author blogs, and more.
Customer Reviews
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
|
Most Helpful Customer Reviews
7 of 8 people found the following review helpful:
5.0 out of 5 stars
Great for Indepth Oracle tuning on UNIX,
By A Customer
This review is from: Oracle8i and Unix Performance Tuning (Paperback)
This is the only book that covers indepth tuning for Oracle databases in UNIX environments. The author cover tuning from a hardware, OS perspective as well as OLTP and DSS. This edition is better than the previous two. Topics convered include Volume Management, RAID, CPU, Memory for UNIX and all aspects of Oracle tuning. I recommend this book for experienced administrators (UNIX Admins and Oracle DBAs) because the author assumes good knowledge of Oracle architecture.
7 of 8 people found the following review helpful:
4.0 out of 5 stars
Good overview for Oracle on Unix,
By
This review is from: Oracle8i and Unix Performance Tuning (Paperback)
This book is an excellent overview of how the Oracle RDBMS runs on the various flavors of the Unix operating system. Knowledgeable Oracle DBA's will take away many performance tuning tips with a complete understanding of why, when, and how to implement. The first two chapters on The Unix Kernel and Paging/Swapping should be required reading for anyone administering Oracle on Unix.
7 of 8 people found the following review helpful:
4.0 out of 5 stars
An overall guide to tuning Oracle on UNIX,
By Phil Padgett (Houston, TX USA) - See all my reviews
This review is from: Oracle8i and Unix Performance Tuning (Paperback)
I thought this book covered the topic of performance tuning Oracle on UNIX thoroughly. It includes Oracle 7, 8 and 8.1 on Solaris, Sequent and HP. It includes an entire chapter on each of OLTP and DSS. It also has chapters on installation of the OS and Oracle. It didn't really add much to my knowledge of 7.3 but I picked up several good tidbits on 8i.
Share your thoughts with other customers: Create your own review
|
|
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
