Skip to main content
SpringerLink
Log in

Formal SQL Tuning for Oracle Databases

Practical Efficiency - Efficient Practice

  • Book
  • © 2016

Overview

Authors:
  1. Leonid Nossov

    1. ORACLE Deutschland B.V. & Co. KG , München, Germany

    View author publications

    You can also search for this author in PubMed   Google Scholar

  2. Hanno Ernst

    1. T-SYSTEMS INTERNATIONAL GMBH , Bamberg, Germany

    View author publications

    You can also search for this author in PubMed   Google Scholar

  3. Victor Chupis

    1. Vodafone GmbH , Düsseldorf, Germany

    View author publications

    You can also search for this author in PubMed   Google Scholar

  • A very simple but very useful method of SQL tuning is described
  • Analysis of bottlenecks
  • Numerous examples facilitate to get into the subject
  • Enables SQL tuning by removal of brakes in the execution plans

  • 6701 Accesses

This is a preview of subscription content, log in via an institution to check access.

Access this book

Log in via an institution
eBook USD 44.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 59.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book USD 59.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

Licence this eBook for your library

Institutional subscriptions

Table of contents (8 chapters)

  1. Front Matter

    Pages i-xvi
    Download chapter PDF

  2. Introduction

    • Leonid Nossov, Hanno Ernst, Victor Chupis
    Pages 1-3

  3. Some Thoughts on the Term “SQL Tuning”

    • Leonid Nossov, Hanno Ernst, Victor Chupis
    Pages 5-10

  4. Minimum Minimorum on the Subject of the “Execution Plan”

    • Leonid Nossov, Hanno Ernst, Victor Chupis
    Pages 11-23

  5. Approaches to Formal SQL Tuning

    • Leonid Nossov, Hanno Ernst, Victor Chupis
    Pages 25-29

  6. Bottlenecks in the Execution Plan

    • Leonid Nossov, Hanno Ernst, Victor Chupis
    Pages 31-71

  7. Procedure of Formal SQL Tuning

    • Leonid Nossov, Hanno Ernst, Victor Chupis
    Pages 73-78

  8. Practical Experience with Formal SQL Tuning

    • Leonid Nossov, Hanno Ernst, Victor Chupis
    Pages 79-92

  9. Closing Remarks

    • Leonid Nossov, Hanno Ernst, Victor Chupis
    Pages 93-95

  10. Back Matter

    Pages 97-109
    Download chapter PDF
Back to top

Keywords

About this book

The target of  SQL tuning is  the improvement of the existing execution plan.  The authors discuss the removal of brakes in the execution plan. Such "brakes" or bottlenecks can be recognized by a formal analysis of the execution plan. For this purpose no data model knowledge is needed. This is especially beneficial for database administrators because they are usually not or insufficiently  familiar with the data model. The book presents numerous practical examples with this method.

Authors and Affiliations

  • ORACLE Deutschland B.V. & Co. KG , München, Germany

    Leonid Nossov

  • T-SYSTEMS INTERNATIONAL GMBH , Bamberg, Germany

    Hanno Ernst

  • Vodafone GmbH , Düsseldorf, Germany

    Victor Chupis

About the authors

Leonid Nossov was born in Yakutsk, studied mathematics in USSR and has worked in Germany as an Oracle spezialist for several software companies. In the last few years he has been in Advanced Customer Support at Oracle Germany. His work mainly involves performance tuning and troubleshooting.
Hanno Ernst comes from Zschopau in the Erz Mountains. Since qualifying as an electronics technician in communications technology at German Telecom he has been in Bamberg at the German Telecom subsidiary T-Systems. His main task is database administration and he is particularly interested in error and performance analysis.
Victor Chupis was born in Odessa, USSR. He studied electronics and information technology in Moscow. Since 2001 he has been working for Vodafone Germany. His special fields are database design, operations and performance tuning.

Bibliographic Information

  • Book Title: Formal SQL Tuning for Oracle Databases

  • Book Subtitle: Practical Efficiency - Efficient Practice

  • Authors: Leonid Nossov, Hanno Ernst, Victor Chupis

  • DOI: https://doi.org/10.1007/978-3-662-50417-8

  • Publisher: Springer Berlin, Heidelberg

  • eBook Packages: Computer Science, Computer Science (R0)

  • Copyright Information: Springer-Verlag Berlin Heidelberg 2016

  • Hardcover ISBN: 978-3-662-50416-1Published: 26 September 2016

  • Softcover ISBN: 978-3-662-57056-2Published: 23 June 2018

  • eBook ISBN: 978-3-662-50417-8Published: 16 September 2016

  • Edition Number: 1

  • Number of Pages: XVI, 109

  • Number of Illustrations: 55 b/w illustrations, 13 illustrations in colour

  • Topics: Database Management, Management of Computing and Information Systems, Computer Appl. in Administrative Data Processing

Publish with us

Policies and ethics

Back to top

Search

Navigation