Performance Tuning in Oracle

Oracle9i’s principle-based approach, the principles for Tuning, in order of priority, are:

  1. Define the problem clearly and then formulate a tuning goal.
  2. Examine the host system and gather Oracle statistics.
  3. Compare the identified problem to the common performance problems identified by Oracle in the Oracle9i Database Performance Methods (Release 1)/Database Performance Planning (Release 2).
  4. Use the statistics gathered in the second step to get a conceptual picture of what might be happening on the system.
  5. Identify the changes to be made and then implement those changes.
  6. Determine whether the objectives identified in step one have been met. If they have, stop tuning. If not, repeat steps five and six until the tuning goal is met.

Read more here.

Read an important article here.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s