arraysize and PL/SQL [message #644703] |
Fri, 13 November 2015 18:35 |
|
uman2631
Messages: 16 Registered: November 2011
|
Junior Member |
|
|
My DBA wants us to set arraysize=500 to reduce network roundtrips. But most of our code is executing stored procedures. Does setting arraysize in SQL*Plus actually have any affect when executing a stored procedure that does a select?
I.e.
SQLPLUS> set arraysize 500;
SQLPLUS> exec mystoredprocedure;
Are the select statements in mystoredprocedure actually affected by the arraysize parameter?
|
|
|
|
|
Re: arraysize and PL/SQL [message #644713 is a reply to message #644703] |
Sun, 15 November 2015 12:57 |
Lalit Kumar B
Messages: 3174 Registered: May 2013 Location: World Wide on the Web
|
Senior Member |
|
|
uman2631 wrote on Sat, 14 November 2015 06:05My DBA wants us to set arraysize=500 to reduce network roundtrips. But most of our code is executing stored procedures. Does setting arraysize in SQL*Plus actually have any affect when executing a stored procedure that does a select?
Nice explanation by Solomon Yakobson about OCI behavior here.
|
|
|