Skip to content

Booksellers & Trade Customers: Sign up for online bulk buying at trade.atlanticbooks.com for wholesale discounts

Booksellers: Create Account on our B2B Portal for wholesale discounts

Oracle SQL Tuning with Oracle SQLTXPLAIN: Oracle Database 12c Edition by Stelios Charalambides

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

by Stelios Charalambides
Save 35% Save 35%
₹5,509.00
₹8,474.00
₹8,474.00
₹8,474.00
(-35%)
₹5,509.00
₹5,509.00

Imported Edition - Ships in 12-14 Days

Free Shipping in India on orders above Rs. 500

Request Bulk Quantity Quote
+91
Book cover type: Paperback
  • ISBN13: 9781484224359
  • Binding: Paperback
  • Subject: N/A
  • Publisher: Springer
  • Publisher Imprint: Apress
  • Publication Date:
  • Pages: 408
  • Original Price: EUR 74.99
  • Language: English
  • Edition: N/A
  • Item Weight: 813 grams
  • BISAC Subject(s): Database Administration & Management, System Administration / Storage & Retrieval, and Languages / SQL

From the Back Cover

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 reliable method that is repeatable
  • Shows the very latest tuning features in Oracle Database 12c
  • Enables the building of test cases without affecting production
    • What You Will 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

    Stelios Charalambides has more than 20 years experience working with Oracle databases. He is OCP certified and has worked as a senior Consultant and database administrator (DBA) on both sides of the Atlantic. His experience includes dealing with all aspects of system design, implementation and post production support, solving practical problems in a wide variety of environments. He works as an Exadata Oracle Support Engineer developing time-critical solutions for tier-one customers with high profile performance problems.

    Trusted for over 49 years

    Family Owned Company

    Secure Payment

    All Major Credit Cards/Debit Cards/UPI & More Accepted

    New & Authentic Products

    India's Largest Distributor

    Need Support?

    Whatsapp Us

    Related Category

    computers > database administration & management

    computers > system administration / storage & retrieval

    computers > languages / sql

    Bestselling

    View All
    Atomic Habits (Lead Title) by Clear, James

    Atomic Habits (Lead Title)

    Clear, James

    ₹585
    ₹899
    ₹899
    ₹899
    (-35%)
    ₹585
    ₹585

    • Author(s): Clear | James • Publisher: Penguin • Publisher Imprint: Penguin Random House • Subject: General Books

    Diary of a Wimpy Kid: Partypooper (Book 20) by Jeff Kinney

    Diary of a Wimpy Kid: Partypooper (Book 20)

    Jeff Kinney

    ₹455
    ₹699
    ₹699
    ₹699
    (-35%)
    ₹455
    ₹455

    • Author(s): Jeff Kinney • Publisher: Penguin Random House Children's UK • Publisher Imprint: Penguin Random House Children's UK • BISAC: Comics & Graphic Novels - Humorous

    Ikigai by Hector Garcia

    Ikigai

    Hector Garcia

    ₹390
    ₹599
    ₹599
    ₹599
    (-35%)
    ₹390
    ₹390

    • Author(s): Hector Garcia • Publisher: Penguin • Publisher Imprint: Penguin Random House • Subject: General Books

    The Courage To Be Disliked How To Free Yourself Change Your Life And Achieve Real Happiness Courage To Series by Ichiro Kishimi

    The Courage To Be Disliked How To Free Yourself Change Your Life And Achieve Real Happiness Courage To Series

    Ichiro Kishimi

    ₹358
    ₹550
    ₹550
    ₹550
    (-35%)
    ₹358
    ₹358

    • Author(s): Ichiro Kishimi • Publisher: GROVE ATLANTIC • Publisher Imprint: Allen & Unwin • BISAC: Personal Growth - SuccessIchiro Kishimi lives in Kyoto. He writes, lectures and teaches in psychiatric clinics as a certified counsellor and c...

    View full details
    12 Years: My Messed-up Love Story by Chetan Bhagat

    12 Years: My Messed-up Love Story

    Chetan Bhagat

    ₹260
    ₹399
    ₹399
    ₹399
    (-35%)
    ₹260
    ₹260

    • Author(s): Chetan Bhagat • Publisher: HarperCollins Publishers India • Publisher Imprint: HarperCollins Publishers India • BISAC: GeneralFrom India's top-selling writer Chetan Bhagat comes a powerful new love story that will make you laugh, cry...

    View full details
    The Mountain Is You: Transforming Self-Sabotage Into Self-Mastery

    The Mountain Is You: Transforming Self-Sabotage Into Self-Mastery

    Brianna Wiest

    ₹260
    ₹399
    ₹399
    ₹399
    (-35%)
    ₹260
    ₹260

    • Author(s): Brianna Wiest • Publisher: Manjul Publishing • Publisher Imprint: Amaryllis • BISAC: Body Mind And SpiritThis is a book about self-sabotage. Why we do it, when we do it, and how to stop doing it—for good. Coexisting but conflicting n...

    View full details
    The Art of Spending Money: Simple Choices for a Richer Life by Morgan Housel

    The Art of Spending Money: Simple Choices for a Richer Life

    Morgan Housel

    ₹290
    ₹499
    ₹499
    ₹499
    (-42%)
    ₹290
    ₹290

    • Author(s): Morgan Housel • Publisher: Pan Macmillan • Publisher Imprint: Pan Macmillan • BISAC: Finance - Wealth ManagementA third book from the International bestselling author of The Psychology of Money and Same as Ever, lessons on harnessing...

    View full details
    Mother Mary Comes To Me by Arundhati Roy

    Mother Mary Comes To Me

    Arundhati Roy

    ₹585
    ₹899
    ₹899
    ₹899
    (-35%)
    ₹585
    ₹585

    • Author(s): Arundhati Roy• Publisher: PRH INDIA LOCAL PRINT• Publisher Imprint: Penguin Hamish Hamilton• BISAC: Literary FiguresArundhati Roy’s first work of memoir, this is a soaring account, both intimate and inspiring, of how the author became...

    View full details
    Truth without Apology: A Guide for Those Who Can Stand It by Acharya Prashant

    Truth without Apology: A Guide for Those Who Can Stand It

    Acharya Prashant

    ₹260
    ₹399
    ₹399
    ₹399
    (-35%)
    ₹260
    ₹260

    • Author(s): Acharya Prashant • Publisher: HarperCollins Publishers India • Publisher Imprint: HarperCollins Publishers India • BISAC: GeneralIn a world where vagueness is mistaken for depth and obscurity passes for wisdom, Truth without Apology ...

    View full details
    Grandma's Bag of Stories by Sudha Murthy

    Grandma's Bag of Stories

    Sudha Murthy

    ₹179
    ₹275
    ₹275
    ₹275
    (-35%)
    ₹179
    ₹179

    • Author(s): Sudha Murthy • Publisher: India Puffin • Publisher Imprint: India Puffin • BISAC: Short StoriesWho can resist a good story, especially when it's being told by Grandma? From her bag emerges tales of kings and cheats, monkeys and mic...

    View full details
    Days at the Morisaki Bookshop by Satoshi Yagisawa

    Days at the Morisaki Bookshop

    Satoshi Yagisawa

    ₹260
    ₹399
    ₹399
    ₹399
    (-35%)
    ₹260
    ₹260

    • Author(s): Satoshi Yagisawa • Publisher: Bonnier Books Ltd • Publisher Imprint: Bonnier Books Ltd

    Deep Work: Rules For Focused Success In A Distracted World by Newport, Cal

    Deep Work: Rules For Focused Success In A Distracted World

    Newport, Cal

    ₹260
    ₹399
    ₹399
    ₹399
    (-35%)
    ₹260
    ₹260

    • Author(s): Newport, Cal • Publisher: Little, Brown Book Group • Publisher Imprint: Piatkus

    Can We Be Strangers Again?: A National Bestseller by Shrijeet Shandilya

    Can We Be Strangers Again?: A National Bestseller

    Shrijeet Shandilya

    ₹195
    ₹299
    ₹299
    ₹299
    (-35%)
    ₹195
    ₹195

    • Author(s): Shrijeet Shandilya • Publisher: Ebury Press • Publisher Imprint: Ebury Press • BISAC: Romance - GeneralIn the electric haze of college life, three friends are bound by laughter, late-night talks and unspoken promises. But when two of...

    View full details
    The Secret of Secrets: (Robert Langdon Book 6) by Dan Brown

    The Secret of Secrets: (Robert Langdon Book 6)

    Dan Brown

    ₹975
    ₹1,499
    ₹1,499
    ₹1,499
    (-35%)
    ₹975
    ₹975

    • Author(s): Dan Brown • Publisher: Transworld Publishers Ltd • Publisher Imprint: Transworld Publishers Ltd • BISAC: Thrillers - EspionageDan Brown is the bestselling author of Digital Fortress, Deception Point, Angels and Demons, The Da Vinci C...

    View full details
    Magic of the Lost Temple by Sudha Murty

    Magic of the Lost Temple

    Sudha Murty

    ₹179
    ₹275
    ₹275
    ₹275
    (-35%)
    ₹179
    ₹179

    • Author(s): Sudha Murty • Publisher: India Puffin • Publisher Imprint: India Puffin • BISAC: Action & Adventure - General

    Rich Dad Poor Dad: What the Rich Teach Their Kids about Money That the Poor and Middle Class Do Not!

    Rich Dad Poor Dad: What the Rich Teach Their Kids about Money That the Poor and Middle Class Do Not!

    ₹390
    ₹599
    ₹599
    ₹599
    (-35%)
    ₹390
    ₹390

    • Publisher: Penguin • Publisher Imprint: Penguin Random House • Subject: General Books • BISAC: Personal Finance - GeneralApril of 2022 marks a 25-year milestone for the personal finance classic Rich Dad Poor Dad that still ranks as the #1 Pers...

    View full details
    World’S Greatest Books For Personal Growth & Wealth (Set Of 4 Books) : Perfect Motivational by Dale Carnegie, Napoleon Hill

    World’S Greatest Books For Personal Growth & Wealth (Set Of 4 Books) : Perfect Motivational

    Dale Carnegie, Napoleon Hill

    ₹390
    ₹599
    ₹599
    ₹599
    (-35%)
    ₹390
    ₹390

    • Author(s): Dale Carnegie | Napoleon Hill • Publisher: Fingerprint • Publisher Imprint: Fingerprint • Subject: General Books

    The Housemaid: An Addictive Psychological Thriller With Mind-Bending Twists by Freida Mcfadden

    The Housemaid: An Addictive Psychological Thriller With Mind-Bending Twists

    Freida Mcfadden

    ₹358
    ₹550
    ₹550
    ₹550
    (-35%)
    ₹358
    ₹358

    • Author(s): Freida Mcfadden • Publisher: Penguin Select Print • Publisher Imprint: Penguin Select Publishing"Multi-Million Copy Bestselling Series •Now Being Made Into a Major Motion Picture Starring Sydney Sweeney and Amanda Seyfried #1 New Yor...

    View full details
    101 Tales: The Great Panchatantra Collection by Wonder House Books

    101 Tales: The Great Panchatantra Collection

    Wonder House Books

    ₹390
    ₹599
    ₹599
    ₹599
    (-35%)
    ₹390
    ₹390

    • Author(s): Wonder House Books • Publisher: Wonder House Books • Publisher Imprint: Wonder House Books • BISAC: Comics & Graphic Novels - Fairy Tales, Folklore, Legends & MTimeless Wisdom, Talking Animals & Life Lessons for Young Min...

    View full details
    Man's Search For Meaning by Viktor E. Frankl

    Man's Search For Meaning

    Viktor E. Frankl

    ₹260
    ₹399
    ₹399
    ₹399
    (-35%)
    ₹260
    ₹260

    • Author(s): Viktor E. Frankl • Publisher: Random House • Publisher Imprint: Random Hou • Subject: Medical, Nursing and Health Sciences

    Bacchon KI Doctor's Desi Parenting Book: A Doctor-Mom's Guide to Milk, Myths, Motherhood and More by Madhavi Bharadwaj

    Bacchon KI Doctor's Desi Parenting Book: A Doctor-Mom's Guide to Milk, Myths, Motherhood and More

    Madhavi Bharadwaj

    ₹260
    ₹399
    ₹399
    ₹399
    (-35%)
    ₹260
    ₹260

    • Author(s): Madhavi Bharadwaj • Publisher: PRH India • Publisher Imprint: Penguin Ebury Press • BISAC: Parenting - MotherhoodWelcome to the wild, messy, wonderful world of parenting--where the nights are long, the diapers are explosive, and unso...

    View full details
    The Outsider by Vir Das

    The Outsider

    Vir Das

    ₹455
    ₹699
    ₹699
    ₹699
    (-35%)
    ₹455
    ₹455

    • Author(s): Vir Das • Publisher: HarperCollins Publishers India • Publisher Imprint: HarperCollins Publishers India • BISAC: Entertainment & Performing ArtsComedian and actor Vir Das is beloved (by some, tolerated by others, blocked by a few...

    View full details
    The Very Hungry Caterpillar by Eric Carle

    The Very Hungry Caterpillar

    Eric Carle

    ₹293
    ₹450
    ₹450
    ₹450
    (-35%)
    ₹293
    ₹293

    • Author(s): Eric Carle • Publisher: Penguin Books, Limited (UK) • Publisher Imprint: Penguin Books, Limited (UK) • BISAC: Animals - Butterflies, Moths & CaterpillarsEric Carle's The Very Hungry Caterpillar is a perennial favourite with child...

    View full details
    Too Good to Be True : A smart, funny will-they-won’t-they romance by mostlysane by Prajakta Koli

    Too Good to Be True : A smart, funny will-they-won’t-they romance by mostlysane

    Prajakta Koli

    ₹260
    ₹399
    ₹399
    ₹399
    (-35%)
    ₹260
    ₹260

    • Author(s): Prajakta Koli • Publisher: Harper Fiction India • Publisher Imprint: Harper Fiction India • BISAC: Romance - ContemporaryWinner of the Amazon India Popular Choice Debut Book 2025 Award. From one of India's most-loved creators comes s...

    View full details
    Home
    Genres
    Account
    Chat