Author:Cary Millsap URL:http://www.amazon.com/exec/obidos/tg/detail/-/059600527X Product Details pages: 388 pages Publisher:O'Reilly ISBN:059600527X Format:CHM
Summary
Oracle DBAs and developers are all too familiar with the outlay of time and
resources, blown budgets, missed deadlines, and marginally effective performance
fiddling that is commonplace with traditional methods of Oracle performance
tuning. In Optimizing Oracle Performance, Cary Millsap, former VP of Oracle's System Performance Group, clearly and concisely explains how to use Oracle's response time statistics to diagnose and repair performance problems. Cary also shows how "queueing theory" can be applied to response time statistics to predict the impact of upgrades and other system changes. The price of this essential book will be paid back in hours saved the first time its methods are used.
Author:Gaja Krishna Vaidyanatha / Kirtikumar Deshpande / John A. Kostelac
URL: http://www.amazon.com/exec/obidos/tg/detail/-/0072131454
Product Details
pages: 404 pages Publisher: McGraw-Hill Osborne Media
ISBN: 0072131454 Format:
Learn to optimize and fine-tune your Oracle system's overall performance Implement tuning solutions using the proven methodology found inside Oracle Performance Tuning 101 gives you step-by-step practical advice for removing bottlenecks, minimizing downtime, and increasing overall system performance. You'll also get tips for identifying Oracle's current bottlenecks, prioritizing and performing tuning operations, writing optimal SQL, interpreting statistics, and much more. Written in a clear and engaging style, this book explains how to manage the tuning efforts of various components of your entire system in a methodical fashion, eliminating all guesswork.
Every chapter includes one or more myths and folklores about the topic, examples, and an "In a Nutshell" section--all geared to reinforce the knowledge you've acquired.
Author: Sanjay Mishra / Alan Beaulieu URL: http://www.amazon.com/exec/obidos/tg/detail/-/0596001290 Product Details pages: 321 pages Publisher: O'Reilly ISBN: 0596001290 Format: CHM
Summary
If you write programs to run against an Oracle database, you spend a lot of time and mental energy writing queries to return the data your programs need. Knowledge of SQL, and particularly of Oracle's implementation of SQL, is the key to writing good queries in a timely manner. In this book, the authors share their knowledge of Oracle SQL, and show you many creative techniques that you can use to advantage in your own applications. This book shows you how to: leverage Oracle's vast library of built-in SQL functions; query time-based data, and write joins involving date and time ranges; use Oracle SQL's hierarchical query features to deal with data best represented in a tree format; use DECODE and CASE to implement conditional logic in your queries; use Oracle's new, analytic SQL features to write ranking queries, lag and lead queries, and windowing queries; and join data from two or more tables using the newly supported SQL92 join syntax. In addition, you'll see how SQL can best be integrated with PL/SQL. You'll also learn various best practices to help you write SQL queries that perform efficiently.
Author: Rick Greenwald / Robert Stackowiak / Jonathan Stern URL: http://www.amazon.com/exec/obidos/tg/detail/-/0596005857 Product Details pages: 400 pages Publisher: O'Reilly ISBN: 0596005857 Format: CHM
Summary
Written for database administrators, developers, and managers, this guide introduces the full range of Oracle features and technologies. It provides an overview of Oracle Database 10g and its underlying features, concepts, and technology, and also covers Oracle's architecture, data structures, networking, and concurrency. The authors are IT professionals affiliated with the Oracle corporation.