Re: Weird Oracle 12.2 issue ..

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: _at_OracleSK

> Sayan Malakshinov <xt.and.r_at_gmail.com> 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
>

--
http://www.freelists.org/webpage/oracle-l