Thresholds can be set such that the dashboard
informs you when a particular resource is nearing a critical usage level. Enterprise
Manager includes a set of advisors, which can be run to give you suggestions on how
to tune your applications or optimize performance in the Oracle database.
For tuning your applications, you??™ll likely look to the SQL Advisor. Introduced in
Oracle Database 11g, it combines the functionality of the SQL Tuning Advisor, the
SQL Access Advisor, and the new Partition Advisor. The SQL Advisor leverages
information on CPU and I/O consumption captured in the AWR and identifies highimpact
SQL statements indicated by the ADDM to make recommendations. The
advisor checks to make sure statistics are not stale, identifies optimal paths through
SQL profiling, determines if the addition of indexes, materialized views, or other
database structures would be beneficial, and indicates whether changes to the highimpact
SQL statements would improve efficiency.
Key database tuning advisors include:
Memory Advisor
For optimal setting of MEMORY_TARGET for automatic memory management
in Oracle Database 11g (described later in this chapter) and optimal setting
of SGA_TARGET for shared memory management
158 | Chapter 7: Oracle Performance
Segment Advisor
For storage management and space allocation
Undo Advisor
For managing transactions
Other advisors, such as the Mean Time to Recovery (MTTR) Advisor, optimize the
setup of Oracle, including log files.
Pages:
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355