SQL-Developer: Create External Tool dialog – Macros (“variables”)

You can use the folloeing commands in “Arguments” and “Run Directory” sections of the “Create External Tool” dialog:

Macro Meaning
${sqldev.conn} DB Connection String
${sqldev.dbuser} DB UserName
${env:var=} Environment Variable
${file.dir} File Directory
${file.ext} File Extension
${file.name} File Name
${file.name.no.ext} File Name Without Extension
${file.path} File Path
${file.url} File URL
${ide.name} IDE Application Name
${ide.classpath} IDE Classpath
${ide.dir} IDE Install Directory
${ide.oracle.dir} IDE Oracle Home Directory
${ide.user.dir} IDE User Directory
${prompt} Prompt
${promptl:=} Prompt with Label
${prop:name=} System Property

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