لطفا منتظر باشید ...
• Table of Contents• Index• Reviews• Reader Reviews• Errata• AcademicOracle Essentials: Oracle Database 10g, 3rd EditionBy
Publisher: O''ReillyPub Date: February 2004ISBN: 0-596-00585-7Pages: 368
This new edition distills a vast amount of knowledge into an
easy-to-read volume covering the full range of Oracle''s
features and technologies. The book includes an overview of
Oracle 10g, along with recent releases 9i and 8i.
Oracle Essentials 3rd Edition: Oracle Database
10g provides everything you''ll need to install
and run the Oracle databases. If you''re new to Oracle or
upgrading to Oracle 10g, you''ll find this comprehensive
guide essential.
4.9 SQL Tuning Advisor
Oracle Database 10g
includes a new tool called the SQL Tuning Advisor. This tool performs
advanced optimization analysis on selected SQL statements, using
workloads that have been automatically collected into the Automatic
Workload Repository (AWR) or that you have specified yourself. Once
the optimization is done, the SQL Tuning Advisor makes
recommendations, which could include updating statistics, adding
indexes, or creating an SQL Profile. This Profile is stored in the
database and is used as the optimization plan for future executions
of the statement, which allows you to
"fix" errant SQL plans without
having to touch the underlying SQL.
