Re: Poor report performance with sqlnet connection only, not jdbc

Assuming by 12c you mean 12.2.
This would be an ideal time to try out sqlplus fast mode https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sqpug/release-changes.html#GUID-476F5AFD-231A-47BD-8A75-5E5EA27896E3

Sqlplus -f

Hope that helps,
Andrew

On Thu, 10 May 2018 at 16:37, Vijay Sehgal <vijaysehgal21_at_gmail.com> wrote:

> Jay,
>
> not sure if you already checked arraysize settings between old and new
>
> Regards,
> Vijay Sehgal
>
> On May 10, 2018, at 11:28 AM, <Jay.Miller_at_tdameritrade.com> <
> Jay.Miller_at_tdameritrade.com> wrote:
>
> Here's an oddity. One of my app owners recently moved to a new reporting
> server. The old one had the 11g client on linux, the new one has the 12c
> client on windows.
>
>
>
> He has a number of reports automated to run through sqlplus and spool to a
> file. After the move a report that previously took only minutes to run
> took 8 hours. On the database side it shows all the extra time spent on
> sqlnet message to/from client.
>
>
>
> My first thought was that it was caused by network latency from the new
> location. traceroute/tracert did show a few more hops and a few more ms.
> However, when he tested running the same query through jdbc rather than
> sqlnet and spooling the output to the same location the report returned in
> minutes again.
>
>
>
> My next thought was to increase the sdu setting to the maximum on the
> client and database sqlnet.ora but that made no difference.
>
>
>
> Before we bite the bullet and rewrite the reporting automation to use jdbc
> does anyone have suggestions for anything else to try?
>
>
>
> Database version is 11.2.0.3
>
>
>
> Thanks!
>
> Jay Miller
>
> Sr. Oracle DBA
>
>
>
>

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