RE: Weird Oracle 12.2 issue .. - FIXED

Even when it’s not the network, it’s the NETWORK. We should make a poster.

From: Upendra nerilla [mailto:nupendra_at_hotmail.com] Sent: Friday, September 15, 2017 3:40 PM To: Stefan Koehler <contact_at_soocs.de>; xt.and.r_at_gmail.com Cc: Oracle-L <oracle-l_at_freelists.org> Subject: Re: Weird Oracle 12.2 issue .. - FIXED

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 <HYPERLINK "mailto:contact_at_soocs.de"contact_at_soocs.de> Sent: Friday, September 15, 2017 10:55 AM To: HYPERLINK "mailto:xt.and.r_at_gmail.com"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

HYPERLINK "http://docs.oracle.com/database/122/LNOCI/lobs-and-bfile-operations.htm#LNOCI07100"8 LOB and BFILE Operations - Oracle

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: HYPERLINK "https://urldefense.proofpoint.com/v2/url?u=http-3A__www.soocs.de&d=DwMGaQ&c=RoP1YumCXCgaWHvlZYR8PQcxBKCX5YTpkKY057SbK10&r=Z7TxYgTRa8b2Qmi2Gp6fvdZIJHBIir8RWfL4YTvXYOM&m=GWwGxPhwwNewYvZ5drJGKKmGqz9vXxVZcWubLAE0hMc&s=2Mk3iz8XVSbgob5XzeSjYsKxkbZpudbkIyS-xim3Bvg&e="http://www.soocs.de

HYPERLINK "https://urldefense.proofpoint.com/v2/url?u=http-3A__www.soocs.de_&d=DwMGaQ&c=RoP1YumCXCgaWHvlZYR8PQcxBKCX5YTpkKY057SbK10&r=Z7TxYgTRa8b2Qmi2Gp6fvdZIJHBIir8RWfL4YTvXYOM&m=GWwGxPhwwNewYvZ5drJGKKmGqz9vXxVZcWubLAE0hMc&s=fetecD8KuwDcnI3Gvky1O6U9JQhvWHCA11sik9in7Yo&e="soocs - Your reliable partner for top-notch Oracle ...

HYPERLINK "http://www.soocs.de"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 <HYPERLINK "mailto:xt.and.r_at_gmail.com"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