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>

> 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 along with one-off
> patch as recommended without luck.
> The database is 4-node RAC on Linux x86-64-bit.
> Thank you

Received on Fri Sep 12 2008 - 08:22:19 CDT

Original text of this message