Oracle SQL Tuning Pocket Reference




Publisher: O'Reilly Media, Inc.; 1st edition | 2001-11-15 | 90 Pages | ISBN: 0596002688 | PDF | 1.6 MB

One of the most important challenges faced by Oracle database administrators and Oracle developers is the need to tune SQL statements so that they execute efficiently. In this book, Mark Gurry shares his in-depth knowledge of Oracle's SQL statement optimizers. Mark's knowledge is the result of many hard-fought tuning battles during his many years of providing Oracle tuning services to clients. Mark provides insights into the workings of the rule-based optimizer that go well beyond what the rules tell you. Mark also provides solutions to many common problems that occur with both the rule-based and cost-based optimizers. In addition to the specific problem/solution scenarios for the optimizers, Mark provides a number of handy SQL tuning tips. He discusses the various optimizer hints, telling you when they can be used to good effect. Finally, Mark discusses the use of the DBMS_STATS package to manage database statistics, and the use of outlines to specify execution plans for SQL statements in third-party applications that you can't otherwise modify.

About the Author
As a database administrator on a financial IMS project about eight years ago, Mark Gurry was asked to investigate his company's database direction for the next five years. The number of users was up to 950, the cost of maintaining the mainframes was huge, and he'd heard about relational databases and downsizing. After much investigation, he chose Oracle, and has stuck with the system ever since. He has worked as Manager of Computing and Network Services, senior database administrator, senior Oracle technical support, and other jobs. He now has a small consulting company called New Age Consultants. Mark has worked for many large organizations and is currently working for Telecom Australia, the largest computer site in Australia and one of the largest in the world. He has also spoken on tuning at Oracle user group meetings and has given internal tuning courses at several of his larger client sites. He has been a senior team member on award-winning systems that have been developed using Oracle.

Download:

http://uploading.com/files/6f1ddc48/Oracle%252BSQL%252BTuning%252BPocket%252BReference-0596002688.zip/

[Fast Download] Oracle SQL Tuning Pocket Reference


Related eBooks:
Hands-On Deep Learning for Images with TensorFlow
Power BI Data Analysis and Visualization
Effective SQL: 61 Specific Ways to Write Better SQL
Agile Query-Driven Data Modeling for NoSQL
Databases: Executive Briefing
The Node.js Handbook
SQL Practical Guide for Developers
Computational Intelligence Applications in Business Intelligence and Big Data Analytics
Oracle CRM On Demand Deployment Guide (Osborne ORACLE Press Series)
Information Storage and Management: Storing, Managing, and Protecting Digital Information
Knowledge Discovery in Inductive Databases
Learning Social Media Analytics
Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.