Hi Sayan,
yes, as the LOB pre-fetching i was talking about is something different:
http://docs.oracle.com/database/122/LNOCI/lobs-and-bfile-operations.htm#LNOCI07100
Best Regards
Stefan Koehler
Independent Oracle performance consultant and researcher
Website: http://www.soocs.de
Twitter: @OracleSK
Sayan Malakshinov <xt.and.r@xxxxxxxxx> hat am 15. September 2017 um 16:31--
geschrieben:
Hi Stefan,
I've just tested LOBPREFETCH parameter in sqlplus 12.2 with the following
query:
SQL> set lobprefet 10000 arrays 1000 autot trace stat;
SQL> select to_clob('1') from dual connect by level<=100;
and it seems it can't reduce extra roundtrips for small lobs:
SQL*Plus 12.2: 302 SQL*Net roundtrips to/from client
SQLcl : 182
SQL*Developer: 11