For developers and operations teams building and managing applications with ODP.NET (versions 10,11, and 12), the AppDynamics platform provides a comprehensive solution for monitoring and managing the performance of your .NET applications. With rapid installation and the most scalable architecture in the industry, AppDynamics solutions help you deploy your applications more quickly and with more confidence.
ODP.NET (short for "Oracle Data Provider for .NET) is an offshoot of Microsoft’s ADO.NET framework. Its OCI (Oracle Caller Interface) tool directly accesses an Oracle Database installation in the same way .NET data providers access Microsoft SQL server. It also lets developers leverage advanced Oracle Database features, such as Real Application Clusters, various advanced security protocols, and XML DB. The latest release of ODP.NET comes with several advanced features, including native PL/SQL Boolean data types, Identity column support, Transaction Guard, and multitenant container database support.
Application flow map
In this example, AppDynamics auto-discovers an ASP.NET tier and 2 backends. Home tier is making 2 ADO.NET backend database calls.The flow map shows the communication as the average number of calls per minute the tier is making for 2 ADO.NET calls and the average response.
AppDynamics takes transaction snapshots which contain diagnostic data to help you quickly analyze and troubleshoot problems with Oracle ODP.NET backend and other types of business transactions.
Drill down into a transaction snapshot to display the call graph for Oracle ODP.NET backend transactions. The call graph displays the code execution sequence timing, so you can identify which methods has problems. In this example, the Oracle.DataAccess.Client.OracleConnection:Open method is taking 63686 ms, 99.9% of the time for the Oracle ODP.NET backend call, it is displayed in red as an error had occured while executing this method. Click on the SQL Calls tab in the call graph. This shows the query executed, type of query, no. of times the query executed, avg time it takes to execute etc.
Oracle ODP.NET backend calls are detected under Databases. This section describes about the type of call, calls/min, response time etc. In this example, there is a Oracle ODP.NET backend call with 28046 calls/min, 1ms response time.Double click on the Oracle ODP.NET backend call will open its dashboard. This Dashboard shows the flow map of the Oracle ODP.NET backend call.
Oracle ODP.NET backend performance
AppDynamics collects metrics for backend performance (Oracle ODP.NET in this case). Use the metric browser to create graphs of critical statistics. The graph below shows calls per minute (in green) and average response time (in blue).