Re: Ref Cursor

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 <http://www.oaktable.net>
Bjorn.Engsig@MiracleAS.dk - http://MiracleAS.dk



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?ISO-8859-1?Q?Bj=F8rn_Engsig?=
  INET: bjorn_at_miracleas.dk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).