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

Dynamic Oracle Performance Analytics: Using Normalized Metrics to Improve Database Speed

by Roger Cornejo
Save 35% Save 35%
Current price ₹4,040.00
Original price ₹6,214.00
Original price ₹6,214.00
Original price ₹6,214.00
(-35%)
₹4,040.00
Current price ₹4,040.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: 9781484241363
  • Binding: Paperback
  • Subject: N/A
  • Publisher: Apress
  • Publisher Imprint: Apress
  • Publication Date:
  • Pages: 200
  • Original Price: EUR 54.99
  • Language: English
  • Edition: N/A
  • Item Weight: 354 grams
  • BISAC Subject(s): Database Administration & Management and System Administration / Storage & Retrieval

From the Back Cover
Use an innovative approach that relies on big data and advanced analytical techniques to analyze and improve Oracle Database performance. The approach in this book is a step-change away from traditional methods. Instead of relying on a few hand-picked, favorite metrics, or wading through multiple specialized tables of information such as those found in an automatic workload repository (AWR) report, you will draw on all available data, applying big data methods and analytical techniques to draw impactful, focused performance improvement conclusions.
This book reviews past and present practices, along with available tools, to help you pinpoint areas for improvement. The book then guides you through a step-by-step method that can be used to take advantage of all available metrics to identify problem areas and work toward improving them. The method presented simplifies the tuning process and solves the problem of metric overload.
You will learn how to: collect and normalize data, generate deltas that are useful in performing statistical analysis, create and use a taxonomy to enhance your understanding of problem performance areas in your database and its applications, and create a root cause analysis report that enables understanding of a specific performance problem and its likely solutions.
What You'll Learn:

  • Collect and prepare metrics for analysis from a wide array of sources
  • Apply statistical techniques to select relevant metrics
  • Create a taxonomy to provide additional insight into problem areas
  • Provide a metrics-based root cause analysis regarding the performance issue
  • Generate an actionable tuning plan prioritized according to problem areas
  • Monitor performance using database-specific normal ranges

​Roger Cornejo has been an Oracle enthusiast since 1985 (versions 4-12c). He has experience on large enterprise-class Oracle applications, not only in performance troubleshooting and tuning, but also in systems architecture, information modeling, and software development/project management. For the past 10 years, his main focus has been database performance analysis and tuning, with much of his time spent exploring the complexities and usefulness of AWR* tuning data. He produces Oracle Database tuning results across 12c/11g/10g (and occasionally 9i) databases. He is a thought-leader in his field, and has been recognized for his expertise in tuning. He has presented at the past eight East Coast Oracle Conferences, as well as at COLLABORATE14 and COLLABORATE18, RMOUG16, and Hotsos 2017-2018.

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