After generating ADDM report for tuning a PL/SQL procedure we got following suggestion as a TOP recommendation. How do we achieve this in PL/SQL?
After som eresearch, we found that It seems we can increase arraysize in sqlplus easily but we are confused what all this means from PL/SQL perspective.
Below is an excerpt from the report:
Action
Use bigger fetch arrays while fetching results from the SELECT statement
with SQL_ID "grgzfgtgvxq8c".
Related Object
SQL statement with SQL_ID grgzfgtgvxq8c
The SQL is very big spanning about 200 lines. If it is needed I can post it here.
Thanks in advance !