Oracle Performance Tuning 101
Published on 16. June 2001
Book
Paperback/Softback
436 pages
978-0-07-213145-1 (ISBN)
Description
Your Oracle career starts here! Ideal for those new to Oracle technology, this officially authorized guide teaches new DBAs the essentials of keeping an Oracle database running at top performance. You'll get coverage of application, instance, database, I/O, OS, and contention tuning.
More details
Series
Language
English
Place of publication
United States
Publishing group
McGraw-Hill Education - Europe
Target group
College/higher education
Product notice
Paperback (trade)
Unsewn / adhesive bound
Illustrations
1, black & white illustrations
Dimensions
Height: 232 mm
Width: 187 mm
Thickness: 34 mm
Weight
874 gr
ISBN-13
978-0-07-213145-1 (9780072131451)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Persons
Gaja Krishna Vaidyanatha is currently the Director of Storage Management Products at Quest Software, Inc., providing technical and strategic direction for the storage management product line. He has more than ten years of technical expertise, with over nine years of industry experience working with Oracle systems. Prior to joining Quest, Gaja worked as a Technical Manager at Andersen Consulting, where he specialized in Oracle Systems Performance Management and lead the Oracle Performance Management SWAT Team within the Technology Product Services Group. In a prior life, Gaja was also a Consultant and Instructor at Oracle Corporation specializing in the core technologies of Oracle. His key areas of interests include performance architectures, scalable storage solutions, highly available systems, and system performance management for data warehouses and transactional systems. He holds a Masters Degree in Computer Science from Bowling Green State University, Ohio. He has presented many papers at various regional, national and international Oracle conferences and is currently in the faculty of the IOUG-A Master Class University. He is also a contributor to the Oracle-L listserver and can be reached at gajav64yahoo.com.
Kirtikumar Deshpande (Kirti Deshpande) has been working in the Information Technology field for over 20 years, including more than seven years as an Oracle DBA. Although a Biomedical Engineer by profession, he has chosen Information Technology as his career. He currently works with Verizon Information Services as a Senior Oracle Database Administrator and is a frequent contributor on the Oracle-L and LazyDBA listservers. He can be reached at kirti_deshpande64hotmail.com.
John A. Kostelac, Jr. is an Oracle database administration consultant and operates an information technology consulting firm. He specializes in performance and recovery issues for Oracle databases. Additionally, he is experienced in every phase of modeling, design and implementation of Oracle databases for a variety of applications. John can be reached by e-mail at john@winningstaff.com
Kirtikumar Deshpande (Kirti Deshpande) has been working in the Information Technology field for over 20 years, including more than seven years as an Oracle DBA. Although a Biomedical Engineer by profession, he has chosen Information Technology as his career. He currently works with Verizon Information Services as a Senior Oracle Database Administrator and is a frequent contributor on the Oracle-L and LazyDBA listservers. He can be reached at kirti_deshpande64hotmail.com.
John A. Kostelac, Jr. is an Oracle database administration consultant and operates an information technology consulting firm. He specializes in performance and recovery issues for Oracle databases. Additionally, he is experienced in every phase of modeling, design and implementation of Oracle databases for a variety of applications. John can be reached by e-mail at john@winningstaff.com
Content
Part I: The Method. Chapter 1: Introduction to Oracle Peformance Management. Chapter 2: The Method Behind the Madness. Part II: Application Tuning. Chapter 3: Application Tuning: Issues that Concern a DBA. Chapter 4: Application Tuning: Tracking Down Bad SQL. Part III: Instance and Database Tuning. Chapter 5: Instance Tuning: The Shared Pool Area. Chapter 6: Instance Tuning: The Database Buffer Cache. Chapter 7: Instance Tuning: The Redo Log Buffer & Miscellaneous Tuning. Chapter 8: Database Tuning. Part IV: Specialized Tuning. Chapter 9: Parallel Query Tuning. Chapter 10: Contention Tuning. Part V: Environment Tuning. Chapter 11: I/O Tuning. Chapter 12: Operating System Tuning. Chapter 13: Wrapping It Up. Part VI: Appendixes: Appendix A: Glossary. Appendix B: More Tips & Resources. Appendix C: References.