Orlando .NET Code Camp | 2009

This session explores how to tune Oracle Data Provider for .NET (ODP.NET) for fast data retrieval and statement execution. Particular emphasis will be made on new ODP.NET and Oracle Developer Tools (ODT) for Visual Studio tuning features. ODP.NET introduces self-tuning, which optimizes data retrieval based on run-time sampling, and faster DataSet and OracleDataReader retrieval. ODT now includes the Oracle Performance Analyzer, which monitors the running application, highlights performance problems, and offers specific recommendations, such as SQL tuning and indexing. This session will show how to use these new features and existing performance tuning techniques, including statement caching, setting fetch sizes, and statement batching. The speaker, who works for Oracle Support, will also highlight the major "gotchas" that her customers frequently encounter.