Using Google Chrome?

Download my
free Chrome Extension, Power Notes Searcher, to make searching for and evaluating SAP notes, much easier.

Thursday, June 20, 2013

Oracle 11g Methods of Performance Tuning SQL

Print Friendly and PDF

>90% of upgrade related problems are performance issues after an upgrade.

Source: Oracle Corp

Oracle tools for helping you tune the database:
  • Statspack - FREE - (See note 394937.1)

  • AWR - Diagnostics Pack & Tuning Pack license required.

  • Real Application Testing (Features: SQL Performance Analyser & Database Replay) - Tuning Pack license required.

Since 11g, Oracle recommend, instead of: storing outlines, fixing stats, using SQL hints, using the Rule Based Optimiser (desupported); you should use the SQL Plan Management tool along with SQL Profiling.

See spm_white_paper_ow07.pdf for more information.

No comments: