Re: Weird Oracle 12.2 issue .. - FIXED

So there are cases where the network is blamed rightfully! And I always thought that “it’s the network” is just a lame excuse. :)

Glad to hear that your issue has been solved and that the performance is on-par or even better than 11g. We sometimes tend to forget the upgrades can go smoothly too, at least from a database perspective. :)

Cheers,

Gerald Venzl | Senior Principal Product Manager Email: gerald.venzl_at_oracle.com <mailto:gerald.venzl_at_oracle.com> | Phone: +1.650.633.0085 <tel:+16506330085> Oracle ST & Database Development
400 Oracle Parkway | Redwood Shores | 94065 | USA

> On Sep 15, 2017, at 12:40, Upendra nerilla <nupendra_at_hotmail.com> wrote:
>
> Thanks everyone for the great feedback and pointers.
> It turns out to be something in the underlying VM environment..
> When we migrated the DB from 11g to 12c environment, the underlying VM farm was setup in a different network than where it was.. That traffic ended up going through a couple more switches and a firewall which added more latency..
> Even though the network tests should have caught them they somehow were kept saying everything was good.😞
> Both networks were fine, it is only the communication across the networks which were the issue.. nevertheless it should have been caught..
>
> This morning when I spoke to someone else the different zoning of the VM came to light. We migrated the VM to the other zone which fixed most of the issues. We had to copy a SQL profile from 11g to 12c to address another issue. Looks like the 12c response times are on-par or better than 11g. Yay!!
> Thanks again for everyone in the thread in chiming in and providing valuable feedback..
>
> -Upendra
>
>
> From: Stefan Koehler <contact_at_soocs.de <mailto:contact_at_soocs.de>>
> Sent: Friday, September 15, 2017 10:55 AM
> To: xt.and.r_at_gmail.com <mailto:xt.and.r_at_gmail.com>
> Cc: Oracle-L; Upendra nerilla
> Subject: 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 <http://docs.oracle.com/database/122/LNOCI/lobs-and-bfile-operations.htm#LNOCI07100>
> 8 LOB and BFILE Operations - Oracle <http://docs.oracle.com/database/122/LNOCI/lobs-and-bfile-operations.htm#LNOCI07100>
> docs.oracle.com <http://docs.oracle.com/>
> OCI includes a set of functions for performing operations on large objects (LOBs) in a database. Persistent LOBs (BLOBs, CLOBs, NCLOBs) are stored in the database ...
>
>
> Best Regards
> Stefan Koehler
>
> Independent Oracle performance consultant and researcher
> Website: http://www.soocs.de <https://urldefense.proofpoint.com/v2/url?u=http-3A__www.soocs.de&d=DwMGaQ&c=RoP1YumCXCgaWHvlZYR8PQcxBKCX5YTpkKY057SbK10&r=zUfLpQOHlJTnMpyBPavQbdKRMt_LVE0xNvj73TLA4pQ&m=1OJh4zNzHK6460EgqWEbNRPmBecQo3hV4heqAFSG65Y&s=l-A0yMtae6ou8H-Wb6TGPElH6HKGv5R4D1qj-0sXJt8&e=>
> soocs - Your reliable partner for top-notch Oracle ... <https://urldefense.proofpoint.com/v2/url?u=http-3A__www.soocs.de_&d=DwMGaQ&c=RoP1YumCXCgaWHvlZYR8PQcxBKCX5YTpkKY057SbK10&r=zUfLpQOHlJTnMpyBPavQbdKRMt_LVE0xNvj73TLA4pQ&m=1OJh4zNzHK6460EgqWEbNRPmBecQo3hV4heqAFSG65Y&s=fU92SS9KWhJ2pbhcrzKrRLnw515nJ7YNtC9QlJGnHOQ&e=>
> www.soocs.de <http://www.soocs.de/>
> Soocs is an independent Oracle database consultancy that focuses on the Oracle database technology stack. It is located in Germany and operates throughout the whole ...
>
> Twitter: _at_OracleSK
>
> > Sayan Malakshinov <xt.and.r_at_gmail.com <mailto: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