Re: FW: ODP.NET and REF Cursor Performance issue.
Date: Fri, 12 Sep 2008 11:38:44 -0400
Are there XML columns in the refcursor?
On Fri, Sep 12, 2008 at 9:22 AM, Siddiqui, Younus <younus.siddiqui_at_eds.com>wrote:
> Has anyone come across refcursor slowness issue when using ODP.NET<http://odp.net/>.
> We tested the query using sqlplus as well as a package and it returns result
> set in subseconds. But using ODP.NET <http://odp.net/> the it takesminutes 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
-- Rumpi Gravenstein -- http://www.freelists.org/webpage/oracle-lReceived on Fri Sep 12 2008 - 10:38:44 CDT