packtpub Free Learning - Daily Free eBook

[Isuru]

July 19 2016

Oracle Database 11gR2 Performance Tuning Cookbook

Effectively apply performance tuning principles with concise recipes

What You Will Learn

• Design applications that run at lightning speed
  
• Implement fast and scalable SQL and PL/SQL code
  
• Choose the correct structures to store the data and access them
  
• Optimize sort operations, such as order-by, Top-N queries, ranking, and set operators
  
• Help the optimizer to choose the right access plan to retrieve data at the best available speed
  
• Load data in the database at a faster speed by using the correct tools and options
  
• Tune the database memory to obtain maximum performance using available resources
  
• Tune the I/O operations, by designing a database over the I/O system
  
• Tune and reduce contention issues on data and structures by using an optimal design
  

https://www.packtpub.com/packt/offers/free-learning