Oracle SQL Tuning Pocket Reference

Author: Mark Gurry
Publisher: "O'Reilly Media, Inc."
ISBN: 0596552130
Category : Computers
Languages : en
Pages : 113

Book Description
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. Poorly tuned SQL statements are one of the leading causes of substandard database performance and poor response time. SQL statements that perform poorly result in frustration for users, and can even prevent a company from serving its customers in a timely manner. 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.

TOAD Pocket Reference for Oracle

Author: Jim McDaniel
Publisher: "O'Reilly Media, Inc."
ISBN: 9780596003371
Category : Computers
Languages : en
Pages : 130

Book Description
TOAD -- the Tool for Oracle Application Developers -- is an enormously popular interactive environment for Oracle development and administration. It allows developers to build, test, debug, and format their code via an easy-to-use graphical user interface, available in both freeware and commercial versions. TOAD makes developers far more productive; using TOAD, you'll find that program changes that once took hours can now be completed in minutes. In addition to its development features, TOAD also provides extensive facilities for Oracle database administration. Coauthored by the TOADman and TOAD team, and Patrick McGrath of Quest Software, Inc., this pocket reference is a helpful companion for Oracle developers and DBAs. It's packed with quick-reference material: TOAD feature and menu summaries, shortcut keys, suggested changes to TOAD defaults, productivity tips and tricks, and more. The book includes concise discussions of all the basic TOAD components: the SQL Editor, Procedure Editor, Text Editor, SQL Modeler, Schema Browser, and Debugger. It also provides helpful hints on using TOAD to perform database administration and SQL tuning. Whether you're a new or experienced TOAD user, you'll find this quick reference an indispensable companion to the product and its online help files. Book jacket.

Oracle SQL*Plus Pocket Reference

Author: Jonathan Gennick
Publisher: "O'Reilly Media, Inc."
ISBN: 0596008856
Category : Computers
Languages : en
Pages : 155

Book Description
SQL*Plus is an interactive query tool that's ubiquitous in the Oracle world. It's available at every Oracle site-from the largest data warehouse to the smallest single-user system-and it's a critical tool for virtually every Oracle user. The third edition of this popular pocket guide provides quick reference information on SQL*Plus syntax and format elements, including new Oracle Database 10g features. It concisely describes interacting with SQL*Plus, formatting both text and HTML reports with SQL*Plus, and tuning SQL queries using both optimizer hints and the plan table. This new edition covers browser-based iSQL*Plus, the ability to generate HTML, new commands and SET options, and much more. It also contains expanded information on the SQL statements most commonly issued from SQL*Plus (Select, Insert, Update, Delete, Merge, Commit, Rollback, Savepoint, Set Transaction) and adds coverage of new SQL features such as the Oracle Database 10g Select statement's Model clause, flashback queries, partition outer joins, and DBMS_XPLAN. Book jacket.

Oracle RMAN Pocket Reference

Author: Darl Kuhn
Publisher: "O'Reilly Media, Inc."
ISBN: 0596551991
Category : Computers
Languages : en
Pages : 121

Book Description
Oracle RMAN Pocket Reference is a handy guide for DBAs who intend to use Oracle Recovery Manager for database backup and recovery. Because Recovery Manager (RMAN) is a relatively new tool, many DBAs are just becoming familiar with it. They will welcome a timely book that explains clearly and concisely how to use RMAN for common backup and recovery tasks that are infrequent, yet extremely vital.The first portion of the book is primarily task-oriented. After a short section on RMAN architecture, the book shows (in checklist style) how to perform common backup and recovery tasks such as: Implementing a recovery catalog Creating and running RMAN scripts Configuring input/output channels Taking a full database backup Backing up tablespaces and datafiles Taking incremental backups Recovering lost datafiles The second portion of the book consists of a handy syntax reference to the many RMAN commands. Having a quick reference to RMAN commands is a great convenience to DBAs who otherwise, often under the pressure of a recovery situation, would have to wade through Oracle's online documentation.

Quick Start Guide to Oracle Query Tuning: Tips for Dbas and Developers

Author: Rich Niemiec
Publisher: McGraw-Hill
ISBN: 9781259587115
Category : Computers
Languages : en
Pages : 146

Book Description

SQL Tuning

Author: Dan Tow
Publisher: "O'Reilly Media, Inc."
ISBN: 059655236X
Category : Computers
Languages : en
Pages : 338

Book Description
A poorly performing database application not only costs users time, but also has an impact on other applications running on the same computer or the same network. SQL Tuning provides an essential next step for SQL developers and database administrators who want to extend their SQL tuning expertise and get the most from their database applications.There are two basic issues to focus on when tuning SQL: how to find and interpret the execution plan of an SQL statement and how to change SQL to get a specific alternate execution plan. SQL Tuning provides answers to these questions and addresses a third issue that's even more important: how to find the optimal execution plan for the query to use.Author Dan Tow outlines a timesaving method he's developed for finding the optimum execution plan--rapidly and systematically--regardless of the complexity of the SQL or the database platform being used. You'll learn how to understand and control SQL execution plans and how to diagram SQL queries to deduce the best execution plan for a query. Key chapters in the book include exercises to reinforce the concepts you've learned. SQL Tuning concludes by addressing special concerns and unique solutions to "unsolvable problems."Whether you are a programmer who develops SQL-based applications or a database administrator or other who troubleshoots poorly tuned applications, SQL Tuning will arm you with a reliable and deterministic method for tuning your SQL queries to gain optimal performance.

Oracle SQL*Loader

Author: Jonathan Gennick
Publisher: "O'Reilly Media, Inc."
ISBN: 1565929489
Category : Computers
Languages : en
Pages : 272

Book Description
A step-by-step guide of all the tasks that Oracle developers and DBAs need to perform with SQL*Loader. Readable and informative, this reference is a task-oriented learning tool for those already using this utility.

Oracle SQL Performance Tuning and Optimization

Author: Kevin Meade
Publisher: Createspace Independent Publishing Platform
ISBN: 9781501022692
Category : Database management
Languages : en
Pages : 0

Book Description
Written by a Senior Database Administrator who has worked with the Oracle RDBMS for thirty years, this is a book which teaches the skill of SQL Tuning for the Oracle Database. Not a list of one-off tricks or tips, nor a glossing over of topics; this book offers an in-depth process covering discovery, analysis, and problem resolution. Learn the science behind SQL Tuning. Learn and apply the FILTERED ROWS PERCENTAGE Cardinality based method of tuning Determine a query's Driving Table and Join Order Construct Query Diagrams, Data Models, and Join Trees Build and use Count / Filter / and Reconstruction Queries Identify Waste in a Query Execution Plan Zero in on Cardinality Divergence using Estimated vs. Actuals Use the ACCESS / FILTER / COVERAGE strategy to build indexes for Problem Queries Exploit THE 2% RULE in analyzing Access method and Join method Classify queries as Precision Style or Warehouse Style Understand Hash Join mechanics and make Hash Joins go faster Make HINTS work as Detection Tools rather than clubs Avoid early Database Design flaws Manage Statistics and deal with common Statistics problems (NDV, Uniform Distribution, Independence, Dynamic Sampling) (Staleness, Skew, Dependence, Defaulting, Out-Of-Bounds, Transiency, Bloat) Perfect your Question Based Analyis Technique and more Included are: a special chapter for EXADATA, a LAB which demonstrates the cardinality based process of SQL Tuning, and twenty three magical SQL scripts that make the process of SQL Tuning easy to do. Learn the skill of SQL Tuning as taught by an expert who does it for a living, and become the go-to specialist in your company. Chapter 1: DRIVING TABLE and JOIN ORDER Chapter 2: Ways to Use a Query Execution Plan Chapter 3: The Best Indexes for a Query Chapter 4: JOINS Chapter 5: HINTS Chapter 6: BASICS Chapter 7: ROW COUNTS and RUN TIMES Chapter 8: EXADATA LAB: Reverse Engineering the QEP Appendix: Know Your Scripts Scripts for analyzing queries and plans Scripts for examining an active database Scripts for looking at metadata showplan showplanshort showplanconstraints showplancountqueries showplandatamodel showplandrivingtable showplanfilterqueries showplanfrpspreadsheetcode showplanindexes showplannumrows showplanquerydiagram showplantables showplantablesunique loadplanfromcache loadplanfromhist showtopcpu showowner showindexes showconstraints showcolstats showhistograms showallscanrates showallworkareas It's all about the Cardinalities

SQL Performance Tuning

Author: Peter Gulutzan
Publisher: Addison-Wesley Professional
ISBN: 9780201791693
Category : Computers
Languages : en
Pages : 522

Book Description
A very practical guide to making databases run faster and better. A poorly performing database application can cost each user time, and have an impact on other applications running on the same computer or the same network. This book will help DBAUs and programmers improve the performance of their databases.

Oracle SQL*Plus

Author: Jonathan Gennick
Publisher: "O'Reilly Media, Inc."
ISBN: 0596004419
Category : Computers
Languages : en
Pages : 120

Book Description
SQLPlus is available at every Oracle site--from the largest data warehouse to the smallest single-user system--and it's a critical tool for virtually every Oracle user. Despite its wide use, few developers and DBAs know how powerful a tool SQLPlus can be. This pocket reference provides quick reference information that will help you use SQLPlus, Oracle's interactive query tool. It summarizes all of the SQLPlus syntax, including the syntax for the Oracle9i release. This book boils down the most vital information from Gennick's best-selling book, "Oracle SQL8Plus: The Definitive Guide", into an accessible summary and works as a vital companion to the larger book. It concisely describes interacting with SQLPlus, selecting data, formatting reports with SQLPlus, and tuning SQL queries. It also contains quick references to the SQL*Plus commands and format elements. The new 2nd edition of our Oracle SQLPlus Pocket Reference includes many new features for Oracle9i (e.g., COALESCE function, searched CASE expressions, new table join syntax, partition operations, MERGE statement, and syntax changes in existing SQLPlus statements such as ACCEPT, DESRIBE, HELP, and SET) It also adds sections on basic SQL (a much-requested feature): INSERT, DELETE, UPDATE, SELECT, and transaction management. The pocket reference size is especially appropriate for this particular subject, since Oracle SQL*Plus is used on every possible platform, it's particularly convenient to be able to carry a small book around from office computer to home computer to laptop.