FW: ODP.NET and REF Cursor Performance issue.
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