Oracle SQL Tuning & CBO Internals (Oracle In-Focus) - Softcover

Floss, Kimberly

Softcover

ISBN 10: 0974599336 ISBN 13: 9780974599335

Publisher: Rampant Techpress, 2004

Synopsis

As Oracle professionals are challenged to create SQL statements that will support thousands of concurrent executions with sub-second response time, this book’s timing is critical as tuning Oracle SQL has become the single most important skill of the Oracle professional. While not appropriate for the beginner, this book allows senior Oracle professionals to explore important internal mechanisms within Oracle and the powerful and complex internals of Oracle SQL execution. Topics include the internals of Oracle cost-based SQL optimizer, SQL execution internals within the library cache, Oracle SQL coding and optimization techniques, and Oracle index internals. Also included is a ready-to-use code depot full of working SQL tuning scripts, which allow for quick optimization of the SQL and indexes inside the Oracle database.

About this title

About the Author:

Kimberly Floss is the president of the International Oracle Users Group (IOUG) , specializing in Oracle performance tuning and SQL tuning techniques. She has over 15 years of experience in information technology, with specific focus on relational database technology including Oracle, DB2, Microsoft SQL Server, and Sybase. She lives in Chicago.

About this edition

• Publisher: Rampant Techpress
• Publication date: 2004
• ISBN 10: 0974599336
• ISBN 13: 9780974599335
• Binding: Paperback
• Number of pages: 340