in
tri
home of the trivadians
Alle Ordnungsbegriffe » .Net » Oracle (RSS)

Nach Ordnungsbegriffen durchsuchen

  • Using Oracle 11g client result_cache with ODP.NET

    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 (restart required) to the amout...
    Erstellt in Urs Meier - Blog on IT (Weblog) von Anonymous am 04-24-2008

  • Oracle Query Notification revisited

    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 Query Notification support. Change detection can...
    Erstellt in Urs Meier - Blog on IT (Weblog) von Anonymous am 04-23-2008

  • HA Events vs. TAF with RAC and ODP.NET

    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 or without HA events 3. Connection with HA events...
    Erstellt in Urs Meier - Blog on IT (Weblog) von Anonymous am 12-05-2007

  • Array Insert with ODP.NET

    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 OracleParameter pFirstname = new OracleParameter...
    Erstellt in Urs Meier - Blog on IT (Weblog) von Anonymous am 11-18-2007

  • RAC FAN and FCF

    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 instance immediatly (which is good). Java puts 2 connections...
    Erstellt in Urs Meier - Blog on IT (Weblog) von Anonymous am 05-15-2007

  • More on RAC and RLB

    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 AQ send the RLB information back to client I had...
    Erstellt in Urs Meier - Blog on IT (Weblog) von Anonymous am 05-15-2007
Seite 1 von 1 (6 Treffer)
/