Oracle OLEDB Provider on 8i parses the SQL Twice

From: <vm.shinde_at_gmail.com>
Date: 24 Feb 2006 03:53:42 -0800
Message-ID: <1140782022.016806.261770_at_z34g2000cwc.googlegroups.com>



Dear all

   Scenario:

  1. We have a WinForm application using .NET that creates Sql statements to be executed.
  2. We have an Oracle database 8i.

        we are using OraOLEDB.Oracle provider for data access

        following is the connection string
        ConnectionString="Provider=OraOLEDB.Oracle;User ID=userId;Data
Source=TestDB;Password=itbagain;distribtx=0;";

        as i am looking at the SQL TRACE it shows that each statement get
parsed twice at Database End.

        call count cpu elapsed disk query current

     rows
        ------- ------  -------- ---------- ---------- ----------


        Parse 25 0.12 0.12 0 0    0

        0
        Execute     12      1.66       1.89          0          0
   0
        1
        Fetch       10      0.06       0.08          0        901
  20
        0
        ------- ------  -------- ---------- ---------- ----------


        total 47 1.84 2.09 0 901   20

        1

        as this affects on performance of the application.

        I tried with Oracle 10G its working fine, the problem is for 8i.

        kindlly suggest if i am missing any connection string attribute,or
something else.

Thanks and Regards.

Vivek Received on Fri Feb 24 2006 - 12:53:42 CET

Original text of this message