Goodreads helps you keep track of books you want to read.

Start by marking “Oracle Database 11g R2: SQL Tuning” as Want to Read:

Other editions

Enlarge cover

Rate this book

Clear rating

1 of 5 stars 2 of 5 stars 3 of 5 stars 4 of 5 stars 5 of 5 stars

Open Preview

Oracle Database 11g R2: SQL Tuning

by Sideris Courseware Corp

0.0 · Rating Details · 0 Ratings · 0 Reviews

This Oracle 11g learning guide will equip database administrators and application developers to build efficient SQL statements and to tune database applications. When this effort is complemented by database server and PL/SQL application tuning, then a highly efficient application execution environment is created. One will learn about the internals of SQL statement executio This Oracle 11g learning guide will equip database administrators and application developers to build efficient SQL statements and to tune database applications. When this effort is complemented by database server and PL/SQL application tuning, then a highly efficient application execution environment is created. One will learn about the internals of SQL statement execution, how to monitor the performance of such execution, and how one can influence the behavior of the database to achieve performance gains. This textbook is a mandatory reference for any database administrator or SQL database application developer. The following specific topics are among those considered: - Consider the unique and differing tuning issues found in online database applications, enterprise resource and data warehouse environments and the important metrics of SQL statement performance; - Learn about the internal mechanisms use for SQL statement execution within a database instance and how these can affect performance for good or bad, including the Optimizer facilities known as the Transformation Engine, Estimator and Plan Generator; - Use a variety of techniques to examine the details of SQL statement execution, spotting trouble areas and bottlenecks which require tuning; - Learn about the Auto-Task framework and how to manage the automatic collection of Optimizer statistics and automatic SQL tuning using both the programmatic and Enterprise Manager interfaces; - Learn how statistic deficiencies can dramatically degrade performance, and how these problems are resolved through customized Optimizer statistics collection procedures using the DBMS_STATS() package, system statistics, histograms, expression statistics and MultiColumn statistics; - Influence the behavior of the Optimizer by setting database parameters and other SQL tuning techniques; - Utilize the database advisory framework and the SQL Tuning and SQL Access advisors;- Use plan management to achieve plan stability which is adaptive and even dynamic; - Understand the self-tuning infrastructure and the automatic SQL tuning capabilities found within the database; - Employ SQL hints embedded into the statement text to resolve unique tuning challenges; - Learn to identify poorly performing SQL statements using real-time SQL monitoring and application tracing techniques such as DBMS_MONITOR(), trcsess and tkprof. ...more

Paperback, 566 pages

Published April 1st 2011 by Sideris Courseware Corp.

More Details... edit details

Get a copy:

Or buy for

Friend Reviews

To see what your friends thought of this book, please sign up.

Reader Q&A

To ask other readers questions about Oracle Database 11g R2, please sign up.

Be the first to ask a question about Oracle Database 11g R2

Lists with This Book

This book is not yet featured on Listopia. Add this book to your favorite list »

Community Reviews

(showing 1-4 of 4)

filter | sort: default (?) | Rating Details

Swati marked it as to-read
Feb 03, 2015

Vijay Pandey marked it as to-read
Feb 01, 2014

Akhtar Gul marked it as to-read
Dec 12, 2013

Valeriy marked it as to-read
Oct 30, 2013

new topic
Discuss This Book

There are no discussion topics on this book yet. Be the first to start one »

Recommend It | Stats | Recent Status Updates

Books by Sideris Courseware Corp

Oracle Database 11g R2: Architecture & Internals

Oracle Database 11g R2: SQL Fundamentals I

Oracle Database 11g RMAN Backup & Recovery

Oracle Bi 11g: Create Analyses & Dashboards

More…

Share This Book

+ Share on your website

Trivia About Oracle Database 1...

No trivia or quizzes yet. Add some now »

title link	preview: Oracle Database 11g R2: SQL Tuning
avg rating	preview: Oracle Database 11g R2: SQL Tuning Goodreads rating: 0.0 (0 ratings)
small image	preview: click here [close]
med image	preview: click here [close]
BBCode	[url=https://www.goodreads.com/book/show/14653925-oracle-database-11g-r2?utm_medium=api&utm_source=blog_book][img]https://d.gr-assets.com/books/1347225690l/14653925.jpg[/img][/url] [url=https://www.goodreads.com/book/show/14653925-oracle-database-11g-r2?utm_medium=api&utm_source=blog_book]Oracle Database 11g R2: SQL Tuning by Sideris Courseware Corp[/url]

See a Problem?

Preview — Oracle Database 11g R2 by Sideris Courseware Corp

Oracle Database 11g R2: SQL Tuning

Friend Reviews

Reader Q&A

Lists with This Book

Community Reviews

new topic
Discuss This Book

Books by Sideris Courseware Corp

Share This Book

Share on your website

Trivia About Oracle Database 1...

See a Problem?

Preview — Oracle Database 11g R2 by Sideris Courseware Corp

Oracle Database 11g R2: SQL Tuning

Friend Reviews

Reader Q&A

Lists with This Book

Community Reviews

new topicDiscuss This Book

Books by Sideris Courseware Corp

Share This Book

Share on your website

Trivia About Oracle Database 1...

new topic
Discuss This Book