Hello,
Issue 0)
When a query or F5 on a query or show parameter sqlplus command is run the Script output appears. It seems to borrow less amount of space from the worksheet area than Query results. First time after a connection is established.
- Establish a connection
- Run command
show all
- Establish another connection
- Run query using control+Enter
select * from dba_tables;
The difference is that, for the first time (and only the first time )that any command is run Script output takes less space compared to Query Results. So if the first query or command executed is a sqlplus command, or run using F5, the Script Output appears and borrows less space, compared to, if a query was executed using Control+Enter, which shows data in Query results and borrows more space from Worksheet.
But notice that among Query Results and Script Output, if Script Output was the first to borrow space from Worksheet, Query results does not borrow more space from the worksheet when subsequent commands are run using Control +Enter. One has to manually pull it up and let it use more space from the worksheet. It would have been okay if subsequent "query results" (run after the first query run used Script Output to show results)automatically borrowed more space like it did if/when the first query run after establishing a connection was shown in Query results.
Issue 1)
When a connection is established, the startup script is run from the preferences menu called "Filename for the connection startup script".
I wrote a query to get the database name in that connection startup script because I want to make sure that the connection name to which I add the database name, is indeed the database I have connected to.
But the output of this query appears in the Messages box/pane/l, and not on the Script Output of the worksheet of that connection which opens because I have "Open a Worksheet on Connect" enabled. It would have been good if the output of connection startup script appeared in the Script output or Query results when "Open a worksheet on connect" is checked instead of the Messages box/pane/l.
Issue 2)
This button which looks like the reversible reaction. It is not very evident what it does and does not have that pressing effect(like the the buttons that can be depressed and remain in the depressed state untill mouse click is completed). For example the "Run statement" button on the worksheet which gets slightly darker/deeper in colour when mouse pointer hovers over it
This is fine. But after this button is pressed and the Script Output and/or Query results get minimized, it does not come back up even after subsequent queries are run. We have to manually go to the reversible reaction up arrow and maximize the Script Output/Query results.
May I suggest getting a new minimize button just like the three buttons that appear when there are too many Worksheets/Connections open like below, which is awesome.
I have "Show query results in new tabs" checked.
Thanks
===================
About
-----
Oracle SQL Developer 4.1.5.21
Version 4.1.5.21
Build MAIN-21.78
IDE Version: 12.2.1.0.42.151001.0541
Product ID: oracle.sqldeveloper
Product Version: 12.2.0.21.78
Version
-------
Component Version
========= =======
Oracle IDE 4.1.5.21.78
Java(TM) Platform 1.8.0_102
Versioning Support 4.1.5.21.78
Properties
----------
Name Value
==== =====
file.encoding.pkg sun.io
org.osgi.framework.executionenvironment OSGi/Minimum-1.0,OSGi/Minimum-1.1,OSGi/Minimum-1.2,JRE-1.1,J2SE-1.2,J2SE-1.3,J2SE-1.4,J2SE-1.5,JavaSE-1.6,JavaSE-1.7,JavaSE-1.8
ide.firstrun true
osgi.framework file:/D:/sqldeveloper-4.1.5.21.78-no-jre/sqldeveloper/netbeans/platform/modules/ext/org.eclipse.osgi_3.9.1.v20140110-1610.jar
java.home C:\Program Files\Java\jdk1.8.0_102\jre
ide.pref.dir C:\Users\myname.here\AppData\Roaming\SQL Developer
oracle.xdkjava.compatibility.version 9.0.4
org.osgi.framework.bootdelegation *
ide.launcherProcessId 5388
ide.work.dir.base C:\Users\myname.here\Documents
copyright.year.start 2005
java.endorsed.dirs C:\Program Files\Java\jdk1.8.0_102\jre\lib\endorsed
ide.startingcwd D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\sqldeveloper\bin
osgi.bundlestore C:\Users\myname.here\AppData\Roaming\SQL Developer\system4.1.5.21.78\system_cache\var\cache\netigso\org.eclipse.osgi\bundles
sun.java2d.noddraw true
ide.product oracle.sqldeveloper
sun.os.patch.level Service Pack 1
java.vendor.url http://java.oracle.com/
java.version 1.8.0_102
ide.build MAIN-21.78
oracle.ide.launcher.startup.time 1474633215037
objectweb-asm.library D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\ide\macros/../../modules/asm-3.1.jar
oracle.jdbc.Trace true
ide.java.maxversion 1.9
osgi.os win32
osgi.compatibility.bootdelegation false
org.eclipse.equinox.simpleconfigurator.configUrl file:bundles.info
felix.log.level 4
org.osgi.framework.uuid 10184316-8881-0016-17a6-9bb7a60e8bc5
org.openide.major.version IDE/1
java.vendor.url.bug http://bugreport.sun.com/bugreport/
netbeans.buildnumber 201411261024
oracle.jrf.home D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper
ide.user.dir C:\Users\myname.here\AppData\Roaming\SQL Developer
user.name myname.here
org.osgi.framework.version 1.7.0
sun.io.unicode.encoding UnicodeLittle
org.osgi.framework.system.packages javax.accessibility,javax.activation,javax.activity,javax.annotation,javax.annotation.processing,javax.crypto,javax.crypto.interfaces,javax.crypto.spec,javax.imageio,javax.imageio.event,javax.imageio.metadata,javax.imageio.plugins.bmp,javax.imageio.plugins.jpeg,javax.imageio.spi,javax.imageio.stream,javax.jws,javax.jws.soap,javax.lang.model,javax.lang.model.element,javax.lang.model.type,javax.lang.model.util,javax.management,javax.management.loading,javax.management.modelmbean,javax.management.monitor,javax.management.openmbean,javax.management.relation,javax.management.remote,javax.management.remote.rmi,javax.management.timer,javax.naming,javax.naming.directory,javax.naming.event,javax.naming.ldap,javax.naming.spi,javax.net,javax.net.ssl,javax.print,javax.print.attribute,javax.print.attribute.standard,javax.print.event,javax.rmi,javax.rmi.CORBA,javax.rmi.ssl,javax.script,javax.security.auth,javax.security.auth.callback,javax.security.auth.kerberos,javax.security.auth.login,javax.security.auth.spi,javax.security.auth.x500,javax.security.cert,javax.security.sasl,javax.sound.midi,javax.sound.midi.spi,javax.sound.sampled,javax.sound.sampled.spi,javax.sql,javax.sql.rowset,javax.sql.rowset.serial,javax.sql.rowset.spi,javax.swing,javax.swing.border,javax.swing.colorchooser,javax.swing.event,javax.swing.filechooser,javax.swing.plaf,javax.swing.plaf.basic,javax.swing.plaf.metal,javax.swing.plaf.multi,javax.swing.plaf.nimbus,javax.swing.plaf.synth,javax.swing.table,javax.swing.text,javax.swing.text.html,javax.swing.text.html.parser,javax.swing.text.rtf,javax.swing.tree,javax.swing.undo,javax.tools,javax.transaction,javax.transaction.xa,javax.xml,javax.xml.bind,javax.xml.bind.annotation,javax.xml.bind.annotation.adapters,javax.xml.bind.attachment,javax.xml.bind.helpers,javax.xml.bind.util,javax.xml.crypto,javax.xml.crypto.dom,javax.xml.crypto.dsig,javax.xml.crypto.dsig.dom,javax.xml.crypto.dsig.keyinfo,javax.xml.crypto.dsig.spec,javax.xml.datatype,javax.xml.namespace,javax.xml.parsers,javax.xml.soap,javax.xml.stream,javax.xml.stream.events,javax.xml.stream.util,javax.xml.transform,javax.xml.transform.dom,javax.xml.transform.sax,javax.xml.transform.stax,javax.xml.transform.stream,javax.xml.validation,javax.xml.ws,javax.xml.ws.handler,javax.xml.ws.handler.soap,javax.xml.ws.http,javax.xml.ws.soap,javax.xml.ws.spi,javax.xml.ws.spi.http,javax.xml.ws.wsaddressing,javax.xml.xpath,org.ietf.jgss,org.omg.CORBA,org.omg.CORBA_2_3,org.omg.CORBA_2_3.portable,org.omg.CORBA.DynAnyPackage,org.omg.CORBA.ORBPackage,org.omg.CORBA.portable,org.omg.CORBA.TypeCodePackage,org.omg.CosNaming,org.omg.CosNaming.NamingContextExtPackage,org.omg.CosNaming.NamingContextPackage,org.omg.Dynamic,org.omg.DynamicAny,org.omg.DynamicAny.DynAnyFactoryPackage,org.omg.DynamicAny.DynAnyPackage,org.omg.IOP,org.omg.IOP.CodecFactoryPackage,org.omg.IOP.CodecPackage,org.omg.Messaging,org.omg.PortableInterceptor,org.omg.PortableInterceptor.ORBInitInfoPackage,org.omg.PortableServer,org.omg.PortableServer.CurrentPackage,org.omg.PortableServer.POAManagerPackage,org.omg.PortableServer.POAPackage,org.omg.PortableServer.portable,org.omg.PortableServer.ServantLocatorPackage,org.omg.SendingContext,org.omg.stub.java.rmi,org.w3c.dom,org.w3c.dom.bootstrap,org.w3c.dom.css,org.w3c.dom.events,org.w3c.dom.html,org.w3c.dom.ls,org.w3c.dom.ranges,org.w3c.dom.stylesheets,org.w3c.dom.traversal,org.w3c.dom.views,org.w3c.dom.xpath,org.xml.sax,org.xml.sax.ext,org.xml.sax.helpers
ide.bundle.search.path D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\dropins
sun.jnu.encoding Cp1252
java.runtime.name Java(TM) SE Runtime Environment
ide.work.dir C:\Users\myname.here\Documents\SQL Developer
oracle.ide.osgi.boot.api.OJStartupHook oracle.dbtools.raptor.startup.HomeSupport
ide.conf D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf
jdk.home C:\Program Files\Java\jdk1.8.0_102\jre\..
private.jdev.load.remote.schemas false
org.netbeans.CLIHandler.server false
osgi.instance.area.default file:/C:/Users/myname.here/AppData/Roaming/SQL Developer/system4.1.5.21.78/system_cache/
ide.bootstrap.start 5645153748843
netbeans.dirs D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\fcpbridge;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\ide;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\dropins
java.specification.name Java Platform API Specification
sun.awt.datatransfer.timeout 1000
org.osgi.supports.framework.fragment true
osgi.framework.useSystemProperties true
oracle.translated.locales de,es,fr,it,ja,ko,pt_BR,zh_CN,zh_TW
user.timezone
nb.native.filechooser false
org.osgi.framework.system.capabilities osgi.ee; osgi.ee="OSGi/Minimum"; version:List<Version>="1.0, 1.1, 1.2",osgi.ee; osgi.ee="JRE"; version:List<Version>="1.0, 1.1",osgi.ee; osgi.ee="JavaSE"; version:List<Version>="1.0, 1.1, 1.2, 1.3, 1.4, 1.5, 1.6, 1.7, 1.8"
osgi.nl en_IN
osgi.contextClassLoaderParent app
org.openide.specification.version 6.2
user.script
path.separator ;
java.naming.factory.initial oracle.javatools.jndi.LocalInitialContextFactory
osgi.framework.activeThreadType normal
file.encoding Cp1252
osgi.arch x86_64
ice.browser.forcegc false
sun.java.command oracle.ide.osgi.boot.OracleIdeLauncher
https.nonProxyHosts IN1-mycompnamehere
oracle.ide.IdeFrameworkCommandLineOptions -clean,-console,-debugmode,-migrate,-migrate:,-nomigrate,-nonag,-nondebugmode,-noreopen,-nosplash,-role:,-su
tool.user.conf C:\Users\myname.here\AppData\Roaming\sqldeveloper\4.1.5\sqldeveloper.conf
org.osgi.supports.framework.requirebundle true
oracle.jdbc.mapDateToTimestamp false
osgi.classloader.type parallel
osgi.bundles.defaultStartLevel 1
java.io.tmpdir C:\Users\mynamehere~1.JAS\AppData\Local\Temp\
org.osgi.framework.os.name Windows7
ice.pilots.html4.tileOptThreshold 0
user.language en
javax.xml.stream.XMLInputFactory com.ctc.wstx.stax.WstxInputFactory
line.separator \r\n
copyright.year.end 2016
sqldev.debug false
ice.pilots.html4.ignoreNonGenericFonts true
eclipse.parsers.setTCCL false
org.osgi.framework.processor x86-64
oracle.ide.extension.HooksProcessingMode LAZY
java.vm.info mixed mode
osgi.manifest.cache C:\Users\myname.here\AppData\Roaming\SQL Developer\system4.1.5.21.78\system_cache\var\cache\netigso\org.eclipse.osgi\manifests
sun.desktop windows
java.vm.specification.name Java Virtual Machine Specification
javax.xml.stream.util.XMLEventAllocator oracle.ideimpl.xml.stream.XMLEventAllocatorImpl
netbeans.dynamic.classpath D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\core\asm-all-5.0.1.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\core\core.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\core\org-netbeans-libs-asm.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\core\org-openide-filesystems.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\core\locale\core_de.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\core\locale\core_es.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\core\locale\core_fr.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\core\locale\core_it.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\core\locale\core_ja.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\core\locale\core_ko.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\core\locale\core_pt_BR.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\core\locale\core_zh_CN.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\core\locale\core_zh_TW.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\core\locale\org-openide-filesystems_de.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\core\locale\org-openide-filesystems_es.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\core\locale\org-openide-filesystems_fr.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\core\locale\org-openide-filesystems_it.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\core\locale\org-openide-filesystems_ja.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\core\locale\org-openide-filesystems_ko.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\core\locale\org-openide-filesystems_pt_BR.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\core\locale\org-openide-filesystems_zh_CN.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\core\locale\org-openide-filesystems_zh_TW.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\fcpbridge\core\org-netbeans-core-dynamicconfig.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\fcpbridge\core\locale\core_jdev.jar
jdbc.library D:\app\myname.here\product\12.1.0\dbhome_1\jdbc\lib\ojdbc7.jar
http.nonProxyHosts IN1-mycompnamehere
excluded.modules org.eclipse.osgi
ide.boot.class.path D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\ide\macros/../../ide/lib/javax-ide.jar,file:../../ide/lib/javatools.jar,file:../../modules/oracle.javatools/javatools-nodeps.jar,file:../../modules/oracle.javatools/javatools-jndi-local.jar,file:../../ide/extensions/oracle.ide.jar,file:../../ide/lib/idert.jar,file:../../modules/oracle.javatools/oicons.jar,file:../../ide/lib/uic.jar,file:../../ide/lib/audit-boot.jar,file:../../ide/lib/indexing-migrator-boot.jar,file:../../jlib/jewt4.jar,file:../../modules/oracle.bali.share/share.jar,file:../../jlib/help4.jar,file:../../jlib/inspect4.jar,file:../../modules/oracle.xdk/xmlparserv2.jar
osgi.configuration.area file:/C:/Users/myname.here/AppData/Roaming/SQL Developer/system4.1.5.21.78/system_cache/var/cache/netigso/
sun.java2d.ddoffscreen false
java.awt.printerjob sun.awt.windows.WPrinterJob
ide.cluster.dirs /sqldeveloper-4.1.5.21.78-no-jre/sqldeveloper/netbeans/fcpbridge/:/sqldeveloper-4.1.5.21.78-no-jre/sqldeveloper/netbeans/ide/:/sqldeveloper-4.1.5.21.78-no-jre/sqldeveloper/netbeans/../
ilog.propagatesPropertyEditors false
oracle.jdbc.useFetchSizeWithLongColumn true
netbeans.home D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform
org.osgi.framework.storage file:/C:/Users/myname.here/AppData/Roaming/SQL Developer/system4.1.5.21.78/system_cache/var/cache/netigso
ide.shell.enableFileTypeAssociation D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\sqldeveloper\bin\sqldeveloper64W.exe
osgi.ws win32
javax.xml.transform.TransformerFactory oracle.ide.xml.switchable.SwitchableTransformerFactory
org.osgi.supports.framework.extension true
oracle.jdbc.autoCommitSpecCompliant false
gosh.args --nointeractive
osgi.parentClassloader app
org.osgi.framework.language en
os.name Windows 7
eclipse.home.location file:/D:/sqldeveloper-4.1.5.21.78-no-jre/sqldeveloper/
java.specification.vendor Oracle Corporation
java.vm.name Java HotSpot(TM) 64-Bit Server VM
org.openide.version deprecated
ide.AssertTracingDisabled true
sun.awt.enableExtraMouseButtons true
java.library.path D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\sqldeveloper\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\ProgramData\Oracle\Java\javapath;C:\Perl64\site\bin;C:\Perl64\bin;D:\app\myname.here\product\12.1.0\dbhome_1\bin;D:\app\myname.here\product\11.2.0\client_1\bin;C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files (x86)\Intel\OpenCL SDK\3.0\bin\x86;C:\Program Files (x86)\Intel\OpenCL SDK\3.0\bin\x64;C:\Program Files\TortoiseSVN\bin;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\WinMerge;C:\Program Files (x86)\Brackets\command;C:\Users\myname.here\AppData\Local\Programs\Python\Python35-32\Scripts\;C:\Users\myname.here\AppData\Local\Programs\Python\Python35-32\;C:\Users\myname.here\AppData\Local\atom\bin;.
ide.cfu.class.path D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\ide\macros/../../modules/oracle.bali.share/share.jar,file:../../jlib/jewt4.jar,file:../../modules/oracle.xdk/xmlparserv2.jar,file:../../ide/lib/javatools.jar,file:../../modules/oracle.javatools/javatools-nodeps.jar,file:../../ide/lib/idert.jar,file:../../ide/extensions/oracle.ide.jar,file:../../ide/extensions/oracle.ide.webupdate.jar
jna.boot.library.name jnidispatch-410
java.class.version 52.0
user.conf C:\Users\myname.here\AppData\Roaming\sqldeveloper\4.1.5\product.conf
ide.extension.search.path sqldeveloper/extensions:jdev/extensions:ide/extensions
ide.config_pathname D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf
oracle.ide.reportEDTViolations.exceptionsfile /sqldeveloper-4.1.5.21.78-no-jre/sqldeveloper/ide/bin/swing-thread-violations.conf
ide.system.dir C:\Users\myname.here\AppData\Roaming\SQL Developer\system4.1.5.21.78\
java.util.logging.config.file logging.conf
osgi.instance.area file:/C:/Users/myname.here/AppData/Roaming/SQL Developer/system4.1.5.21.78/system_cache/
osgi.install.area file:/D:/sqldeveloper-4.1.5.21.78-no-jre/sqldeveloper/
sun.boot.library.path C:\Program Files\Java\jdk1.8.0_102\jre\bin
svnkit.sax.useDefault true
sun.management.compiler HotSpot 64-Bit Tiered Compilers
netbeans.logger.console true
java.awt.graphicsenv sun.awt.Win32GraphicsEnvironment
user.variant
ide.pref.dir.base C:\Users\myname.here\AppData\Roaming
ide.splash.screen splash.gif
ide.update.usage.servers http://www.oracle.com/webfolder/technetwork/sqldeveloper/usage.xml
osgi.user.area file:/C:/Users/myname.here/AppData/Roaming/SQL Developer/system4.1.5.21.78/system_cache/
ide.debugbuild false
java.vm.specification.version 1.8
sun.locale.formatasdefault true
osgi.noShutdown true
orai18n.library.dir D:\app\myname.here\product\12.1.0\dbhome_1\jlib
awt.toolkit sun.awt.windows.WToolkit
xdb.library D:\app\myname.here\product\12.1.0\dbhome_1\rdbms\jlib\xdb6.jar
sun.cpu.isalist amd64
ide.java.minversion 1.8
java.ext.dirs C:\Program Files\Java\jdk1.8.0_102\jre\lib\ext;C:\Windows\Sun\Java\lib\ext
os.version 6.1
osgi.framework.version 3.9.1.v20140110-1610
http.agent SQL Developer/4.1.5 (Windows 7 6.1; amd64; Java 1.8.0_102; NA; c3b9baf3-0151-1000-8001-0a32016a3694; ) 4.1.5.21.78
user.home C:\Users\myname.here
org.xml.sax.driver oracle.xml.parser.v2.SAXParser
ide.mw.relative.home .
java.vm.vendor Oracle Corporation
javax.xml.parsers.DocumentBuilderFactory oracle.xml.jaxp.JXDocumentBuilderFactory
ide.user.dir.var IDE_USER_DIR
osgi.hook.configurators.include org.netbeans.modules.netbinox.NetbinoxHooks
ide.startingArg0 D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\sqldeveloper\bin\sqldeveloper64W.exe
user.dir D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\sqldeveloper\bin
org.osgi.framework.os.version 6.1.0
ide.RectangularSplashScreen true
osgi.user.area.default file:/C:/Users/myname.here/AppData/Roaming/SQL Developer/system4.1.5.21.78/system_cache/
sun.cpu.endian little
reserved_filenames con,aux,prn,lpt1,lpt2,lpt3,lpt4,lpt5,lpt6,lpt7,lpt8,lpt9,com1,com2,com3,com4,com5,com6,com7,com8,com9,conin$,conout,conout$
osgi.support.multipleHosts true
ORACLE_HOME D:\sqldeveloper-4.1.5.21.78-no-jre
java.vm.version 25.102-b14
oracle.home D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper
java.class.path D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\ide\lib\ide-boot.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\lib\boot.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\lib\org-openide-util-ui.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\lib\org-openide-util.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\lib\org-openide-util-lookup.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\netbeans\platform\lib\org-openide-modules.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\ide\lib\fcpboot.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\ide\lib\xml-factory.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\ide\lib\woodstox-core-asl-4.2.0.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\ide\lib\stax2-api-3.1.1.jar;D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\sqldeveloper\lib\oracle.sqldeveloper.homesupport.jar
oracle.fcp.home D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper
os.arch amd64
oracle.ide.reportEDTViolations bug
ide.devbuild false
netbeans.user C:\Users\myname.here\AppData\Roaming\SQL Developer\system4.1.5.21.78\system_cache
windows.shell.font.languages
org.osgi.framework.vendor Eclipse
ide.diagnostics.dir C:\Users\myname.here\AppData\Roaming\SQL Developer\system4.1.5.21.78\.diagnostics\
nb.core.windows.no.lazy.loading true
java.vm.specification.vendor Oracle Corporation
file.separator \
java.runtime.version 1.8.0_102-b14
sun.boot.class.path /sqldeveloper-4.1.5.21.78-no-jre/sqldeveloper/rdbms/jlib/ojdi.jar;C:\Program Files\Java\jdk1.8.0_102\jre\lib\resources.jar;C:\Program Files\Java\jdk1.8.0_102\jre\lib\rt.jar;C:\Program Files\Java\jdk1.8.0_102\jre\lib\sunrsasign.jar;C:\Program Files\Java\jdk1.8.0_102\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.8.0_102\jre\lib\jce.jar;C:\Program Files\Java\jdk1.8.0_102\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.8.0_102\jre\lib\jfr.jar;C:\Program Files\Java\jdk1.8.0_102\jre\classes;C:\Program Files\Java\jdk1.8.0_102\lib\tools.jar;C:\Program Files\Java\jdk1.8.0_102\lib\dt.jar
user.country IN
osgi.configuration.cascaded false
oracle.ide.startup.features sqldeveloper
osgi.logfile C:\Users\myname.here\AppData\Roaming\SQL Developer\system4.1.5.21.78\system_cache\var\cache\netigso\1474633216985.log
sqldeveloper.oci.available true
jdeveloper.system_http_proxy DIRECT
osgi.framework.properties C:\Users\myname.here\AppData\Roaming\SQL Developer\system4.1.5.21.78\system_cache
xmlparser.library D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper\ide\macros/../../modules/oracle.xdk/xmlparserv2.jar
java.vendor Oracle Corporation
oracle.ide.util.AddinPolicyUtils.OVERRIDE_FLAG true
sqldev.onsd true
osgi.bundlefile.limit 500
ide.feedback-server ide.us.oracle.com
oracle.ide.classload.layer osgi
osgi.locking none
java.specification.version 1.8
oracle.product.home D:\sqldeveloper-4.1.5.21.78-no-jre\sqldeveloper
sun.arch.data.model 64
java.memory.heap.init 134217728
java.memory.heap.max 746061824
java.memory.heap.used 133345144
java.memory.nonheap.init 2555904
java.memory.nonheap.max -1
java.memory.nonheap.used 201587256
Extensions
----------
Name Identifier Version Status Registration Time Initialization Time Total Time
==== ========== ======= ====== ================= =================== ==========
Integrated Development Environment (IDE) Platform Core oracle.ide 12.2.1.0.42.151001.0541 Fully Loaded 98ms 164ms 262ms
Peek oracle.ideimpl.peek 12.2.1.0.42.151001.0541 Fully Loaded 7ms 5ms 12ms
Code Editor oracle.ide.ceditor 12.2.1.0.42.151001.0541 Fully Loaded 15ms 109ms 124ms
Persistent Storage oracle.ide.persistence 12.2.1.0.42.151001.0541 Fully Loaded 0ms 4ms 4ms
File Change Monitor oracle.ide.file 12.2.1.0.42.151001.0541 Fully Loaded 0ms 5ms 5ms
Web Browser and Proxy oracle.ide.webbrowser 12.2.1.0.42.151001.0541 Fully Loaded 1ms 23ms 24ms
Indexing Service oracle.ide.indexing 12.2.1.0.42.151001.0541 Fully Loaded 0ms 2ms 2ms
Property Inspector oracle.ide.inspector 12.2.1.0.42.151001.0541 Fully Loaded 8ms 14ms 22ms
Markers oracle.ide.markers 12.2.1.0.42.151001.0541 Fully Loaded 0ms 0ms 0ms
Audit Core Framework oracle.ide.audit 12.2.1.0.42.151001.0541 Fully Loaded 1ms 8ms 9ms
Status and Background Audit oracle.ide.status 12.2.1.0.42.151001.0541 Fully Loaded 2ms 1ms 3ms
IDE macros oracle.ide.macros 12.2.1.0.42.151001.0541 Fully Loaded 0ms 0ms 0ms
Libraries oracle.ide.library 12.2.1.0.42.151001.0541 Fully Loaded 29ms 11ms 40ms
Virtual File System oracle.ide.vfs 12.2.1.0.42.151001.0541 Fully Loaded 1ms 1ms 2ms
Navigator oracle.ide.navigator 12.2.1.0.42.151001.0541 Fully Loaded 1ms 6ms 7ms
Runner oracle.ide.runner 12.2.1.0.42.151001.0541 Fully Loaded 4ms 6ms 10ms
External Tools oracle.ide.externaltools 12.2.1.0.42.151001.0541 Fully Loaded 10ms 2ms 12ms
File Support oracle.ide.files 12.2.1.0.42.151001.0541 Fully Loaded 1ms 0ms 1ms
Palette 2 oracle.ide.palette2 12.2.1.0.42.151001.0541 Fully Loaded 4ms 0ms 4ms
Object Gallery oracle.ide.gallery 12.2.1.0.42.151001.0541 Fully Loaded 8ms 4ms 12ms
Import/Export Support oracle.ide.importexport 12.2.1.0.42.151001.0541 Fully Loaded 2ms 0ms 2ms
Technology oracle.jdeveloper.technology 12.2.1.0.42.151001.0541 Fully Loaded 4ms 1ms 5ms
Extended IDE Platform oracle.jdeveloper.common 12.2.1.0.42.151001.0541 Fully Loaded 9ms 17ms 26ms
JavaCore oracle.jdeveloper.java.core 12.2.1.0.42.151001.0541 Fully Loaded 7ms 15ms 22ms
Insight oracle.ide.insight 12.2.1.0.42.151001.0541 Fully Loaded 4ms 2ms 6ms
Database UI oracle.ide.db 12.2.1.0.42.151001.0541 Fully Loaded 17ms 51ms 68ms
Database Connections oracle.jdeveloper.db.connection 12.2.1.0.42.151001.0541 Fully Loaded 4ms 21ms 25ms
Database Object Explorers oracle.ide.db.explorer 12.2.1.0.42.151001.0541 Fully Loaded 0ms 11ms 11ms
JDBC Proxy oracle.sqldeveloper.jdbcproxy 12.2.0.21.78 Fully Loaded 0ms 2ms 2ms
Code Editor Find oracle.ide.ceditor-find 12.2.1.0.42.151001.0541 Fully Loaded 2ms 0ms 2ms
Oracle SQL Developer Utilities oracle.sqldeveloper.utils 12.2.0.21.78 Fully Loaded 0ms 0ms 0ms
Compare API oracle.ide.compareapi 12.2.1.0.42.151001.0541 Fully Loaded 2ms 0ms 2ms
Help System oracle.ide.help 12.2.1.0.42.151001.0541 Fully Loaded 8ms 4ms 12ms
Code Editor Save Actions oracle.ide.ceditor-saveactions 12.2.1.0.42.151001.0541 Fully Loaded 2ms 5ms 7ms
Oracle Deployment Core Module oracle.deploy.core 12.2.1.0.42.151001.0541 Fully Loaded 2ms 13ms 15ms
Make and Rebuild oracle.jdeveloper.build 12.2.1.0.42.151001.0541 Fully Loaded 24ms 6ms 30ms
JDeveloper Runner Core oracle.jdeveloper.runner.core 12.2.1.0.42.151001.0541 Fully Loaded 0ms 19ms 19ms
JDeveloper Runner oracle.jdeveloper.runner 12.2.1.0.42.151001.0541 Fully Loaded 7ms 224ms 231ms
PL/SQL Probe Debugger oracle.jdeveloper.db.debug.probe 12.2.1.0.42.151001.0541 Fully Loaded 0ms 0ms 0ms
JDeveloper Runner JDI oracle.jdeveloper.jdev-runner-jdi 12.2.1.0.42.151001.0541 Fully Loaded 0ms 0ms 0ms
Local History oracle.ide.localhistory 12.2.1.0.42.151001.0541 Fully Loaded 0ms 136ms 136ms
History Support oracle.jdeveloper.history 12.2.1.0.42.151001.0541 Fully Loaded 8ms 19ms 27ms
Check For Updates oracle.ide.webupdate 12.2.1.0.42.151001.0541 Fully Loaded 2ms 2ms 4ms
Core Database Development oracle.sqldeveloper 12.2.0.21.78 Fully Loaded 30ms 710ms 740ms
SQL Worksheet oracle.sqldeveloper.worksheet 12.2.0.21.78 Fully Loaded 7ms 51ms 58ms
Database Reports oracle.sqldeveloper.report 12.2.0.21.78 Fully Loaded 3ms 10ms 13ms
Bookmarks oracle.ide.bookmarks 12.2.1.0.42.151001.0541 Fully Loaded 5ms 4ms 9ms
Oracle SQL Developer - SSH Support oracle.sqldeveloper.ssh 12.2.0.21.78 Fully Loaded 3ms 1ms 4ms
Oracle SQL Developer - Extras oracle.sqldeveloper.extras 12.2.0.21.78 Fully Loaded 4ms 76ms 80ms
Oracle SQL Developer - Unit Test oracle.sqldeveloper.unit_test 12.2.0.21.78 Triggers Loaded 4ms 0ms 4ms
Versioning Support oracle.ide.vcscore 12.2.1.0.42.151001.0541 Fully Loaded 2ms 1ms 3ms
Patch Support oracle.jdeveloper.patch 12.2.1.0.42.151001.0541 Fully Loaded 4ms 0ms 4ms
Replace With oracle.ide.replace 12.2.1.0.42.151001.0541 Fully Loaded 1ms 1ms 2ms
IDE Thumbnail oracle.ide.thumbnail 12.2.1.0.42.151001.0541 Fully Loaded 1ms 3ms 4ms
VHV oracle.ide.vhv 12.2.1.0.42.151001.0541 Fully Loaded 0ms 9ms 9ms
QuickDiff oracle.ide.quickdiff 12.2.1.0.42.151001.0541 Fully Loaded 0ms 1ms 1ms
Versioning Support oracle.jdeveloper.vcs 12.2.1.0.42.151001.0541 Fully Loaded 3ms 37ms 40ms
BM Share oracle.bm.jdukshare 12.2.1.0.42.151001.0541 Fully Loaded 0ms 0ms 0ms
MOF XMI oracle.mof.xmi 12.2.1.0.42.151001.0541 Fully Loaded 0ms 0ms 0ms
Code Editor Macro oracle.ide.ceditor-macro 12.2.1.0.42.151001.0541 Fully Loaded 1ms 0ms 1ms
Database XML Schema oracle.sqldeveloper.xmlschema 12.2.0.21.78 Fully Loaded 0ms 2ms 2ms
Oracle SQL Developer - Migrations T-SQL Translator oracle.sqldeveloper.migration.translation.core 12.2.0.21.78 Fully Loaded 0ms 0ms 0ms
Oracle SQL Developer - Migrations MySQL SQL Translator oracle.sqldeveloper.migration.translation.mysql_translator 12.2.0.21.78 Triggers Loaded 0ms 0ms 0ms
Oracle SQL Developer - File Navigator oracle.sqldeveloper.filenavigator 12.2.0.21.78 Fully Loaded 5ms 3ms 8ms
Versioning Support for Subversion oracle.jdeveloper.subversion 12.2.1.0.42.151001.0541 Fully Loaded 6ms 234ms 240ms
Oracle SQL Developer - Cloud Support oracle.sqldeveloper.cloud 12.2.0.21.78 Fully Loaded 0ms 0ms 0ms
Oracle SQL Developer Data Modeler oracle.datamodeler 4.1.5.907 Triggers Loaded 26ms 0ms 26ms
Third Party Database Development oracle.sqldeveloper.thirdparty.browsers 12.2.0.21.78 Fully Loaded 0ms 16ms 16ms
Oracle SQL Developer - Migrations Core oracle.sqldeveloper.migration 12.2.0.21.78 Fully Loaded 5ms 114ms 119ms
Oracle SQL Developer - Migrations Teradata oracle.sqldeveloper.migration.teradata 12.2.0.21.78 Triggers Loaded 1ms 0ms 1ms
Searchbar oracle.ide.searchbar 12.2.1.0.42.151001.0541 Fully Loaded 2ms 0ms 2ms
Oracle SQL Developer Data Modeler - Reports oracle.sqldeveloper.datamodeler_reports 12.2.0.21.78 Fully Loaded 0ms 0ms 0ms
JViews Registration Addin oracle.diagram.registration 12.2.1.0.42.151001.0541 Fully Loaded 0ms 30ms 30ms
Oracle SQL Developer - Migrations Translation UI oracle.sqldeveloper.migration.translation.gui 12.2.0.21.78 Fully Loaded 2ms 54ms 56ms
Oracle SQL Developer - Security oracle.sqldeveloper.security 12.2.0.21.78 Fully Loaded 0ms 0ms 0ms
Oracle SQL Developer - Migrations Microsoft SQL Server oracle.sqldeveloper.migration.sqlserver 12.2.0.21.78 Triggers Loaded 0ms 0ms 0ms
Oracle SQL Developer - Migrations Microsoft Access oracle.sqldeveloper.migration.msaccess 12.2.0.21.78 Triggers Loaded 0ms 0ms 0ms
Database Snippets oracle.sqldeveloper.snippet 12.2.0.21.78 Fully Loaded 0ms 7ms 7ms
Diagram Framework oracle.diagram 12.2.1.0.42.151001.0541 Fully Loaded 1ms 14ms 15ms
OLAP oracle.olap 12.2.0.21.78 Fully Loaded 12ms 817ms 829ms
Protocol Handler Classpath oracle.jdeveloper.classpath 12.2.1.0.42.151001.0541 Fully Loaded 1ms 0ms 1ms
Dependency Tracking oracle.ide.dependency 12.2.1.0.42.151001.0541 Fully Loaded 0ms 0ms 0ms
Code Style oracle.jdeveloper.style 12.2.1.0.42.151001.0541 Fully Loaded 2ms 9ms 11ms
Code Editor Tint oracle.ide.ceditor-tint 12.2.1.0.42.151001.0541 Fully Loaded 2ms 0ms 2ms
ToDo Tasks Markers oracle.jdeveloper.markers.todo 12.2.1.0.42.151001.0541 Fully Loaded 2ms 0ms 2ms
XML Editing Framework oracle.ide.xmlef 12.2.1.0.42.151001.0541 Fully Loaded 11ms 48ms 59ms
Oracle SQL Developer - DBA Navigator oracle.sqldeveloper.dbanavigator 12.2.0.21.78 Fully Loaded 5ms 280ms 285ms
Oracle SQL Developer - Scheduler oracle.sqldeveloper.scheduler 12.2.0.21.78 Fully Loaded 0ms 232ms 232ms
Oracle SQL Developer - Migrations PostgreSQL oracle.sqldeveloper.migration.postgresql 12.2.0.21.78 Triggers Loaded 0ms 0ms 0ms
OLAPDV oracle.olapdv 12.2.0.21.78 Triggers Loaded 0ms 0ms 0ms
Oracle SQL Developer - Migrations Sybase Adaptive Server oracle.sqldeveloper.migration.sybase 12.2.0.21.78 Triggers Loaded 0ms 0ms 0ms
Versioning Support for Git oracle.jdeveloper.git 12.2.1.0.42.151001.0541 Triggers Loaded 6ms 0ms 6ms
TimesTen Integration oracle.ide.db.timesten 12.2.1.0.42.151001.0541 Fully Loaded 0ms 0ms 0ms
Oracle SQL Developer - TimesTen oracle.sqldeveloper.timesten 12.2.0.21.78 Fully Loaded 1ms 104ms 105ms
Oracle SQL Developer - Migrations MySQL oracle.sqldeveloper.migration.mysql 12.2.0.21.78 Triggers Loaded 0ms 0ms 0ms
Oracle SQL Developer - Migrations DB2 oracle.sqldeveloper.migration.db2 12.2.0.21.78 Triggers Loaded 0ms 0ms 0ms
Print System oracle.ide.print 12.2.1.0.42.151001.0541 Triggers Loaded 1ms 0ms 1ms
Oracle SQL Developer - Spatial oracle.sqldeveloper.spatial 12.2.0.21.78 Fully Loaded 3ms 6ms 9ms
Oracle SQL Developer - RESTful Services Administration oracle.sqldeveloper.rest 12.2.0.21.78 Fully Loaded 4ms 8ms 12ms
Help Oracle Start Page oracle.ide.helpstartpage 12.2.1.0.42.151001.0541 Fully Loaded 3ms 0ms 3ms
Code Editor Bookmarks oracle.ide.ceditor-bookmarks 12.2.1.0.42.151001.0541 Fully Loaded 0ms 7ms 7ms
Oracle SQL Developer - Migrations Teradata SQL Translator oracle.sqldeveloper.migration.translation.teradata 12.2.0.21.78 Triggers Loaded 0ms 0ms 0ms
Mac OS X Adapter oracle.ideimpl.apple 12.2.1.0.42.151001.0541 Fully Loaded 0ms 0ms 0ms
Oracle SQL Developer - Migrations DB2 Translator oracle.sqldeveloper.migration.translation.db2 12.2.0.21.78 Triggers Loaded 0ms 0ms 0ms
Usage Tracking oracle.ide.usages-tracking 12.2.1.0.42.151001.0541 Fully Loaded 0ms 1ms 1ms
Oracle SQL Developer - Real Time SQL Monitoring oracle.sqldeveloper.sqlmonitor 12.2.0.21.78 Triggers Loaded 2ms 0ms 2ms
Oracle SQL Developer - APEX Listener Administration oracle.sqldeveloper.listener 12.2.0.21.78 Triggers Loaded 4ms 0ms 4ms
(Name Unavailable) oracle.sqldeveloper.tuning 12.2.0.21.78 Fully Loaded 2ms 1ms 3ms
Log Window oracle.ide.log 12.2.1.0.42.151001.0541 Fully Loaded 1ms 0ms 1ms
Oracle SQL Developer - Change Mangement oracle.sqldeveloper.em_cm 12.2.0.21.78 Triggers Loaded 2ms 0ms 2ms
Database UI Extras oracle.jdeveloper.db.extras 12.2.1.0.42.151001.0541 Triggers Loaded 0ms 0ms 0ms
Oracle SQL Developer - Schema Browser oracle.sqldeveloper.schemabrowser 12.2.0.21.78 Triggers Loaded 2ms 0ms 2ms
Component Palette oracle.ide.palette1 12.2.1.0.42.151001.0541 Fully Loaded 7ms 0ms 7ms
Oracle SQL Developer - Database Cart oracle.sqldeveloper.dbcart 12.2.0.21.78 Triggers Loaded 1ms 0ms 1ms
Oracle SQL Developer - Migrations Application Migration oracle.sqldeveloper.migration.application 12.2.0.21.78 Triggers Loaded 2ms 0ms 2ms
Data Miner oracle.dmt.dataminer 12.2.0.21.78 Fully Loaded 9ms 243ms 252ms