FW: ODP.NET and REF Cursor Performance issue.
From: Siddiqui, Younus <younus.siddiqui_at_eds.com>
Date: Fri, 12 Sep 2008 09:22:19 -0400
Message-ID: <DE8F7694EDC1624C8F353A258392EF7D02E76882@usahm212.amer.corp.eds.com>
Date: Fri, 12 Sep 2008 09:22:19 -0400
Message-ID: <DE8F7694EDC1624C8F353A258392EF7D02E76882@usahm212.amer.corp.eds.com>
> 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
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Sep 12 2008 - 08:22:19 CDT