12 responses

  1. Vladimir Sitnikov
    October 5, 2013

    I use this feature since it was hidden inside “ctrl+shift+n” shortcut. It rocks.

    Can you explain why “Unshared SQL Worksheet” button is available _only_ in the very first worksheet (it does not work in unshared ones).

    PS. “SQL Workshet (Alt+F10)” is broken since it asks connection name each time you call it. It even does not remember the last few choices.

    • thatjeffsmith
      thatjeffsmith
      October 5, 2013

      I have that logged – to be able to spawn an unshared from an unshared.

      If you want a new worksheet w/o finding the ‘original’, just right-click on the connection in the tree -> Worksheet

  2. Rajesh
    October 6, 2013

    Does this something a new in sqldeveloper 4.0? I am able to see this in 3.2.20.09 itself. please confirm.

    • thatjeffsmith
      thatjeffsmith
      October 6, 2013

      Unshared worksheets aren’t new. The ability to make a worksheet unshared by DEFAULT, however, is new.

  3. Scott
    November 21, 2013

    In connections tab, you can right click and “reconnect” to database but it does not reconnect and unshared worksheets. Is there some way to reconnect unshared worksheets short cut-n-paste whole worksheet into another worksheet?

    • thatjeffsmith
      thatjeffsmith
      November 21, 2013

      Not yet, but I’m working on getting that into version 4.NEXT, so stay tuned.

  4. BryanCheon
    March 25, 2014

    Our Systems have been set up RADIUS Authentificaiton for Security on Oracle 11.1 / 11.2 / 10.2 Version.
    On Server Terminal, Client SQL*Plus, and Others Tools using SQL*Net OCI Connection work well through RADIUS Authencation.
    But Only SQL Developer occurred ORA-1017 Error, So We do the test as following.
    Our Environment :
    DB Server : 11.1.0.7.12
    Client Version : 11.2.0.3
    SQL Developer Version : 4.0.1.14 (Java Version 1.7.0_51)
    1) Environement Setting => Database => Advanced => Check ‘use Oracle Client’ and ‘OCI/Thick Driver use” and restart and reconnect => Failed
    2) Environement Setting => Database => Worksheet => Check ‘Unshared SQL Worksheet’ and restart and reconnect => Failed
    3) Connection Windows => User Defined JDBC URL as following using thin
    jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=100.254.177.111)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME = DCOR)))
    3) Connection Windows => User Defined JDBC URL as following using oci
    jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=100.254.177.111)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME = DCOR)))

    Result of the Test :
    In Connection Windows Test Button click display success but connect display ORA-1017.
    As you mentioned,
    “■By default, connecting to a database in SQL Developer opens 2 connections
    1.Main connection
    2.Insight connection for figuring out what text is a table and what columns to show on a pick-list, etc.”

    Could you provide us the workaround for RADIUS using OTP conneciton ?

    Best Regards.

  5. Kyle
    March 31, 2015

    I’m really glad these old posts are still around. I just learned the trick of setting the preference of using an unshared connection by default. And in another old post I learned I could tear off windows and float them on my other monitor (I wish I could tear off the whole Document Group though!)

    • thatjeffsmith
      thatjeffsmith
      March 31, 2015

      The entire doc group…interesting. That’s a feature we get via Netbeans if you’re interested.

      It’s crazy how ‘fast’ time moves, it seems like just yesterday that version 4 was bleeding edge. I wrote that post in late 2013!

  6. DavidH
    April 2, 2015

    Hi,
    Thanks for this post. I’ve been a massive fan of the “unshared” connection for some time. I work in data warehousing so often my work requires me to run one query/process and while it’s running open an unshared connection and start developing on something else, swapping between the two while waiting for long running operations. today I learned that I can make this a little easier!

    When I open a saved .sql file, is there a way to change it to use an unshared connection? At the moment I have multiple names for the same connection (in the connections window) so I can achieve the same result, but it’s not ideal.

    If it makes any difference, I’m using (workplace doesn’t allow me to install/update anything myself).
    Version 4.0.1.14
    Build MAIN-14.48

  7. DavidH
    April 2, 2015

    A followup question on this.

    Why is it a bad thing for the DBA if a user is creating many connections? I couldn’t find anything immediate online.

    • thatjeffsmith
      thatjeffsmith
      April 2, 2015

      Each connection represents one or more processes on the server. If the system becomes taxed to the point that no more processes are available, a DBA might see that you have 15 tasked while you’re co-workers have 2.

      I would reply that maybe you are 7x more productive than your co-workers.

      I would also be sure to close them as soon as I’m done with them so as to not ever get on the DBA’s radar.

Leave a Reply

 

 

 

Back to top
mobile desktop