Performance Tuning

From: Stevan R. Makarevich <smakar_at_primenet.com>
Date: 1997/04/23
Message-ID: <3362d05f.1446145@news.primenet.com>#1/1

Background:
We are developing a WEB application using the Oracle WEBSERVER Toolkit and PL/SQL. The data resides on a mainframe DB2 database (ver 4.1), and is accessed via the Oracle Transparent Gateway for DB2.

Question:
What is the most efficient way of cursor processing in PL/SQL? We know that in DB2 SQL, a block fetch can be forced with the use of "SELECT FOR FETCH'; is there a similar statement in PL/SQL? We have not been able to find it... is it implied, or is each fetch an I/O over the network?

Information would be greatly appreciated. Received on Wed Apr 23 1997 - 00:00:00 CDT