Nach Ordnungsbegriffen durchsuchen

Alle Ordnungsbegriffe » .Net (RSS)
Using Oracle 11g client result_cache with ODP.NET
24 April 08 02:10 | Urs Meier - Blog on IT
With Oracle 11g OCI clients can store result sets on the client. I was wondering how ODP.NET will use this feature and if there are any coding constraints. Required setup: The feature must be enabled server side by setting the init.ora parameter client_result_cache_size...
Abgelegt unter: , ,
Oracle Query Notification revisited
23 April 08 11:27 | Urs Meier - Blog on IT
A few month ago I compared the .NET query notification possibilites between SQL Server and Oracle. At that time Oracle could only dectect changes at table level; not at row level. With the new release of ODP.NET 11.1 and Oracle 11g Oracle enhances the...
Abgelegt unter: , ,
HA Events vs. TAF with RAC and ODP.NET
05 Dezember 07 07:31 | Urs Meier - Blog on IT
Lately I had a question in this Blog about an ORA-25408. My first thought was, that TAF and HA events should not be mixed. In order to confirm this, I wrote a small application with 3 connection possibilites 1. Normal connection 2. TAF connection with...
Abgelegt unter: , , ,
Bulk Copy with SQL Server
19 November 07 12:26 | Urs Meier - Blog on IT
SQL Server also offers an "array insert" possibility via .NET, which is called bulk copy . I wrote a similiar application as with the Oracle ODP.NET array insert. The point was not to compare Oracle vs. SQL Server, but to verify if the bulk...
Abgelegt unter: , ,
Array Insert with ODP.NET
18 November 07 05:39 | Urs Meier - Blog on IT
ODP.NET supports array insert in two ways: 1. Binding arrays using ArrayBindCount cmd.Parameters.Add("firstname", OracleDbType.Varchar2, firstNames, ParameterDirection.Input); where firstNames is string[] 2. Binding to PL/SQL associative Arrays...
Abgelegt unter: , ,
RAC FAN and FCF
15 Mai 07 07:59 | Urs Meier - Blog on IT
After the successfull RLB tests with RAC FAN events we re-tested the FCF with both Java and ODP.NET Startup As soon as the DBA puts an additional instance into a RAC service the client receives a FAN / FCF event. Both Java and .NET use the additional...
Abgelegt unter: , , , ,
More on RAC and RLB
15 Mai 07 07:32 | Urs Meier - Blog on IT
My last RAC tests with runtime load balancing and .NET were not successful. ODP.NET always distributed the workload in a round robin manner. Now I know why: It is a AQ bug. I had more than one IP address defined (my real one and one for my vmWare). Since...
Abgelegt unter: , , , ,