Oracle Performance Tuning for Developers

MP4 | AVC 142kbps | English | 1024x768 | 15fps | 7h 01mins | AAC stereo 119kbps | 877 MB

Genre: Video Training

This course introduces developers to the fundamental principles of performance tuning when using Oracle as their backend database.

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.

Why Performance Tuning Matters21m 17s

Oracle Architecture and Performance Basics48m 51s

Connections and Connection Pools28m 15s

Bind Variables43m 2s

Statement Level Performance Tuning34m 45s

Execution Plans in Depth46m 19s

Indexing Essentials48m 38s

Advanced Indexing Techniques46m 22s

Application Indexing Practices42m 16s

Monitoring Oracle Applications35m 11s