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@xxxxxxxxx> 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@xxxxxxxxxxxxxxxx> <
Jay.Miller@xxxxxxxxxxxxxxxx> 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
