Re: Tuning Question

From: Piotr Kolodziej <pkol_at_otago.gda.pl>
Date: Thu, 28 Jan 1999 16:20:53 +0100
Message-ID: <78pvcs$o79$1@korweta.task.gda.pl>

xx wrote in message <78pton$6ii_at_romeo.logica.co.uk>...
>I am running an SQL statement using sqlplus and it takes about
>1.9 seconds to complete. In Forms 4.5 I build the same SQL statement and it
>takes 2 min 46 seconds to complete. [cut]
>The explain plan is the same in both instances.

What's the type of statement ? Query returning hundreds or thousands of rows and stored in a block? If so, the problem may be buffering of returned rows by Forms.

--
Piotr Kolodziej pkol_at_otago.gda.pl
Just my private opinion. Received on Thu Jan 28 1999 - 09:20:53 CST