SQL-Developer: Activate logging

In case you want to activate logging in SQL-Developer – here is how:

  1. Close all open SQL-Developer instances.
  2. Find the “sqldeveloper.conf” file
    1. Windows:
      1. goto the directory where the SQL-Developer program is installed.
      2. goto the subdirectory “sqldeveloper\bin”
    2. Mac OS X:
      1. goto your applications folder (“/Applications”)
      2. open the SQLDeveloper-App via context menu (“right mouse click”)
      3. goto the subdirectory “Contents/Resources/sqldeveloper/sqldeveloper/bin”
  3. Open the file “sqldeveloper.conf” with the text editor of your choise.
  4. Deactivate the following line by adding a “#” at the beginning:
    #IncludeConfFile sqldeveloper-nondebug.conf
  5. Add a new line with the following text to the file:
    IncludeConfFile sqldeveloper-debug.conf
    AddVMOption -Dcom.methodr.loglevel=all

  6. Save the file.

SQL-Developer: How to prevent the “Java Heap Space” error

When you are working with a lot of worksheets and reports or try to open large SQL files, you may run into “Java Heap Space” errors.

To fix this problem you need to increase the Xmx (maximum heap size).

Here is how:

  1. Close all open SQL-Developer instances.
  2. Find the “sqldeveloper.conf” file
    1. Windows:
      1. goto the directory where the SQL-Developer program is installed.
      2. goto the subdirectory “sqldeveloper\bin”
    2. Mac OS X:
      1. goto your applications folder (“/Applications”)
      2. open the SQLDeveloper-App via context menu (“right mouse click”)
      3. goto the subdirectory “Contents/Resources/sqldeveloper/sqldeveloper/bin”
  3. Open the file “sqldeveloper.conf” with the text editor of your choise.
  4. Add a new line with the following text to the file:
    AddVMOption -Xmx1024M
  5. Save the file.

Scripts for my DOAG 2014 presentation “1000 mal schneller – Praxisgeschichten aus der Oracle-Datenbankwelt”

Thank you very much for attending my presentation “1000 mal schneller – Praxisgeschichten aus der Oracle-Datenbankwelt”!
(English: “1000 times faster – Real life stories from the world of Oracle Databases”)

You can download the scripts i used to simulate the shown cases here:

I will speak at the “DOAG 2014 Conference + Exhibition” (“DOAG 2014 Konferenz + Ausstellung”)

I will be on the “DOAG 2014 Conference + Exhibition” in Nürnberg (Nuremberg), Germany from November 18th to 20th.

I will speak at November 19th, at 4 pm at room “Shanghai”:

1000 mal schneller – Praxisgeschichten aus der Oracle-Datenbankwelt

(English: “1000 times faster – Real life stories from the world of Oracle Databases”)

 

The DOAG is the largest German Oracle user group with over 5000 members.

2014-08-04-DOAG-2014-Konferenz-Banner-Speaker-Highlighnen-180x150

SQL-Developer: Using macros – Update for version 4.01 ++

[This is a follow up to post SQL-Developer: Using macros]

Has the macro function been dropped?

I got a question from “Bob Thompson“, he asked if the macro function has been removed in SQL Developer version 4.01.
So I tried to use the function on my computer and it still worked.
But then I looked in the preferences (menu “Tools/Preferences”) under “Shortcut Keys”: the macro commands are no loger there!

Dont panik!

The macro feature is still there, what’s missing from version 4.01 on is the ability to add the neccessary shortcut keys via the preferences window.
That’s why it still working on my computer – the update to version 4.01 took over the settings for the shortcut keys.

Workaround

Here is workaround to add the shortcut keys for macro recording and playback manually:

  1. Quit Oracle SQL Developer
    .
  2. Look for the file settings.xml in the following folder:
    %USERPROFILE%\AppData\Roaming\SQL Developer\system4.0.1.14.48\o.ide.12.1.3.2.41.140207.1351\settings.xml
    On some systems it might be in a different place:
    %USERPROFILE%\Application Data\Sql Developer\system4.0.1.14.48\o.ide.12.1.3.2.41.140207.1351\settings.xml
    .
  3. Open the file settings.xml with the text editor of your choice.
  4. Search for the following section in the file:
       oracle/ide/ceditor/keymap/accelerators.xml
          oracle.ide.keyboard.KeyStrokeMap">
             <data>
    
  5. Add the following lines underneath the tag “<data>”:
    <Item class="oracle.javatools.util.Pair">
       <first class="java.lang.String">toggle-macro-recording</first>
       <second class="oracle.ide.keyboard.KeyStrokes">
          <data>
             <Item class="javax.swing.KeyStroke">shift control PERIOD</Item>
          </data>
       </second>
    </Item>
    <Item class="oracle.javatools.util.Pair">
       <first class="java.lang.String">playback-macro</first>
       <second class="oracle.ide.keyboard.KeyStrokes">
          <data>
             <Item class="javax.swing.KeyStroke">control PERIOD</Item>
          </data>
       </second>
    </Item>
    
  6. The final result should look like this:
       oracle/ide/ceditor/keymap/accelerators.xml
          oracle.ide.keyboard.KeyStrokeMap">
             <data>
                <Item class="oracle.javatools.util.Pair">            
                   <first class="java.lang.String">toggle-macro-recording</first>
                   <second class="oracle.ide.keyboard.KeyStrokes">
                      <data>
                         <Item class="javax.swing.KeyStroke">shift control PERIOD</Item>
                      </data>
                   </second>
                </Item>
                <Item class="oracle.javatools.util.Pair">
                   <first class="java.lang.String">playback-macro</first>
                   <second class="oracle.ide.keyboard.KeyStrokes">
                      <data>
                         <Item class="javax.swing.KeyStroke">control PERIOD</Item>
                      </data>
                   </second>
                </Item>
    
  7. Save the file.
    .
  8. Restart Oracle SQL-Developer and use the macro function as describe here:
    SQL-Developer: Using macros

 

Additional informations can be found in these OTN Community posts: