1:45 PM Saturday Room: 4202
This session explores coding best practices and demonstrates how to use Visual Studio tuning tools for achieving faster data access performance with Oracle Data Provider for .NET (ODP.NET). It examines techniques for optimizing connection pooling, statement caching, data fetching and updating, statement batching, and Oracle datatype usage. Furthermore, it demonstrates tuning tools included with Oracle Developer Tools for Visual Studio, such as Oracle Performance Analyzer, which monitors the running application, highlights performance problems, and offers specific recommendations. Last, the session discusses best practices for ODP.NET and Oracle client deployment to your midtier servers or clients.