null
Loading…
Skip to main content Skip to buy box

Holiday gifts by Fri, Dec 18? Order by Thu, Dec 3. Plan gifts Gifts by Dec 18? Order by Dec 3. Plan

Free shipping on most orders over $95 in the contiguous US

Specialists Mon–Fri, 8:30 am–5 pm PTSpecialists Mon–Fri, 8:30–5 PT866-522-6657

Printed to order
Oracle SQL Tuning with Oracle SQLTXPLAIN: Oracle Database 12c Edition book cover by Stelios Charalambides
Paperback

Oracle SQL Tuning with Oracle SQLTXPLAIN: Oracle Database 12c Edition

by Stelios Charalambides

From $70.39 / copy at 25+ copies; lower per-copy prices at higher quantities (see Volume pricing) As low as $68.79 at 100+

Total $1,759.75

Paperback · 408 pages Apress · 2017

Format

Paperback
Volume pricing

The more copies, the less each one costs

Applied automatically in your cart. No code needed.

More than a box of books

Turn this order into a program

Groups that order together often pair the copies with something more. We handle the extras so you don't have to.

About the book

Oracle SQL Tuning with Oracle SQLTXPLAIN

Learn through this practical guide to SQL tuning how Oracle's own experts do it, using a freely downloadable tool called SQLTXPLAIN. This new edition has been expanded to include AWR, Oracle 12c Statistics, interpretation of SQL Monitor reports, Parallel execution, and Exadata-related features. Reading this book and using SQL helps you learn to tune even the most complex SQL, and you'll learn to do it quickly, without the huge learning curve usually associated with tuning as a whole.

Firmly based in real-world problems, this book helps you reclaim system resources and avoid the most common bottleneck in overall performance, badly tuned SQL. You'll learn how the optimizer works, how to take advantage of its latest features, and when it's better to turn them off. Best of all, the book is updated to cover the very latest feature set in Oracle Database 12c.

  • Covers AWR report integration
  • Helps with SQL Monitor Report Interpretation
  • Provides a reliablemethod that is repeatable
  • Shows the very latest tuning features in Oracle Database 12c
  • Enables the building of test cases without affecting production

  • What You'll Learn
    • Identify how and why complex SQL has gone wrong
    • Correctly interpret AWR reports generated via SQLTXPLAIN
    • Collect the best statistics for your environment
    • Know when to invoke built-in tuning facilities
    • Recognize when tuning is not the solution
    • Spot the steps in a SQL statement's execution plan that are critical to performance of that statement
    • Modify your SQL to solve performance problems and increase the speed and throughput of production database systems
    Who This Book Is For

    Anyone who deals with SQL and SQL tuning. Both developers and DBAs will benefit from learning how to use the SQLTXPLAIN tool, and from the problem solving methodology in this book.


    Details

    Publisher
    Apress
    Author
    Stelios Charalambides
    Format
    Paperback
    Published
    Apr 6, 2017
    ISBN-13
    9781484224359
    Pages
    408
    Printing
    Printed on demand
    Buying for a group

    Oracle SQL Tuning with Oracle SQLTXPLAIN for groups: pricing

    Volume pricing applies automatically in your cart. No codes, no account needed.

    CopiesPrice per copyYou save
    25 – 49 $70.39 12% off list
    50 – 99 $69.59 13% off list
    100+ $68.79 14% off list
    Ways groups use it

    Popular for

    1
    Book clubs

    A copy for every member, on one order.

    2
    Events and conferences

    A book for every attendee, delivered to your venue.

    3
    Gifts

    For clients, staff, members or volunteers.

    Where can I buy 100 copies of Oracle SQL Tuning with Oracle SQLTXPLAIN?

    BookPal sells Oracle SQL Tuning with Oracle SQLTXPLAIN in quantity. At 100 copies the price is $68.79 a copy, against a list price of $79.99, and the cart applies the volume tier automatically. Free shipping on most orders over $95 in the contiguous US. A specialist can quote a larger or mixed order.

    • New books only, straight from the publisher
    • Volume prices apply automatically in the cart, with no code needed
    • Order at least 10 business days before you need the books (11 from mid-November through December)

    Ask a specialist about a larger or mixed order

    What does Oracle SQL Tuning with Oracle SQLTXPLAIN cost when I buy for a group?

    Volume pricing applies automatically in your cart, with no code needed. Price per copy: 25 to 49 copies, $70.39 (12% off list); 50 to 99 copies, $69.59 (13% off list); 100+ copies, $68.79 (14% off list). Need a different quantity, or a quote to forward for approval? Ask a specialist and we will confirm pricing before you pay.

    How fast can I get copies of Oracle SQL Tuning with Oracle SQLTXPLAIN?

    This title is printed on demand, so it needs production time before it ships. Need them by a specific date? Request a quote and we'll confirm timing before you pay.

    Can you ship to several locations or people's homes?

    Yes. We ship group orders to one address, to multiple sites, or to individual recipients, in the US and internationally. See fulfillment options.

    Can I get a formal quote for approval before ordering?

    Yes. Request a quote and we'll send a PDF you can forward for approval.

    Do you accept purchase orders and tax-exempt orders?

    Yes. We accept purchase orders upon approval, as well as cards, PayPal, ACH, wire transfers and checks. BookPal is a tax-exempt supplier in all 50 states. See purchase orders and sales tax exemption.

    What if I find a lower price?

    Send us the link. We match prices from other booksellers and distributors on a new copy in the same edition, available to ship in the quantity you need. Clearance sales and pricing errors are the exception, and we'll tell you quickly if that's the case. Start a price match.

    Send for approval

    Get a yes from your approver

    Oracle SQL Tuning with Oracle SQLTXPLAIN: Oracle Database 12c Edition
    Email it to my approver

    Your approver gets a link to this page with the quantity set and an "Approve and order" button. Nothing is sent until you press send in your email app.

    Log In
    Review Your Cart
    Your cart is empty Your cart is empty Your cart is empty

    Menu

    Recently Viewed Recently Viewed
    Back to top Back to top