FW: ODP.NET and REF Cursor Performance issue.

  • From: "Siddiqui, Younus" <younus.siddiqui@xxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 12 Sep 2008 09:22:19 -0400

> Has anyone come across refcursor slowness issue when using ODP.NET. We
> tested the query using sqlplus as well as a package and it returns
> result set in subseconds. But using ODP.NET the it takes minutes at
> times.  We opened a SR and are following OSS recommendations without
> luck .. We have updated the client to 10.2.0.4 along with one-off
> patch as recommended without luck.
> 
> The database is 4-node 10.2.0.3 RAC on Linux x86-64-bit. 
> 
> Thank you
> 
> 

Other related posts: