This handbook provides database administrators with clear and concise processes with which to attack tuning problems using Oracle Wait Interface. A guide is provided to demonstrate the mechanics of the Wait Interface and how to use it not only to tune database performance at the database level but also to give the statistics needed to understand problems that lie outside of the database in the SAN or the network. Techniques that apply to tuning any Oracle database from version 7 through 9i and beyond are included.
Book Description
Frequently Bought Together
Editorial Reviews
About the Author
Stephen Andert is a database administrator for First Health Group Corporation. He has written articles on SQL*Loader tuning and has presented at local and international Oracle user group events. He is an Oracle8 and Oracle8i Oracle Certified Professional and is currently serves on the board of AZORA, the Arizona Oracle user group. He lives in Chandler, Arizona.
Product Details
Would you like to update product info or give feedback on images?
|
Customer Reviews
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
|
Most Helpful Customer Reviews
2 of 2 people found the following review helpful:
1.0 out of 5 stars
Oracle wait event interfaces,
By JK "JK" (Prague) - See all my reviews
Amazon Verified Purchase(What's this?)
This review is from: Oracle Wait Event Tuning: High Performance with Wait Event Interface Analysis (Oracle In-Focus series) (Paperback)
I have to say that i find all books (i bought 4 all about oracle performance) from rampant press under average from the quality point of view. You find lot of descriptions of oracle 10g features with few senteces about it. These information you can find easily in original oracle documentation or on the web and maybe in better quality. You will get some mistakes as extra bonus. If you really want get good knowledge about oracle wait events look on this book:
Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning link: http://www.amazon.com/Oracle-Wait-Interface-Performance-Diagnostics/dp/007222729X/ref=sr_1_1?ie=UTF8&s=books&qid=1260009825&sr=8-1
2 of 4 people found the following review helpful:
4.0 out of 5 stars
Good place to start . . . .,
By Eric L. Yen (Covia, CA USA) - See all my reviews
This review is from: Oracle Wait Event Tuning: High Performance with Wait Event Interface Analysis (Oracle In-Focus series) (Paperback)
The subject of Oracle Wait Tuning (OWT) is gaining popularity among more and more DBAs. This book takes the subject of OWT and presents it in a clear and easy manner. By removing the mystery and mystic and presenting the techniques you can learn without being buried in all the details. Note that this book does point you in the right direction when you need more detail. I suggest "Optimizing Oracle Performance" by Cary Millsap for deep detailed information. The Oracle Wait Interface book from Oracle Press is a good book right after this one.
5 of 9 people found the following review helpful:
5.0 out of 5 stars
Easy to read and great scripts!!!,
By Kevin (Tempe, AZ) - See all my reviews
This review is from: Oracle Wait Event Tuning: High Performance with Wait Event Interface Analysis (Oracle In-Focus series) (Paperback)
This is no boring white paper. It was an easy to read informative look at a new way of tuning. As an Oracle DBA II, I am by no means an Oracle expert, but this book allowed me to understand what tuning with the wait interface is all about. It gave me a comprehensive understanding of what the wait interface can display system wide. I was also very happy that there where "working scripts" that actually worked.!!!
I would recommend this book to anyone from a DBA I to a DBA III. It might not even hurt if a few sysadmins read it too... Did I mention I liked the scripts?
Share your thoughts with other customers: Create your own review
|
|
Inside This Book
(learn more)
First Sentence:
Tuning a database is an activity with the goal of making the database run better than it did before. Read the first page Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
trace data, load profile, response time component, buffer cache hit ratio, network tuning, soft parse, metalink note, wait interface, column event format, column sid format, control file parallel write, library cache pin, workload repository, rdbms ipc reply, buffer busy waits, rdbms ipc message, code depot, timed statistics, data dictionary objects, file sequential, cursor sharing, buffer hit ratio, file scattered, advisor tasks, trace file Key Phrases - Capitalized Phrases (CAPs): (learn more)
Oracle Wait Event Tuning, Trace Analyzer, Hotsos Profiler, Name Null, Automatic Workload Repository, Automatic Database Diagnostic Monitor, Tuning Advisor, Buffer Hit, Enterprise Manager, Tuning Disk, Anjo Kolk, Cary Millsap, Buffer Nowait, Access Advisor, Oracle Corporation, In-memory Sort, Parse Elapsed, Year Mo Day Hour, Latch Hit, Instance Efficiency Percentages, Library Hit, Active Session History Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Back Cover | Surprise Me!
Tuning a database is an activity with the goal of making the database run better than it did before. Read the first page Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
trace data, load profile, response time component, buffer cache hit ratio, network tuning, soft parse, metalink note, wait interface, column event format, column sid format, control file parallel write, library cache pin, workload repository, rdbms ipc reply, buffer busy waits, rdbms ipc message, code depot, timed statistics, data dictionary objects, file sequential, cursor sharing, buffer hit ratio, file scattered, advisor tasks, trace file Key Phrases - Capitalized Phrases (CAPs): (learn more)
Oracle Wait Event Tuning, Trace Analyzer, Hotsos Profiler, Name Null, Automatic Workload Repository, Automatic Database Diagnostic Monitor, Tuning Advisor, Buffer Hit, Enterprise Manager, Tuning Disk, Anjo Kolk, Cary Millsap, Buffer Nowait, Access Advisor, Oracle Corporation, In-memory Sort, Parse Elapsed, Year Mo Day Hour, Latch Hit, Instance Efficiency Percentages, Library Hit, Active Session History Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Back Cover | Surprise Me!
What Other Items Do Customers Buy After Viewing This Item?
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
Customer Discussions
|
This product's forum
Active discussions in related forums
Search Customer Discussions
|
Related forums
|
