8 Replies Latest reply on Jan 19, 2017 10:12 PM by 2658405

    Manage database in SQL developer

    nohup

      Hello,

       

       

      The temporary tablespace usage is not showing correctly in right click connection "Manage  database". If "open a worksheet on connect" and "new worksheet to use unshared connection" are both checked, clicking on the "manage database" before the connection is established does not open a new worksheet but the connection gets established and reports tablespace usage of tablespaces correctly except temporary tablespace.

       

      I am not entirely sure about the query that runs to give the usage report. Below is the query I got from another IDE because Statements in the log(View-->Log) box is not showing even if I use Basic (not TNS) connection type (I have enabled "use oracle client" and "Use OCI/Thick driver" ). I have read the http://www.thatjeffsmith.com/archive/2014/12/sql-developer-4-1-log-all-the-queries/

      and the comments in that page and Statements log does not display in SQL Developer 4.1

       

       SELECT a.tablespace_name,
                  'SQLDEV:GAUGE:0:100:0:0:'
               || NVL (ROUND ( ( (c.bytes - NVL (b.bytes, 0)) / c.bytes) * 100, 2),
                       0)
                  percent_used,
               ROUND ( ( (c.bytes - NVL (b.bytes, 0)) / c.bytes) * 100, 2) PCT_USED,
               c.bytes / 1024 / 1024 allocated,
               ROUND (c.bytes / 1024 / 1024 - NVL (b.bytes, 0) / 1024 / 1024, 2) used,
               ROUND (NVL (b.bytes, 0) / 1024 / 1024, 2) free,
               c.datafiles
          FROM dba_tablespaces a,
               (  SELECT tablespace_name, SUM (bytes) bytes
                    FROM dba_free_space
                GROUP BY tablespace_name) b,
               (  SELECT COUNT (1) datafiles, SUM (bytes) bytes, tablespace_name
                    FROM dba_data_files
                GROUP BY tablespace_name) c
         WHERE     b.tablespace_name(+) = a.tablespace_name
               AND c.tablespace_name(+) = a.tablespace_name
      ORDER BY NVL ( ( (c.bytes - NVL (b.bytes, 0)) / c.bytes), 0) DESC
      

      Many thanks for your patience and sqldeveloper and sqlcl and twitter and frequent version upgrades.

      ===================

      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

       

       

      ======================

      Version used in the Preferences--> Database--> Advanced-->"Use Oracle Client" and "TNS Directory"

      Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

      PL/SQL Release 12.1.0.2.0 - Production

      "CORE 12.1.0.2.0 Production"

      TNS for 64-bit Windows: Version 12.1.0.2.0 - Production

      NLSRTL Version 12.1.0.2.0 - Production

       

      Please let me know if anything else is required.

        • 1. Re: Manage database in SQL developer
          Gary Graham-Oracle

          Thanks for reporting the TEMP tablespace issue in Manage Database.  It is not a regression in 4.1.5 -- the behavior reproduces in 4.1.3 and 4.1.4.  As these are production releases, you would normally report this via MOS, not here, but I see that there is an entirely blank display in 4.2 EA1, so I will bug it for you.

           

          What is happening, which you can see, for example, in the Statements log in 4.1.3, is:

          1. The Manage Database SQL query does not take into account DBA_TEMP_FILES.

          2. On the other hand, if you look at View > DBA > Storage under Datafiles or Tablespaces it is handled correctly.

           

          FYI...

          1. It seems that 4.1.5 went out with the Statements log disabled.  It was re-enabled in 4.2 EA1.

          2. Open a Worksheet on connect applies only to opening a given connection explicitly.

          3. Any worksheet opened upon explicit connect will always be shared.  Additional sheets for a connection can be unshared.

          • 2. Re: Manage database in SQL developer
            nohup

             

            1. The Manage Database SQL query does not take into account DBA_TEMP_FILES.

             

            Correct.

             

            2. On the other hand, if you look at View > DBA > Storage under Datafiles or Tablespaces it is handled correctly.

             

             

            select name,bytes/1024/1024,bytes from v$tempfile
            

             

            Run the above SQL. Now check what the total_bytes column is showing. The total bytes column in the tablespace tab shows bytes/1024/1024 instead of bytes

            I cant find where you logged/bugged the bug. I am inside MOS.  Under "start typing to select a product" I have selected Oracle SQL developer. The next drop down is about the version where I chose the default "Any product version". The next drop down="Any platform". The next drop down="Update in the last two weeks"

             

            In the KM search results I have checked "Bugs""Knowledge Base", unchecked "Archive" "community""documentation""patch""system handbook",

            But I could not find it. Could you please help me in finding it?

             

            Thanks

            • 3. Re: Manage database in SQL developer
              Gary Graham-Oracle

              Not sure exactly what you mean.  No difference in numbers from what I can see, and note that comparing execute times for ...

              select * from dba_temp_files;

              select * from v$tempfile;

              ... the dba_temp_files query actually runs faster even though it hits the data dictionary instead of an internal memory structure.  In fact, the DBA > Storage > Tablespaces query uses this UNIONed fragment to get the TEMP tablespace info:

              select

                     'SQLDEV:LINK:'||USER||':TABLESPACE:'||h.tablespace_name||':oracle.dbtools.raptor.dba.navigator.Drill.DBADrillLink' as tablespace_name,

                     round(sum(h.bytes_free + h.bytes_used) / 1048576) megs_alloc,

                     round(sum((h.bytes_free + h.bytes_used) - nvl(p.bytes_used, 0)) / 1048576) megs_free,

                     round(sum(nvl(p.bytes_used, 0))/ 1048576) megs_used,

                     round((sum((h.bytes_free + h.bytes_used) - nvl(p.bytes_used, 0)) / sum(h.bytes_used + h.bytes_free)) * 100) Pct_Free,

                     100 - round((sum((h.bytes_free + h.bytes_used) - nvl(p.bytes_used, 0)) / sum(h.bytes_used + h.bytes_free)) * 100) pct_used,

                     round(sum(f.maxbytes) / 1048576) max

              from   sys.gv_$TEMP_SPACE_HEADER h, sys.gv_$Temp_extent_pool p, dba_temp_files f

              where  p.file_id(+) = h.file_id

              and    p.tablespace_name(+) = h.tablespace_name

              and    f.file_id = h.file_id

              and    f.tablespace_name = h.tablespace_name

              group by h.tablespace_name

              ORDER BY 2

              using gv_$ to take into account multiple instances.  But as I said earlier, any bugs against production versions are best reported via MOS.

               

              Cheers,

              Gary

              • 4. Re: Manage database in SQL developer
                nohup

                Please run this

                select name,bytes as bytes,bytes/1024 as KB,bytes/1024/1024 as MB,bytes/1024/1024/1024 as GB from v$tempfile
                

                Now please compare this output with the "total_bytes" column in "datafiles" sub tab of the temp tablespace tab after opening it from the Storage-->Tablespaces

                 

                you would normally report this via MOS, not here, but I see that there is an entirely blank display in 4.2 EA1, so I will bug it for you.

                where can I find it. Could you please let me know?

                • 5. Re: Manage database in SQL developer
                  Gary Graham-Oracle
                  where can I find it

                   

                  Oh, sorry...  I entered it as an internal, unpublished bug.  I just published it -- feel free to update it with your customer information:

                  Bug 24718615 - MANAGE DATABASE SHOWING NULL FOR MOST TEMP TABLESPACE ATTRIBUTES

                  Please run this...

                  OK, got it: View > DBA > open SYS connection > Storage > Tablespaces > click on Temp > Datafiles tab.

                  Several columns actually display values in megabytes but have column headings indicating the values are in bytes.

                  There is also a lack of standardization.  Some columns say "Megs", others "MB", and at least one (Temp > Free Space) actually puts an Mb after the number in the Value column.  Could you log a separate bug for that in MOS?

                  1 person found this helpful
                  • 6. Re: Manage database in SQL developer
                    nohup

                    Looks like newly lodged/logged/bugged bus dont show immediately for non Oracle folks. It is helpful that you did it. Thank you.

                    Thanks for your quick responses as always.

                     

                    Thanks

                    • 7. Re: Manage database in SQL developer
                      nohup

                       

                      2. Open a Worksheet on connect applies only to opening a given connection explicitly.

                       

                      I dont think that is entirely true. When I open SQL Developer and then click on Tools and "Monitor sessions", it asks me to choose a connection and opens the monitor sessions box as well as SQL Worksheet of that connection(both Monitor sessions and SQL worksheet share the same single connection).

                      But if I right click a connection and then open "Manage database", this does not open the worksheet. It only opens the "Manage database" box.

                      • 8. Re: Manage database in SQL developer
                        2658405

                        Hi, how do I connect to the respective database schema of my apex, and how and where do I find the my apex  database details that I need for connection.

                         

                        regards

                        aRI