Nach Ordnungsbegriffen durchsuchen

Alle Ordnungsbegriffe » Oracle (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: , , ,
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: , , , ,
Linked Server Performance
07 März 07 04:23 | Urs Meier - Blog on IT
Stefan Frutiger from Trivadis has extended my performance tests with linked server between SQL Server 2005 and Oracle 10g. First the hardware setup was enhanced: - 2 IBM laptops (T41 and T42) with W2003 and 1GB RAM - crossed cable as dedicated network...
Abgelegt unter: , ,
Linked Server to Oracle
24 Dezember 06 03:42 | Urs Meier - Blog on IT
Because of some performance problems with Linked Severs between SQL Server and Oracle, I did some additional tests. I tested Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Developer...
Abgelegt unter: , ,
CLB_GOAL LONG or SHORT?
04 Oktober 06 09:39 | Urs Meier - Blog on IT
With Oracle 10g R2 FAN and FCF we can load balance connections and requests over a "service". The service is defined to be run on one or more instances on the RAC. Services take a CLB_GOAL LONG or SHORT and are created with DBMS_SERVICE.CREATE_SERVICE...
Abgelegt unter: , ,
Oracle 10g RAC load balancing
03 Oktober 06 07:51 | Urs Meier - Blog on IT
Lately we have done some tests with Oracle 10g R2 load balancing and connection failover for RAC. Both features are mainly useful for application servers. The bottom line: the JDBC driver from Oracle works, the ODP.NET provider not yet. Load balancing...
Abgelegt unter: , ,