Oracle Performance Tuning for Developers
This course introduces developers to the fundamental principles of performance tuning when using Oracle as their backend database.
What you'll learn
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.
Table of contents
- Introduction 1m
- System Scalability 4m
- Oracle Architecture Overview 5m
- Buffer Cache 3m
- Shared Pool 2m
- Program Global Area 2m
- Oracle Architecture Wrap Up 2m
- Performance Metrics 10m
- Performance Tuning and Database Size 6m
- Building Effective Performance Test Databases 4m
- Performance Tuning Database use Scenarios 10m
- Module Outline 2m
- Covering Indexes 8m
- Function Based Indexes Introduction 8m
- Demo - Function Based Indexes: Case Insensitive Search 4m
- Selective Row Indexing With Function Based Indexes 6m
- Demo - Function Based Indexes: Selective Indexing 3m
- Index Compression 6m
- Invisible Indexes 3m
- Demo: Invisible Indexes 4m
- Summary 2m
- Introduction 1m
- What Should I Index? 7m
- Indexing Costs and Overhead 5m
- Demo: Indexing Overhead 4m
- Similar Indexes 2m
- Monitoring Index Usage 4m
- Why isn't Oracle Using My Index? 1m
- Missing Leading Edge of Index 1m
- Index not Selective Enough 1m
- Using a Like Clause and a Leading Wildcard 3m
- Like Clauses and Index Selectivity 3m
- Function in the Where Clause 3m
- Data Type Conversion in the Where Clause 2m
- Outdated Database Statistics 3m
- Summary 1m
- Motivation for Performance Monitoring 6m
- Required Permissions 6m
- Introduction to Queries 1m
- Session Information 2m
- Session Resource Usage 1m
- What Statements are Running Right Now? 1m
- Finding the Worst Performing Statements 5m
- Statements Conducting Full Scan Operations 2m
- Retrieving Execution Plans 1m
- Monitoring Index Usage 2m
- Monitoring Hard Parsing and SQL Using Literal Values 3m
- Table Information 3m
- Index Information 1m
- Summary 1m
About the author
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