Did you try with a 10046 trace?  Could it be an array vs. non-array fetch thing?  Which client environment are you using to fetch the rows from the ref cursor?

There is no init.ora involved with this.

/Bjørn.

Bahar, Rivaldi (BBASSI-CHQ) wrote:
Hi Listers,
Is there any specific parameters (init.ora, etc)  or tricks for Ref Cursor ?
Applications that using Ref Cursor running very slow
but those don't use Ref Cursor are running fast.
Tia.

-Riv-

****************************************************************************************************************
This e-mail, including any attachments, may include confidential and/or proprietary information,
and is intended for use only by the person or entity to which it is addressed.  If the reader of this
e-mail is not the intended recipient, or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution, or copying of this e-mail is strictly prohibited.  If you have
received this e-mail in error, please notify the sender by replying to this message and delete
this e-mail immediately.
****************************************************************************************************************
  

--
Bjørn Engsig, Miracle A/S
Member of Oak Table Network
[EMAIL PROTECTED] - http://MiracleAS.dk

Reply via email to