 |
|
|
Oracle10g database provides DBAs with a unique set of intelligent advisor tools that are able to significantly reduce analysis and tuning efforts. This chapter has given a high level overview for using these advisors and their associated packages.
This chapter did not cover the non-tuning related advisor tools Oracle10g such as the Segment Advisor, and the Undo Advisor, but more information regarding these advisors will be presented in subsequent chapters of this book.
The main points of this chapter include: § The dbms packages in Oracle10g provide an easy interface to complex automation performance tools. § The dbms_workload_repository package allows the DBA to manage the AWR, setting snapshot intervals and data retention periods. § The dbms_advisor package provides PL/SQL API to access the Automatic Database Diagnostic Monitor (ADDM) and SQLAccess Advisor. § ADDM is implemented with the powerful dbms_advisor package. § The SQL Access advisor is implemented with the dbms_sqltune package. § ADDM can be used to provide intelligent analysis of the changes that occur during a snapshot period and makes automated recommendations. ADDM does not replace the intelligence of the DBA, who must still understand Oracle10g tuning concepts. § The SQLAccess advisor provides analysis of all SQL executions for the snapshot intervals and rudimentary suggestions to improve SQL execution speed using SQL profiles. The SQLAccess advisor does not perform advanced SQL tuning and the DBA still must understand SQL execution internals, hints and table join methods. The next chapter will present information on the new time model tuning approach that is used by all tuning advisors and tools within Oracle.
|
|
|
