Content Inside :
SQL tuning is a very critical aspect of database performance tuning. It is an inherently complex activity requiring a high level of expertise in several domains: query optimization, to improve the execution plan selected by the query optimizer; access design, to identify missing access structures; and SQL design, to restructure and simplify the text of a badly written SQL statement. This feature is exposed to the user through both graphical and command line interfaces. The Automatic SQL Tuning is an integral part of the Oracle‘s framework for self-managing databases. Enable the query optimizer to find a better plan by: a. Gathering or refreshing the data statistics it uses to build an execution plan. For example, by creating a histogram on a column that contains skewed data. Typically the database administrator (DBA) or an application developer performs the tuning process. However, it is often a challenging task even for a tuning expert. Finally, the Automatic SQL Tuning feature is fully integrated in the Oracle 10g anageability framework making it an end-to-end solution to the SQL tuning challenges [7]. SQL Tuning Life Cycle in Oracle 10g.
Tags:command line interfaces, execution plan, sql tuning, oracle 10g, query optimization
If you see unrelated pdf files with the description or copyrighted material published, please report to us, we'll correct/delete it it as soon as possible.NONE OF THOSE MATERIALS ARE HOSTED IN THIS SERVER NOR UPLOADED BY ME IN SOMEONE'S SERVERS. Read our DISCLAIMER for more detail.
We are neither affiliated with authors and brands nor responsible for its content and change of content.
Information contained herein is provided "as is" without warranty of any kind, either expressed or implied, including any warranty of merchantability or fitness for a particular purpose. In no event shall ANYONE be held liable for any loss of profit, special, incidental, consequential, or other similar claims.