Re: Weird Oracle 12.2 issue ..
From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Fri, 15 Sep 2017 17:31:59 +0300
Message-ID: <CAOVevU6MX=gp6UyN85MBFQuFj5Fa8HoAGmDoO6bYa8fQ9RGo5g_at_mail.gmail.com>
Date: Fri, 15 Sep 2017 17:31:59 +0300
Message-ID: <CAOVevU6MX=gp6UyN85MBFQuFj5Fa8HoAGmDoO6bYa8fQ9RGo5g_at_mail.gmail.com>
Hi Stefan,
I've just tested LOBPREFETCH parameter in sqlplus 12.2 with the following
query:
and it seems it can't reduce extra roundtrips for small lobs:
SQL> set lobprefet 10000 arrays 1000 autot trace stat;
SQL> select to_clob('1') from dual connect by level<=100;
SQL*Plus 12.2: 302 SQL*Net roundtrips to/from client
SQLcl : 182
SQL*Developer: 11
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Sep 15 2017 - 16:31:59 CEST