BE SHARING

rowprefetch

Database Administration & Monitoring, Oracle

ARRAYSIZE or ROWPREFETCH in sqlplus?

08.01.2020 by Clemens Bleile

ARRAYSIZE or ROWPREFETCH in sqlplus? What is the difference between the well known sqlplus-setting arraysize and the new sqlplus-12.2.-feature rowprefetch? In Blog https://www.dbi-services.com/blog/oracle-fasttrue-in-sqlplus-some-thoughts-about-rowprefetch/ I showed a case, which helps to reduce the logical IOs when(…)

Database Administration & Monitoring, Oracle

Oracle FAST=TRUE in sqlplus? Some thoughts about rowprefetch

05.01.2020 by Clemens Bleile

During my time as a Consultant working on Tuning Tasks I had the feeling that many people think that there is an Oracle-parameter “FAST=TRUE” to speed up the performance and throughput of the database calls. Unfortunately such a parameter is(…)