SQL developer Problems and Solutions

Unable to start. After "unable to create an instance..." is downloaded, run the following message:

---------------------------
Unable to create an instance of the Java Virtual Machine
Located at path:
<Sqldeveloper> \ JDK \ JRE \ bin \ Client \ JVM. dll
---------------------------

The reason is that the JVM parameter settings are incorrect. There are two solutions:

Solution 1:

<Sqldeveloper> \ ide \ bin \ ide. conf
Modify the file and set the "addvmoption-xmx" parameter as follows:
Addvmoption-xmx256m
Then it starts up normally.

Solution 2:
The setting is different, and the principle is the same:
Edit the file sqldeveloper \ jdev \ bin \ sqldeveloper. conf,
Add a row:
Addvmoption-xmx256m

Newline, copy, and copy are not allowed in worksheet.

It is okay to use it all the time. Suddenly the above situation occurs one day.
Solution:
1. Tools --> preferences --> accelerators -->

2. Find the load preset... button and click the pop-up page.

3. Select default and click OK.

4. Restart SQL developer.

How to display all records when searching

The cause of this problem is as follows:

Develop a report function with a large amount of data, use SQL statements to get data, and use SQL developer to execute SQL quickly. The execution is completed in less than 1 second.

Thus it was fooled, and JDBC was used for fishing. It took about 60 seconds for 6000 of the data.

As you may not know, when SQL developer executes a search, only 50 records are found each time. When you drag the scroll bar, you can go to the database for retrieval.

How to set more records at a time:

Find

Tools -- "Preferences --" databases -- "advanced"

Click "advanced" and select "SQL data extraction size". In the input column, modify this setting.

In some versions, for example, "version 3.2.09", the maximum value is 500. If the value exceeds 500, it cannot be entered.

There are also solutions to this problem.

In fact, these configurations are written in the C: \ Documents ents and Settings \ user_name \ Application Data \ SQL developer directory.

Find a subdirectory like system3.2.09.30 \ O. SQL ).11.2.0.9.30 that has a configuration file for the product-preferences.xml.

1. Disable SQL developer first

2. Find a configuration similar to the following

<Hash n = "dbconfig"> <value n = "arrayfetchsize" V = "50"/> <value n = "defaultpath" V = ""/> <value n =" diff_encoding "V =" GBK "/> <value n =" diff_gen_comments "V =" false "/> <value n =" diff_gen_constraint "V =" true "/> <value n = "diff_gen_constraint_indexes" V = "true"/> <value n = "diff_gen_pass_value" V = "true"/> <value n = "diff_gen_ref_constraints" V = "true"/> <value n = "diff_gen_schema" V = "true"/> <value n = "diff_gen_script" V = "true"/> <value n = "diff_gen_ SQL _term" V = "true "/> <value n = "diff_ign_high_values" V = "false"/> <value n = "diff_ign_partitioning" V = "false"/> <value n = "diff_ign_schema" V = "true "/> <value n =" diff_ign_segments "V =" true "/> <value n =" diff_ign_storage "V =" true "/> <value n =" diff_ign_tablespace "V = "True"/> <value n = "diff_ign_tbl_col_pos" V = "true"/> <value n = "diff_log_compare" V = "true"/> <value n = "diff_match_constraints_name" V = "false"/> <value n = "diff_open_tgt" V = "true"/> <value n = "diff_rpt_constraint_name" V = "false"/> <value n =" diff_save_as_type "V =" 0 "/> <value n =" diff_statistics "V =" false "/> <value n =" diffdir "V =" D: \ "/> 
Modify the value of "arrayfetchsize.
You may be interested. After modifying the configuration file, what will be displayed in the "SQL data extraction size" configuration bar? The answer is nothing.