SQL Developer Tool Small test

1 Installation Configuration

have been using Toad to manage the database, today, a small study of SQL Developer tools, after the installation of ORACLE, the default installation of SQL Developer, the installation directory is $oracle_home/sqldeveloper, The first time you start will be prompted to enter the Java directory, note that the requirement here is JAVASE,JRE not.

If it is a JRE, the following error will be reported.

Javase:

Http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html

Of course, there may also be another error:

If the above error is reported, because the SQL Developer version and the javase version are inconsistent, such as Javase is 64-bit, SQL Developer is 32-bit. This problem can be modified Java version, or from the official website to download the SQL Developer version, the tool can be downloaded separately, after the download is done to replace the $oracle_home/sqldeveloper.

：

Http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

After installation, the following is done:

2 Testing

2.1 New features

At the start of the interface, speaking of new features in SQL developer, at first glance, there is a bit of management capability, which is stronger than PL/SQL Dev.

2.2 Connecting the database

Standard connection interface, nothing to say.

2.3 Writing SQL

In addition to the ability to execute SQL, you can perform a performance analysis of SQL, view the execution plan, and use this to optimize SQL, you can save some effort.

2.4 Viewing reports

Reporting is a key feature, at least when it comes to performance analysis, and it's useful to avoid the hassle of tapping your code. Directly look at the picture, very intuitive, not much to say.

Is the function so powerful that there is no disadvantage? See:

The memory consumption is more serious ah, but more than 8G of the machine, run this, should still be no pressure.

Summarize:

(1) SQL Developer can execute SQL statements and provide optimizations for SQL.

(2) have the ability to view reports, note here is the view, that is, we can see these performance-related indicators, but can not be modified, so more is to provide some suggestions.

(3) Java tools, a bit of memory consumption.

--------------------------------------------------------------------------------------------

All rights reserved, the article prohibits reprint, otherwise investigates the legal liability!

Aboutdave:

--------------------------------------------------------------------------------------------

qq:251097186

Email: [email protected]

Blog:http://blog.csdn.net/tianlesoftware

Weibo:http://weibo.com/tianlesoftware

Twitter:http://twitter.com/tianlesoftware

Facebook:http://www.facebook.com/tianlesoftware

Linkedin:http://cn.linkedin.com/in/tianlesoftware

Dave's QQ Group:

--------------------------------------------------------------------------------------------

Note: Add group must indicate tablespace and data file relationship | Do not repeat the addition group

cndba_1:62697850 (empty) cndba_2:62697716 (full) cndba_3:283816689

cndba_4:391125754 cndba_5:104207940 cndba_6:62697977 cndba_7:142216823 (full)

SQL Developer Tool Small test