Last Updated: 23-MAY-2006

The following are Frequently Asked Questions (FAQs) about Oracle SQL Developer.

Questions
1. How do I know if I am running the current, production release?
2. How do I launch SQL Developer in debug mode to capture any runtime errors?
3. Can I suppress Code Insight (and why would I want to)?
4. I am experiencing screen redraw issues. Is there anything I can do?

1. How do I know if I am running the current, production release?

The initial production release was 1.0.0.14.67.
To update, you can either run Check for Updates or download the latest full release.
If you run Check for Updates, your base version number will not be changed. The changes will be reflected on the Extensions tab.

Below are screen snaps of what your Help > About should look like if you had the production release installed and then did a Check for Updates.


Another way to get the latest release is to do a new installation using the latest download. Below is a screen snap of what your Help > About should look like if you have installed the full patch 2 release.

2. How do I launch SQL Developer in debug mode to capture any runtime errors?

To see the errors reported to the console:

   On Windows, from a command prompt, cd to the /jdev/bin.
   Then run the sqldeveloper.exe.

   On Linux, these error will be visible from running sqldeveloper.

To see sql which is being execute:

   Edit the <sqldeveloper>/jdev/bin/sqldeveloper.conf.
   Change this line

   #AddVMOption  -Daudit.trace=db_api

   AddVMOption  -Daudit.trace=db_api

3. Can I suppress Code Insight (and why would I want to)?

Code Insight allows you to type in 'SELECT EMP.' within the SQL Worksheet and bring up a list of columns within the EMP table to select from. This feature can slow the performance of SQL Developer against a schema with a large number of tables and views. Code Insight can be disabled with the following change.

Run SQL Developer from a command line using the following statement:

Windows :

   sqldeveloper -J-Dsdev.insight=false

   Run sh sqldeveloper -J-Dsdev.insight=false

   AddVMOption -J-Dsdev.insight=false

4. I am experiencing screen redraw issues. Is there anything I can do?

Some users have experienced problems with screen corruption when scrolling through a long list of objects. If you have this problem, you can try the following fix. It helps on Windows and Linux but is untested on the Mac.

Start SQL Developer with the following flag:

   sqldeveloper  -J-Dsun.java2d.ddoffscreen=false

Discuss this in the OTN Oracle SQL Developer Forum.