PL SQL Developer in a very slow network

[Aliaksandr_M]

Dear all,

can someone help me to configure the PL SQL Developer application to be used in the very slow network? I can see that a result of my query is coming very slow and the application "tcpview64.exe" shows that the tcp packet is too small (about 300..900 bytes).

I have tried my small .NET application and it is possible to manage it with the parameter "Fetchsize". Do we have something like that in the PL SQL Developer?

 

[Marco Kalter]

Can you let me know your PL/SQL Developer version?

 

[Aliaksandr_M]

Seems that the application works as expected. I have checked it once more and the size of the packet is more than 1 000 bytes (and it is totaly OK for us).

 

[shaqdeez]

Yeah I would love to know how to optimize view the meta data that's relatively static. I.e. table definitions..etc. There needs to be a caching mechanism of some sort w/ the ability to refresh on the fly. Ever since we've moved our database servers from onsite to a remote location, it's been absolutely brutal using this software.