Re: FW: ODP.NET and REF Cursor Performance issue.
From: Rumpi Gravenstein <rgravens_at_gmail.com>
Date: Fri, 12 Sep 2008 11:38:44 -0400
Message-ID: <9c9b9dc90809120838g4482ad8bl9fc75cc56acca39c@mail.gmail.com>
Date: Fri, 12 Sep 2008 11:38:44 -0400
Message-ID: <9c9b9dc90809120838g4482ad8bl9fc75cc56acca39c@mail.gmail.com>
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