Extremely slow loading of network SQL files

[Bradnam]

Some of our databases have to be accessed from a Windows 'Jump Server'; we recently upgraded these to Windows Server 2012 R2 and we now have an issue loading external SQL files into PLSQL Developer.

e.g. When I connect to the jump server using RDP, my local drives are mapped via tsclient. I have those tsclient 'drives' mapped in the 'Files' tab within PL SQL Developer. Loading a SQL file from one of those mapped directories used to be quick (under Windows Server 2003) but it can now take 5 minutes+ to load an 800 line package body (saved as a '.sql' file)!

PLSQL Developer Details:

PL/SQL Developer
Version 12.0.2.1818 (64 bit)
407.96850 - Unlimited user license
Service Contract: 01/09/2017
Windows 8.1 Build 9600

Physical memory : 67,108,404 kB (61,927,436 available)
Paging file : 73,398,836 kB (66,716,032 available)
Virtual memory : 137,438,953,344 kB (137,438,559,064 available)

Loading the same .sql file in notepad++ is instantaneous so I don't believe we have any network latency.

Is this behaviour that has been seen before and have you any ideas on a fix?

Thanks,

Steve

 

[Marco Kalter]

Can you update to the latest 12.0.7 version and try again?

 

[Bradnam]

Marco,

I have loaded the latest version and the behaviour is the same. Please advise of the next steps to take - is there any debug I can add?

Steve

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the PL/SQL Developer shortcut and add the DebugSQL parameter? For example:

"C:\Program Files\PLSQL Developer 12\plsqldev.exe" DebugSQL

Reproduce the problem and send me the debug.txt file that is generated in the %APPDATA%\PLSQL Developer 12 directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer 12).

 

[Bradnam]

Amended the shortcut but no file gets created (open PLSQL Dev, run a simple select, try and load an external piece of SQL, shut down). I'll try this on some more servers tomorrow.......

 

[Bradnam]

Additional....

Marco - I have tried running PSD with the DebugSQL option on my Windows 7 machine (local install, no loading issues) and everything logs correctly. However, if I try this on our Jump Servers (Windows Server 2012, where the loading issue occurs) then no debug.txt file is created. I have also tried on our old Windows 2008 servers and no debug file is created there either.

 

[Marco Kalter]

Maybe this is an environment problem. Can you start PL/SQL Developer on Windows Server 2012 without connecting, go to Help > Support Info and send me the text from the "Info" tab page?

 

[Bradnam]

PL/SQL Developer
Version 12.0.7.1837 (64 bit)
407.96850 - Unlimited user license
Service Contract: 01/09/2017
Windows 8.1 Build 9600

Physical memory : 67,108,404 kB (61,822,876 available)
Paging file : 73,398,836 kB (68,503,404 available)
Virtual memory : 137,438,953,344 kB (137,438,661,336 available)

Parameters
C:\Program Files\PLSQL Developer 12\plsqldev.exe
DebugSQL

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False
Allow Multiple Connections: True

Preference Files
C:\Program Files\PLSQL Developer 12\Preferences\Default\Default.ini
C:\Users\S38150\AppData\Roaming\PLSQL Developer 12\Preferences\S38150\default.ini

License File
C:\Users\S38150\AppData\Roaming\PLSQL Developer 12\aalf.dat

Debug file
C:\Program Files\PLSQL Developer 12\PlSqlDev.elf

Plug-Ins
*Active Query Builder (C:\Program Files\PLSQL Developer 12\PlugIns\ActiveQueryBuilder.dll)
*PL/SQL Documentation (plsqldoc) (C:\Program Files\PLSQL Developer 12\PlugIns\plsqldoc.dll)
(* is Active)

Aliases
(ADDRESS
(CONNECT_DATA
(DESCRIPTION
(HS
(PROTOCOL
...

Homes
OraClient12Home1 (C:\Oracle\product\12.1.0\client_1)

DLLs
C:\Oracle\product\12.1.0\client_1\bin\oci.dll

TNS File
C:\Oracle\product\12.1.0\client_1\Network\Admin\tnsnames.ora

Using
Home: OraClient12Home1
DLL: C:\Oracle\product\12.1.0\client_1\bin\oci.dll
OCI: version 12.1 (12.1.0.2.0)

Process
Working Set = 129,146,880
Memory = 46,510,232
GDI Objects = 600
User Objects = 342
Handles = 364

Monitor
PixelsPerInch = 96

Id = 0
Primary = True
Handle = 65537
Left = 0
Top = 0
Width = 1700
Height = 938

MainFormOnTaskbar = False

 

[Bradnam]

Marco,

We have managed to generate a debug file on the Windows 2012 server - how do I upload it to you?

Steve

 

[Marco Kalter]

You can send it to support@allroundautomations.com.

 

[Bradnam]

File emailed Marco....

 

[Bradnam]

Marco,

Did you recieve the log file I emailed?

 

[Marco Kalter]

Yes, we're looking into this.

 

[Bradnam]

Any update Marco?.....seems to have gone very quiet!

Steve

 

[Bradnam]

It has been over 2 weeks since I uploaded the log file....has it given any insight into this load problem?

 

[Bradnam]

Did my trace show anything? No updates since 12th November

 

[Marco Kalter]

The debug file did not reveal any problems. Can you try the same with the current 13.0 version? If it is also slow, can you generate a new debug.txt file with 13.0?

 

[Bradnam]

We have put a copy of the latest version of PL SQL Developer onto our Windows 2012 Server and run in debug mode.

I have opening PLSQL Dev, loaded a 480 line file from the desktop and loaded a copy of that file from a mapped tsclient drive. The local copy showed an instant load while the remote copy took nearly 4 minutes. Sending the debug.txt file to the Support mailbox now.