Show line numbers in SQL developer editors

solution.

Solution:

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.

Filter out all Oracle system schema from SqlDeveloper

http://www.adp-gmbh.ch/ora/misc/known_schemas.html

grep "<h2" known_schemas.html | cut -d '<' -f 2 | cut -d '>' -f 2
+ few schemas see at tail of list (link).

#!/usr/bin/env groovy

def stringList = [ "anonymous", "apex_public_user", "apex_030200", "appqossys", "bi", "ctxsys", "dbsnmp", "dip", "dmsys", "exfsys", "flows_XXXXXX", "hr", "ix", "lbacsys", "mddata", "mdsys", "mgmt_view", "odm", "odm_mtr", "oe", "olapsys", "oracle_ocm", "orddata", "ordplugins", "ordsys", "outln", "pm", "scott", "sh", "si_informtn_schema", "spatial_csw_admin_usr", "spatial_wfs_admin_usr", "sys", "sysman", "system", "tracesrv", "mtssys", "oaspublic", "olapsys", "owbsys", "owbsys_audit", "websys", "wk_proxy", "wksys", "wk_test", "wmsys", "xdb", "OSE\$HTTP\$ADMIN", "AURORA\$JIS\$UTILITY\$", "AURORA\$ORB\$UNAUTHENTICATED", "XS$NULL", "TRACESVR", "PERFSTAT" ];

stringList.each() { print """          <hash>
            <value n="ARG_CASE" v="false"/>
            <value n="ARG_NAME" v="USERNAME"/>
            <value n="ARG_PRED" v="NOT_LIKE"/>
            <list n="ARG_VALS">
               <string v="${it}"/>
            </list>
         </hash>
""" }; println "";

Result search in file:///home/USER/.sqldeveloper/system3.2.09.30/o.sqldeveloper.11.2.0.9.30/product-preferences.xml

and substitute block

SQL Developer Exchange: feature requests

SQL Developer Exchange:
 https://apex.oracle.com/pls/apex/f?p=43135:1:6863031674522

Please vote for "Allow connection to PostgreSQL", link
Please vote for "git support", link

I opened proposal "Allow search in SQL tab for Table":
https://apex.oracle.com/pls/apex/f?p=43135:7:7880665214684::NO:RP,7:P7_ID:34801 

Sql Developer installation tuning and tips

Install SQLDeveloper
1 Unzip sqldeveloper-3.X.X.XX.XX-no-jre.zip to folder ~/java/

2 Provide path to JRE

mkdir ~/.sqldeveloper/
echo "/usr/lib/jvm/java-6-sun/" > ~/.sqldeveloper/jdk
run SQLDeveloper from the shell

cd ~/java/sqldeveloper && chmod ogu+x sqldeveloper.sh && ./sqldeveloper.sh
3 Import connections to DBs.

Right click over "Connections" root node in Connections view - "Import Connections". 2 RI: Please add latest connections config here

 Connections file is here: https://wiki.reveredata.com/confluence/download/attachments/12484647/SqlDeveloper_Det2Connections.xml


Configuration of SQLDeveloper:

0) If you have problems with rendering please change Theme to "Classic 10.1.3" in  Tools/Preferences ... Environment.

1) Change auto formatting in SQL Developer - menu tools/preferences in tree "code editor/Completion Insight"
unselect "Change case as you type"

2) Tools/Preferences ...in tree Databases/NLS  property "Date Format" make as "YYYY-MM-DD" and update other date-time formats too by this.


3). install third-party Driver, for example MySQL goodlink, MSSQL goodlink2,
Download driver MySQL site.
Download MSSQL driver:  JTDS site
All drivers: list.
 Tools:Preferences menu, Database -> Third Party JDBC Driver .

TIPS:
Viewing Multiple Tables

You can have tabs open for more than one table. Just click the Freeze View button (it looks like a push pin) when you are viewing a table; and when you click to display another table, the tab for the first table will remain open.