Wednesday, June 28, 2006
Improving performance in your ODP.NET application
To summarize - his 3 tips were:
- Use a Connection Pool - enabled by setting an ODP.NET connection string attribute. Make sure to have a sufficiently high minimum pool size.
- Use the FetchSize and RowSize Properties - properties of the OracleDataReader and OracleCommand object respectively. Again, needs to be tuned depending on how you are using the network and the size of your table data.
- Use Statement Caching - another ODP.NET connection string attribute
I'll add to these the standard "best practices for performance" tips that we always tell customers:
- Use anonymous PL/SQL blocks or stored procedures to execute multiple SQL statements in one round trip
- Use Parameter Array Binding - A SQL statement will execute once for each array value when bound to the array
- Use PL/SQL Associative Arrays - pass in an array to your stored procedure or function
- Use Oracle LOB classes and expecially the InitialLOBFetchSize property of the OracleDataReader when you are accessing LOB data. This helps you tune your application for the size of data that you are expecting.
Hope this helps you to get every last bit of performance from your application!
Monday, June 12, 2006
Oracle on .NET and Windows BOF Session
Just a reminder that we have a "Birds of a Feather" session on Tuesday evening where you can come and ask a panel of experts about Oracle, .NET and Windows:
BOF08 Using Oracle on Windows and .NET
Day/Time: Tuesday, June 13 6:30 PM - 7:30 PMHave questions about using Oracle on .NET or Windows? Want to learn more about running Oracle with Microsoft platforms? Come discuss these topics with Oracle experts and your peers; learn about best practices; examine recent Oracle developments, such as ADO.NET 2.0 and Visual Studio 2005 support; or just network with other Oracle users.
Session Type(s): Birds of a Feather
Later this week we have a joint session with David Sceppa of Microsoft. Note that the location is different to what I provided earlier.
DATTLC44 New Features for Using .NET with Oracle Databases
Day/Time: Thursday, June 15 4:30 PM - 5:45 PM Room: DAT Theater 2 (Blue TLC Area)Speaker(s): Alex Keh, Christian Shay, David Sceppa
In this session we discuss the new ADO.NET 2.0 features such as UDTs and factory classes and how they apply to Oracle databases. We also cover Visual Studio tools for Oracle, including stored-procedure debugging and .NET stored-procedures support.
Track(s): Database Development and Administration, Developer Tools
Tonight (Monday) the Teched expo hall is open until 9 pm for the reception, so please come by for food, drink and an Oracle demo..
Here's a photo taken of me during "setup day" (Sunday afternoon)
Tuesday, June 06, 2006
Visit us at MS Teched in Boston
Oracle is a silver sponsor this year at Microsoft Tech Ed in Boston (June 11-16). Come visit myself and my colleagues at the Oracle booth (booth #516) and we will give you a hands on demo.
Technologies being demoed by the product experts at our booth include:
Oracle Data Provider for .NET (ODP.NET)
- new ADO 2.0 features
Oracle Developer Tools for Visual Studio .NET
- Visual Studio 2005 support
- Integrated PL/SQL Debugger
.NET Stored Procedures
Windows and .NET with Oracle Fusion Middleware
Oracle Real Application Clusters (RAC) on Windows
Oracle Enterprise Manager Oracle Database 10g Manageability on Windows
We have a "Birds of a Feather" session where you can come and ask a panel of experts about Oracle, .NET and Windows:
Using Oracle on Windows and .NET
Day/Time: Tuesday, June 13 6:30 PM - 7:30 PM
Location: To be determined
There's also an Oracle on .NET "Cabana" session with both Microsoft and Oracle speakers!
New Features for using .NET with Oracle Databases
Speakers: David Sceppa, Microsoft
Alex Keh, Oracle
Christian Shay, Oracle
Day/Time: Thursday, June 15, 4:30 PM-5:45 PM