{"product_id":"9780071824828","title":"Oracle PL\/SQL Performance Tuning Tips \u0026 Techniques","description":"\u003cb\u003eAuthor(s): Rosenblum, Michael, Dorsey, Paul\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e\n\n\u003ch4\u003ePublisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, \u003cspan\u003e  \u003c\/span\u003eauthenticity, or access to any online entitlements included with the product.\u003c\/h4\u003e\u003cbr\u003e\u003cbr\u003e\u003ch4\u003eProven PL\/SQL Optimization Solutions\u003c\/h4\u003e\u003cp\u003eIn \u003ci\u003eOracle PL\/SQL Performance Tuning Tips \u0026amp; Techniques\u003c\/i\u003e, Oracle ACE authors with decades of experience building complex production systems for government, industry, and educational organizations present a hands-on approach to enabling optimal results from PL\/SQL. The book begins by describing the discovery process required to pinpoint performance problems and then provides measurable and repeatable test cases. In-depth coverage of linking SQL and PL\/SQL is followed by deep dives into essential Oracle Database performance tuning tools. Real-world examples and best practices are included throughout this Oracle Press guide. \u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eFollow a request-driven nine-step process to identify and address performance problems in web applications\u003c\/li\u003e\n\u003cli\u003eUse performance-related database tools, including data dictionary views, logging, tracing, PL\/SQL Hierarchical Profiler, PL\/Scope, and RUNSTATS \u003c\/li\u003e\n\u003cli\u003eInstrument code to pinpoint performance issues using call stack APIs, error stack APIs, and timing markers\u003c\/li\u003e\n\u003cli\u003eEmbed PL\/SQL in SQL and manage user-defined functions \u003c\/li\u003e\n\u003cli\u003eEmbed SQL in PL\/SQL using a set-based approach to handle large volumes of data \u003c\/li\u003e\n\u003cli\u003eProperly write and deploy data manipulation language triggers to avoid performance problems\u003c\/li\u003e\n\u003cli\u003eWork with advanced datatypes, including LOBs and XML\u003c\/li\u003e\n\u003cli\u003eUse caching techniques to avoid redundant operations\u003c\/li\u003e\n\u003cli\u003eEffectively use dynamic SQL to reduce the amount of code needed and streamline system management\u003c\/li\u003e\n\u003cli\u003eManage version control and ensure that performance fixes are successfully deployed\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eCode examples in the book are available for download. \u003c\/p\u003e\n\n\u003cbr\u003e\u003cbr\u003eReview(s):\u003cbr\u003e\u003cbr\u003e\u003cbr\u003eEAN: 9780071824828\u003cbr\u003e\u003cbr\u003eAge Group:  \u003cbr\u003e\u003cbr\u003eNumber of Pages: 336\u003cbr\u003e\u003cbr\u003eWeight: 583.3 gr\u003cbr\u003e\u003cbr\u003e","brand":"McGraw Hill","offers":[{"title":"Paperback \/ softback","offer_id":43845797282030,"sku":"9780071824828","price":89.88,"currency_code":"AUD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0630\/9612\/7726\/products\/9780071824828_1e254202-36a0-4cc4-b4a5-24dd621d2a0a.jpg?v=1671237285","url":"https:\/\/bookland.com.au\/products\/9780071824828","provider":"Book Land AU","version":"1.0","type":"link"}