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.
Author Name: David Berry
Author Description:
David Berry is a software engineer with over 15 years of application development experience. He started developing software in Java 1.0 using an Oracle 7 backend. Making the switch to Microsoft .NET when it was released, he has worked with every version of .NET since. He has also worked with every version of Oracle since Oracle 7 and ever version of SQL Server since SQL Server 7. His experience spans a broad range of industries including semiconductors, financial services, insurance an gove… more

Table of Contents

• 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