{"product_id":"9798868832246","title":"Troubleshooting Oracle Performance Systematically Identify and Resolve Oracle Database Performance Problems","description":"\u003ch1\u003eTroubleshooting Oracle Performance\u003c\/h1\u003e\u003ch2\u003eSystematically Identify and Resolve Oracle Database Performance Problems\u003c\/h2\u003e\u003ch3\u003eChristian Antognini\u003c\/h3\u003e\u003cdiv\u003e\u003cb\u003eComputers \/ Database Administration \u0026amp; Management\u003c\/b\u003e\u003c\/div\u003e\u003cbr\u003e\u003cdiv\u003e\n\u003cp\u003eThis book is a systematic guide to diagnosing and resolving performance problems in enterprise applications that use Oracle Database. Written by performance engineer Christian Antognini for database administrators and application developers, it presents his proven approach to solving database application performance problems and shows how to plan for performance as you would for any other application requirement. You will see how SQL is parsed and executed, how to obtain and interpret execution plans, and how to move efficiently from symptoms to root causes across reproducible issues (SQL trace, PL\/SQL profilers), live incidents (dynamic performance views), and post-mortem analysis (AWR and Statspack). Coverage spans modern releases from Oracle Database 12g through Oracle AI Database 26ai.\u003c\/p\u003e\n\u003cp\u003eThis edition builds on previous bestselling editions with a deeper focus on the query optimizer and plan stability. You will learn how to configure the optimizer for each workload, evaluate execution plan efficiency, and apply execution plan management techniques including hints, SQL plan baselines, SQL profiles, and SQL patches. The restructured core adds focused chapters on parallel execution, precomputing and caching data, and optimizing network round trips, helping you tune joins and data access, increase throughput with parallelism, leverage materialized views and result caching, and reduce latency via the array interface and row prefetching. The result is an up-to-date, practical guide that helps you diagnose faster, fix them with confidence, and keep Oracle Database performance on track across releases from 12g to 26ai.\u003c\/p\u003e\n\u003cp\u003eWhat You Will Learn\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDiagnose performance with SQL trace, PL\/SQL profilers, dynamic views, AWR, and Statspack\u003c\/li\u003e\n\u003cli\u003eConfigure the query optimizer and read execution plans for efficiency and stability\u003c\/li\u003e\n\u003cli\u003eApply hints, SQL plan baselines, SQL profiles, and SQL patches to manage execution plans\u003c\/li\u003e\n\u003cli\u003eReduce parsing overhead while maintaining throughput\u003c\/li\u003e\n\u003cli\u003eOptimize data access and join strategies for predictable performance\u003c\/li\u003e\n\u003cli\u003eImprove throughput with parallel execution and precomputation via materialized views and result caching\u003c\/li\u003e\n\u003cli\u003eReduce latency by optimizing network round trips (array interface, row prefetching)\u003c\/li\u003e\n\u003cli\u003eStrengthen physical design choices to sustain application performance\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eWho This Book is For\u003c\/p\u003e\n\u003cp\u003ePerformance analysts, database administrators, and application developers involved in troubleshooting performance problems in applications that use Oracle Database.\u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003cdiv data-olk-copy-source=\"MessageBody\"\u003e\n\u003cstrong\u003eChristian Antognini\u003c\/strong\u003e is a strong believer that, at its core, data, and how effectively companies process and leverage it, drives success. Since 1995, he has focused on the efficient use of database engines. His main interests include logical and physical database design, query optimizers, and everything related to data processing and application performance management.\u003c\/div\u003e\r\n\u003cdiv data-olk-copy-source=\"MessageBody\"\u003e\n\u003cbr\u003eHe updated his best-selling book to leave a written record of his knowledge and experience on the subject as he nears the end of his professional career.\u003c\/div\u003e\n\u003c\/div\u003e\u003cbr\u003e\u003ctable\u003e\n\u003ctr\u003e\n\u003ctd\u003ePublication Date: \u003c\/td\u003e\n\u003ctd\u003e12 March 2027\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003ePublisher: \u003c\/td\u003e\n\u003ctd\u003eApress\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eImprint: \u003c\/td\u003e\n\u003ctd\u003eApress\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eISBN-13: \u003c\/td\u003e\n\u003ctd\u003e9798868832246\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eFormat: \u003c\/td\u003e\n\u003ctd\u003ePaperback softback\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003c\/table\u003e","brand":"Apress","offers":[{"title":"Default Title","offer_id":51691702681740,"sku":"9798868832246","price":67.49,"currency_code":"USD","in_stock":true}],"url":"https:\/\/fh90cf-fv.myshopify.com\/products\/9798868832246","provider":"Late Knight Books and Services, LLC","version":"1.0","type":"link"}