Oracle Performance Tuning and optimization (III.)

As mentioned in parts 1th and 2nd, there are several relatively easy steps to improve performance you can take, one of these steps involves using an automated tool to "guide" you to write SQL statements, there are many production performance analysis or performance tuning tool manufacturers, in the following article, We will examine one of them.

Quest Software

Many DBAs and developers use a tool called Toad, which comes from Quest Software, which, according to Quest Software website, has about 500,000 users in the Toad user community, and one feature of Toad is its ability to optimize SQL queries, In other words, the Oralce company has not yet occupied the market for adjusting the type of consultant tools.

About Consulting tools you have a variety of options to understand what they are doing, and if you're not working in a production or development environment what do you use them for? Maybe just like, even if you are in a development environment, but you may not use very large data, this article focuses on how to generate a lot of data, we will introduce another product of Quest Software: DataFactory for Oracle.

DataFactory

The purpose of DataFactory is to quickly create meaningful test data for a variety of database platforms, including Oracle, DB2, Sybase, and ODBC-compliant databases, with a normal retail price of $595 per server, in quest Software's website has a free 30-day version to download.

To get this software (is currently 5.5.) 0 version), you must register with a real email address, Hotmail and Gmail will be rejected, once you register successfully, you will receive a message containing the key to unlock the application and start a 30-day trial.

The installation process is fairly simple, and if you run Microsoft's antispyware, you may receive one or more errors that disable real-time protection after reinstalling.

Create a Secondary object

A good way to learn about an application is to use its helper objects, and the general process is:

1. Create a project

2. Create a table in a scenario

3. Run script Load data

Unfortunately, the best way to get a refresh on a constraint that disables the system name reference is to use the built-in helper object, using a repetitive processing method, you can disable all constraints until the load script runs without errors, however, when the Quest runtime fixes the bug, I can identify and disable the constraint.

After starting the DataFactory, you can choose to start the self-study textbook, and the instructions on how to load the Self-Study object (that is, all the help) are in the HTML file.