When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
Oracle Performance Tuning for Developers
This course introduces developers to the fundamental principles of performance tuning when using Oracle as their backend database.
This Course Includes
pluralsight
4 (278 reviews )
7 hour 1 minutes 
english
Online - Self Paced
core courses
pluralsight
About Oracle Performance Tuning for Developers
Oracle is one of the most popular database systems in use today. Yet many developers do not understand how Oracle works or the principles behind developing high performance Oracle applications. This course targets the .NET or Java developer who is writing an application with a backend Oracle database. Topics include: understanding how Oracle is processing your SQL statements through generating and interpreting execution plans, to designing and using indexes to speed up the data access of your application. Also included is how to use Oracle dynamic performance views to view real time information about Oracle performance, including which SQL statements are the most costly to run. The use of bind variables, connection pooling, and some application best practices round out the topics covered in the course.
What You Will Learn?
- Why Performance Tuning Matters : 21mins.
- Oracle Architecture and Performance Basics : 48mins.
- Connections and Connection Pools : 28mins.
- Bind Variables : 43mins.
- Statement Level Performance Tuning : 34mins.
- Execution Plans in Depth : 46mins.
- Indexing Essentials : 48mins.
- Advanced Indexing Techniques : 46mins.
- Application Indexing Practices : 42mins.
- Monitoring Oracle Applications : 35mins.
- Pitfalls and Practices : 26mins.