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
Date: 24 Feb 2006 03:53:42 -0800
Message-ID: <1140782022.016806.261770_at_z34g2000cwc.googlegroups.com>
Dear all
Scenario:
- We have a WinForm application using .NET that creates Sql statements to be executed.
- 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;DataSource=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