Tuesday, February 26, 2013

Optimization for SqlDeveloper


Update file:
<sqldeveloper folder>/sqldeveloper/bin/sqldeveloper.conf

With content:
# from https://forums.oracle.com/forums/thread.jspa?messageID=9773884
AddVMOption -XX:PermSize=128M
AddVMOption -XX:MaxGCPauseMillis=50
AddVMOption -XX:GCPauseIntervalMillis=200
AddVMOption -Xms50M
AddVMOption -Xmx300M
AddVMOption -XX:MinHeapFreeRatio=10
AddVMOption -XX:MaxHeapFreeRatio=10

AddVMOption -XX:+AggressiveOpts
AddVMOption -XX:+UseStringCache
AddVMOption -XX:+OptimizeStringConcat
AddVMOption -XX:+ScavengeBeforeFullGC
AddVMOption -XX:+UseConcMarkSweepGC
AddVMOption -XX:+UseCompressedOops

# from https://blogs.oracle.com/angelo/entry/improving_the_performance_of_jdeveloper
AddVMOption -XX:+UseGCOverheadLimit

Work experience should be better.

No comments:

Post a Comment